Second Edition
Topic-Level Outline
Days: 1
Prerequisites: Access
2003: Intermediate or equivalent experience
Unit 1 : Querying with SQL
Topic A: SQL and Access
A-1: Discussing Structured Query Language
A-2: Examining an SQL statement in Access
Topic B: Writing SQL statements
B-1: Writing an SQL SELECT statement
B-2: Using the WHERE clause
B-3: Displaying matching records from related tables
B-4: Finding unmatched records
B-5: Getting context-sensitive help in SQL
Topic C: Attaching SQL queries to controls
C-1: Assigning an SQL-specific query to a command button
Unit 2 : Advanced queries
Topic A: Creating crosstab queries
A-1: Viewing a crosstab query
A-2: Using the Crosstab Query Wizard
Topic B: Creating parameter queries
B-1: Creating a single criterion parameter query
B-2: Creating a query with multiple parameters
B-3: Using a wildcard in a parameter query
Topic C: Using action queries
C-1: Adding records to a table with an append query
C-2: Deleting records with a delete query
C-3: Modifying records with an update query
C-4: Creating a make-table query
Unit 3 : Macros
Topic A: Creating, running, and modifying macros
A-1: Creating and running a macro
A-2: Modifying a macro
Topic B: Attaching macros to the events of database objects
B-1: Attaching a macro to the Open event of a form
B-2: Attaching a macro to a command button
B-3: Using a macro to resize and move a form’s window
Unit 4 : Advanced macros
Topic A: Creating macros to provide user interaction
A-1: Creating a data validation macro
A-2: Creating a data-entry macro
Topic B: Creating macros that require user input
B-1: Creating a macro that runs a parameter query
Topic C: Creating the AutoKeys and AutoExec macros
C-1: Creating an AutoKeys macro
C-2: Creating an AutoExec macro
Topic D: Creating macros for data transfer
D-1: Importing a database object by using a macro
D-2: Exporting data to a spreadsheet by using a macro
Unit 5 : Importing, exporting, and linking objects
Topic A: Importing objects
A-1: Importing multiple objects
A-2: Importing an object from Excel
Topic B: Exporting objects
B-1: Exporting an object
Topic C: Interacting with the XML documents
C-1: Exporting and importing XML documents
C-2: Exporting to an XML document with an XSL file
Topic D: Linking Access objects
D-1: Linking objects
D-2: Updating the links
Topic E: Working with Windows SharePoint Services
E-1: Discussing Windows SharePoint Services
Unit 6 : Database management
Topic A: Optimizing resources
A-1: Converting a database to a prior version
A-2: Analyzing performance
A-3: Splitting a database
A-4: Using the Compact and Repair Database utility
A-5: Backing up a database
Topic B: Replicating and synchronizing databases
B-1: Replicating a database
B-2: Synchronizing replicated databases
Unit 7 : Security fundamentals
Topic A: Protecting databases
A-1: Setting a password to a database
A-2: Removing a password
Topic B: Encrypting and decrypting databases
B-1: Encrypting a database
B-2: Decrypting a database
Topic C: User-level security
C-1: Providing security by using Security Wizard
C-2: Creating a new user group
C-3: Specifying permissions on database objects
C-4: Transferring the ownership of a database object
Appendix A : Microsoft Office Specialist exam objectives map
Topic A: Comprehensive exam objectives