Access 2013: Advanced

Microsoft Office Access 2013

Advanced

Topic-Level Outline

�� Days:� 1

�� Prerequisites:� Microsoft Office Access 2013 Intermediate, or equivalent

�� Unit 1�:� Querying with SQL

�� Topic A: 0� SQL and Access

�� A-1:�� Discussing Structured Query Language

�� A-2:�� Examining a SQL statement in Access

�� Topic B: 0� 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: 0� Attaching SQL queries to controls

�� C-1:�� Assigning a 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 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

�� B-2:�� Examining VBA

�� Topic C: 0� Creating 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 XML documents

�� C-1:�� Exporting and importing XML documents

�� C-2:�� Exporting 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 options

�� C-2:�� Creating and populating database properties