Access 2007: Advanced

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