Quick Source Learning | Quick Source Learning | Access 2007 Advanced Course

Access 2007 Advanced Course

Microsoft Access






The Quick Source eLearning Series combines three levels of training: Learn It, Try It, and Evaluation. The Learn It section includes high quality video that shows you everything the instructor is teaching. The Try It section allows you to practice what you have learned right in our course. There is no need to switch between the course, and the software that you are learning. The Evaluation section gives you the ability to test your knowledge and receive immediate feedback.

Topics covered in this course:

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


  • 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


  • 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


  • 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


  • 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