Access 2003: Advanced

Second Edition

Topic-Level Outline

†††††††††††††††††††††††† Days:1

†††††††† Prerequisites:Access 2003: Intermediate or equivalent experience

†††††††††††††††††††††††† Unit 1 :Querying with SQL

†††††††††††††††††††††††††††††† Topic A: 0SQL and Access

†††††††††††††††††††††††††††††† A-1:†††††††††††††††††††††††††††††† Discussing Structured Query Language

†††††††††††††††††††††††††††††† A-2:†††††††††††††††††††††††††††††† Examining an SQL statement in Access

†††††††††††††††††††††††††††††† Topic B: 0Writing 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: 0Attaching SQL queries to controls

†††††††††††††††††††††††† C-1:†††††††††††††††††††††††† Assigning an SQL-specific query to a command button

†††††††††††††††††††††††† Unit 2 :Advanced queries

†††††††††††††††††††††††††††††† Topic A: 0Creating crosstab queries

†††††††††††††††††††††††††††††† A-1:†††††††††††††††††††††††††††††† Viewing a crosstab query

†††††††††††††††††††††††††††††† A-2:†††††††††††††††††††††††††††††† Using the Crosstab Query Wizard

†††††††††††††††††††††††††††††† Topic B: 0Creating 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: 0Using 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: 0Creating, running, and modifying macros

†††††††††††††††††††††††††††††† A-1:†††††††††††††††††††††††††††††† Creating and running a macro

†††††††††††††††††††††††††††††† A-2:†††††††††††††††††††††††††††††† Modifying a macro

†††††††††††††††††††††††††††††† Topic B: 0Attaching 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: 0Creating macros to provide user interaction

†††††††††††††††††††††††††††††† A-1:†††††††††††††††††††††††††††††† Creating a data validation macro

†††††††††††††††††††††††††††††† A-2:†††††††††††††††††††††††††††††† Creating a data-entry macro

†††††††††††††††††††††††††††††† Topic B: 0Creating macros that require user input

†††††††††††††††††††††††††††††† B-1:†††††††††††††††††††††††††††††† Creating a macro that runs a parameter query

†††††††††††††††††††††††††††††† Topic C: 0Creating the AutoKeys and AutoExec macros

†††††††††††††††††††††††††††††† C-1:†††††††††††††††††††††††††††††† Creating an AutoKeys macro

†††††††††††††††††††††††††††††† C-2:†††††††††††††††††††††††††††††† Creating an AutoExec macro

†††††††††††††††††††††††††††††† Topic D: 0Creating 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: 0Importing objects

†††††††††††††††††††††††††††††† A-1:†††††††††††††††††††††††††††††† Importing multiple objects

†††††††††††††††††††††††††††††† A-2:†††††††††††††††††††††††††††††† Importing an object from Excel

†††††††††††††††††††††††††††††† Topic B: 0Exporting objects

†††††††††††††††††††††††††††††† B-1:†††††††††††††††††††††††††††††† Exporting an object

†††††††††††††††††††††††††††††† Topic C: 0Interacting with the XML documents

†††††††††††††††††††††††††††††† C-1:†††††††††††††††††††††††††††††† Exporting and importing XML documents

†††††††††††††††††††††††††††††† C-2:†††††††††††††††††††††††††††††† Exporting to an XML document with an XSL file

†††††††††††††††††††††††††††††† Topic D: 0Linking Access objects

†††††††††††††††††††††††††††††† D-1:†††††††††††††††††††††††††††††† Linking objects

†††††††††††††††††††††††††††††† D-2:†††††††††††††††††††††††††††††† Updating the links

†††††††††††††††††††††††††††††† Topic E: 0Working with Windows SharePoint Services

†††††††††††††††††††††††† E-1:†††††††††††††††††††††††† Discussing Windows SharePoint Services

†††††††††††††††††††††††† Unit 6 :Database management

†††††††††††††††††††††††††††††† Topic A: 0Optimizing 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: 0Replicating and synchronizing databases

†††††††††††††††††††††††† B-1:†††††††††††††††††††††††† Replicating a database

†††††††††††††††††††††††† B-2:†††††††††††††††††††††††† Synchronizing replicated databases

†††††††††††††††††††††††† Unit 7 :Security fundamentals

†††††††††††††††††††††††††††††† Topic A: 0Protecting databases

†††††††††††††††††††††††††††††† A-1:†††††††††††††††††††††††††††††† Setting a password to a database

†††††††††††††††††††††††††††††† A-2:†††††††††††††††††††††††††††††† Removing a password

†††††††††††††††††††††††††††††† Topic B: 0Encrypting and decrypting databases

†††††††††††††††††††††††††††††† B-1:†††††††††††††††††††††††††††††† Encrypting a database

†††††††††††††††††††††††††††††† B-2:†††††††††††††††††††††††††††††† Decrypting a database

†††††††††††††††††††††††††††††† Topic C: 0User-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: 0Comprehensive exam objectives