Access 2007:
Advanced

Topic-Level Outline

Days: 1

Prerequisites: Access 2007: 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 Working with Windows SharePoint Services

E-1: Discussing Windows SharePoint Services

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

Unit 7 : Internet integration

Topic A: 0 Hyperlink fields

A-1: Creating a hyperlink field

A-2: Inserting data in a hyperlink field

A-3: Modifying data in a hyperlink field

Topic B: 0 Working with Outlook 2007

B-1: Collecting data via e-mail