Access 2007: Level 3
Class Outline:
Description:
This course builds on the skills and concepts taught in Access 2007: Level 2. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data. This course will help students prepare for the Access 2007 exam (70-605). For comprehensive certification training, students should complete Access 2007: Levels 1, 2 and 3.
Table of Contents:
Unit 1: Querying with SQL
Topic A: SQL and Access
Topic B: Writing SQL statements
Topic C: Attaching SQL queries to controls
Unit 2: Advanced queries
Topic A: Creating crosstab queries
Topic B: Creating parameter queries
Topic C: Using action queries
Unit 3: Macros
Topic A: Creating, running, and modifying macros
Topic B: Attaching macros to the events of database objects
Unit 4: Advanced macros
Topic A: Creating macros to provide user interaction
Topic B: Creating macros that require user input
Topic C: Creating the AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer
Unit 5: Importing, exporting, and linking objects
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Interacting with the XML documents
Topic D: Linking Access objects
Topic E: Working with Windows SharePoint Services
Unit 6: Database management
Topic A: Optimizing resources
Topic B: Replicating and synchronizing databases
Unit 7: Security fundamentals
Topic A: Protecting databases
Topic B: Encrypting and decrypting databases
Topic C: User-level security
Objectives:
-Use SQL statements and examine them in Access, create aliases for fields, write SQL statements to create queries, and attach an 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 the AutoKeys and AutoExec macros, and create macros to import and export database objects.
-Save to previous versions. Split, compact, repair, and back up a database. Encrypt and password-protect database files. Configure Access Options and populate database file properties.
-Create, populate, and modify a hyperlink field. Collect data via e-mail by using Outlook 2007.