A210L3	Microsoft Access 2010 Mastery

Course Duration: 1 Day	Class Time: 9 am - 4:30 pm

Audience Profile

Students will get the most out of this course if their goal is to become proficient in more advanced tasks, such as querying with SQL: using crosstab. parameter. and action queries; creating and running macros: importing. exporting. and linking database objects; optimizing databases: and implementing basic database security.

At Course Completion

After completing this course, students will be able to:

• Use SQL statements in Access: create aliases for fields: write SQL statements to create queries: and attach a SQL statement to a command button.

• Create crosstab queries to summarize grouped data: create parameter queries to view results based on specified criteria: and create action queries to add. delete, and modify data in tables and to make new tables.

• Create and run macros to automate tasks: and attach macros to the events of database objects.

• Create data validation and data entry macros: create macros that run parameter queries: create AutoKeys and AutoExec macros: and create macros to import and export database objects.

• Import Access objects from another Access database. from Excel. and from a CSV file: export objects from one database to another: export and import XN’IL documents: save objects as XPS files: link Access objects between databases and to Excel workbooks: and create hyperlink fields.

• Save databases in file formats for previous versions of Access: use the Performance Analyzer: split, compact. repair. and back up databases: encrypt and password-protect database files: configure Access Options: and populate database file properties.

Skills Presented

Discussing and examining SQL statements in Access Writing SQL statements Creating aliases for fields Attaching a SQL query to a control in a form Viewing a crosstab query and using the Crosstab Query Wizard Creating single-criterion and multiple-criteria parameter queries Using action queries to append, delete, and modify records in tables and to create tables Creating and running macros Attaching macros to the events of forms and to command buttons Creating data validation, data entry, and user-input macros Creating macros that run parameter queries Creating AutoKeys and AutoExec macros Creating macros for data transfer between Access and other applications

Importing objects from Access databases and Excel worksheets Creating a Saved Import specification Exporting objects to another Access database Creating and using a Saved Export specification Exporting and importing XML documents Saving an object as an XPS file Linking database objects Using the Linked Table Manager to update links Linking to an Excel worksheet Creating a hyperlink field and entering data into it Analyzing database performance Splitting, compacting, repairing, and backing up a database Assigning and removing passwords and encryption Opening a database in exclusive mode Configuring Access Options Populating database file properties

Course Outline

Lesson 1 — Querying with SQL

• SQL and Access
• Writing SQL statements
• Attaching SQL queries to controls

Lesson 2 — Advanced Queries

• Creating crosstab queries
• Creating parameter queries
• Using action queries

Lesson 3 — Macros

• Creating, running, and modifying macros
• Attaching macros to the events of database objects

Lesson 4 — Advanced Macros

• Creating macros to provide user interaction
• Creating macros that require user input
• Creating the AutoKeys and AutoExec macros
• Creating macros for data transfer

Lesson 5 — Importing, Exporting, and Linking

• Importing objects
• Exporting objects
• Interacting with XML documents
• Linking Access objects
• Hyperlink fields

Lesson 6 — Database Management

• Optimizing resources
• Protecting databases
• Setting options and properties
  

Student Prerequisites

Access 2010 Advanced or equivalent working knowledge of all skills presented in that course.