Advanced
Topic-Level Outline
Days: 1
Prerequisites: Microsoft Office Access 2013 Intermediate, or equivalent
Unit 1
: Querying with SQLTopic A: SQL and Access
A-1: Discussing Structured Query Language
A-2: Examining a SQL statement in Access
Topic B: Writing SQL statements
B-1: Writing a 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 on SQL
Topic C: Attaching SQL queries to controls
C-1: Assigning a SQL query to a command button
Unit 2
: Advanced queriesTopic A: Creating crosstab queries
A-1: Viewing a crosstab query
A-2: Using the Crosstab Query Wizard
Topic B: 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: 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
: MacrosTopic A: Creating, running, and modifying macros
A-1: Creating and running a macro
A-2: Modifying a macro
Topic B: 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 macrosTopic A: Creating macros to provide user interaction
A-1: Creating a data validation macro
A-2: Creating a data entry macro
Topic B: Creating macros that require user input
B-1: Creating a macro that runs a parameter query
B-2: Examining VBA
Topic C: Creating AutoKeys and AutoExec macros
C-1: Creating an AutoKeys macro
C-2: Creating an AutoExec macro
Topic D: 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 objectsTopic A: 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: Exporting objects
B-1: Exporting an object
B-2: Using a saved export specification
Topic C: Working with XML documents
C-1: Exporting and importing XML documents
C-2: Exporting a table as an XPS file
Topic D: Linking Access objects
D-1: Linking to an Access table
D-2: Updating links
D-3: Linking to an Excel workbook
Topic E: 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 managementTopic A: 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: Protecting databases
B-1: Encrypting a database with a password
B-2: Removing a password and encryption
Topic C: Setting options and properties
C-1: Setting options
C-2: Creating and populating database properties