The Access 2007 QUICK Source Learning Series will show you the advanced features of how to use Access 2007. The QUICK Source Learning Series combines three levels of training: Teaching, Trying, and Testing. The teaching section includes high-quality video so you are able to see what the instructor is teaching you to do. The trying section allows you to practice what you have learned right in our program. There is no need to switch between our software and Access 2007. The testing section involves a variety of test questions with immediate feedback. Trainers can track users’ progress, view test scores, and print out reports.

• Databases and Tables
  • Introduction
  • Working with Database Object Properties
  • Creating Custom Categories and Groups
  • Setting a Primary Key
  • Creating a Linked Table
  • Using the Linked Table Manager
  • Creating an Index
  • Adding a Totals Row
  • Creating a Lookup Column
  • Applying a Predefined Format
• Queries
  • Introduction
  • Joining Tables and Queries
  • Adding Criteria to a Query
  • Creating a Crosstab Query
  • Creating an Update Query
  • Creating a Make-Table Query
  • Creating an Append Query
  • Creating a Delete Query
  • Creating a Find Duplicates Query
  • Creating a Find Unmatched Query
  • Using Parameters in Queries
• Controls and Formatting
  • Introduction
  • Inserting Controls
  • Working with Control Layouts
  • Formatting Controls
  • Creating a Calculated Control
  • Applying an AutoFormat to a Form or Report
  • Applying Conditional Formatting
  • Setting a Default Value for a Control
  • Using Windows Themes in Controls
• Forms and Subforms
  • Introduction
  • Designing a Form
  • Creating a Form with a Subform
  • Adding a Subform to a Form
  • Creating a Form with Nested Subforms
  • Enhancing a Form
  • Inserting a Datasheet into a Form
  • Creating a Switchboard Form
  • Working with Switchboards
• Reports
  • Introduction
  • Creating a Grouped or Summary Report
  • Creating Alternating Row Colors on a Report
  • Setting Section and Report Properties
  • Using the Subreport Wizard
  • Adding a Table, Query, Form, or Report as a Subreport
  • Adding a Table or Query as a Datasheet
  • Adding a Total or Other Aggregate
  • Distributing a Report by E-Mail
  • Exporting a Report as a Snapshot, PDF, or XPS File
• Macros
  • Introduction
  • Creating a Macro
  • Creating a Macro Group
  • Creating an Embedded Macro
  • Editing a Macro
  • Using Conditions to Control Macros
  • Running a Macro
  • Stepping Through a Macro
  • Changing Macro Security
• Security and Customization
  • Introduction
  • Enabling or Disabling Content
  • Using the Trust Center
  • Creating a Signed Package
  • Extracting and Using a Signed Package
  • Encrypting a Database with a Password
  • Opening and Decrypting a Database
  • Customizing Access Options
• Extras
  • Introduction
  • Attaching Files
  • Working with Attachments
  • Using the Expression Builder
  • Entering an Input Mask in a Table
  • Entering an Input Mask in a Query or Control
  • Collecting Data Using E-Mail
  • Preventing the Navigation Pane from Appearing by Default

For quantity pricing or to order courses: (QUICKsource@QUICKsourceLearning.com)

• A07A1 - Databases and Tables
• A07A2 - Queries
• A07A3 - Controls, and Formatting
• A07A4 - Forms and Subforms
• A07A5 - Reports
• A07A6 - Macros
• A07A7 - Security and Customization
• A07A8 - Extras

• Access 2007 Advanced