Access 2010:

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 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 input

                               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

                               B-2:                               Examining VBA

                               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 objects

                               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  Working with the XML documents

                               C-1:                               Exporting and importing XML documents

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

                               C-3:                               Saving a table as an XPS file

                               Topic D: 0  Linking Access objects

                               D-1:                               Linking to an Access table

                               D-2:                               Updating links

                               D-3:                               Linking to an Excel workbook

                               Topic E: 0  Using 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 database properties