Access 2010: Advanced

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