Access 2010:
Advanced

Topic-Level Outline

Days:  1

          Prerequisites: Access 2010: Intermediate or equivalent experience

                         Unit 1 :  Querying with SQL

Topic A: 0  SQL and Access

A-1:                               Discussing Structured Query Language

A-2:                               Examining an SQL statement in Access

Topic B: 0  Writing SQL statements

B-1:                               Writing an SQL SELECT statement

B-2:                               Using the WHERE clause

B-3:                               Creating aliases

B-4:                               Displaying matching records from related tables

B-5:                               Finding unmatched records

B-6:                               Getting context-sensitive help in SQL

Topic C: 0  Attaching SQL queries to controls

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

                         Unit 2 :  Advanced queries

Topic A: 0  Creating crosstab queries

A-1:                               Viewing a crosstab query

A-2:                               Using the Crosstab Query Wizard

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

A-1:                               Creating and running a macro

A-2:                               Modifying a macro

Topic B: 0  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

                         Unit 4 :  Advanced macros

Topic A: 0  Creating macros to provide user interaction

A-1:                               Creating a data validation macro

A-2:                               Creating a data-entry macro

Topic B: 0  Creating macros that require user input

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

Topic C: 0  Creating the AutoKeys and AutoExec macros

C-1:                               Creating an AutoKeys macro

C-2:                               Creating an AutoExec macro

Topic D: 0  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

Topic A: 0  Importing objects

A-1:                               Importing multiple objects

A-2:                               Importing an object from Excel

A-3:                               Using a Saved Import specification

A-4:                               Importing a CSV file

Topic B: 0  Exporting objects

B-1:                               Exporting an object

B-2:                               Using a Saved Export specification

Topic C: 0  Interacting with XML documents

C-1:                               Exporting and importing XML documents

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

C-3:                               Saving to an XPS file

Topic D: 0  Linking Access objects

D-1:                               Linking to an Access table

D-2:                               Updating the links

D-3:                               Linking to an Excel workbook

Topic E: 0  Hyperlink fields

E-1:                         Creating a hyperlink field

E-2:                         Inserting data in a hyperlink field

E-3:                         Modifying data in a hyperlink field

                         Unit 6 :  Database management

Topic A: 0  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: 0  Protecting databases

B-1:                               Encrypting a database with a password

B-2:                               Removing a password and encryption

Topic C: 0  Setting options and properties

C-1:                                                                                                                                                                                           Setting Access Options

C-2:                                                                                                                                                                                           Creating and populating properties