Home | Training Classes | Consulting | Hosted Solutions | FAQ | Contact     

 

Home

Training Classes

  > Word

  > Excel

  > Access 

  > PowerPoint

  > Visio 

  > MS Project

  > Crystal Reports 

  > ACT!

  > Other Classes 

Consulting

Hosted Solutions

FAQ

Contact

 

 

 

ACT! Consultants

High Trust for ACT

 

 

 

Access 2007: Level 1 - Syllabus  
Getting Started
Starting Out
What is Microsoft Access?
What’s New in Access 2007?
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing Microsoft Access

Using the Getting Started Window
Overview of the Window
Navigating Through the Window
Creating a Database from a Template
Creating a Blank Database

The Trust Center
Warnings You May See when Opening a Database
Enabling Content
About Digital Signatures
About Trusted Locations
Opening the Trust Center
Assigning a Password to your Database

Getting Help
Opening the Help Screen
Overview of the Help Screen
Online Help vs. Offline Help
Searching for Help

The New Interface
Using the Quick AccessToolbar
About the Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar

Basics of Ribbons
About Ribbons
Opening Dialogue Boxes from the Ribbon
About the Office Menu

The Home Ribbon
Views
Clipboard
Font
Rich Text
Records
Sort and Filter
Find

Create Ribbon
Tables
Forms
Reports
Other

External Data Ribbon
Import
Export
Collect and Data
SharePoint Lists

Database Tools Ribbon
Macro
Show/Hide
Analyze
Move Data
Database Tools

Creating a Database
First Steps
Planning a Database
Creating a Database from a Template
Creating a Blank Database
Using Database Objects
Setting Navigation Options

About Records
What is a Record?
Navigation Tips
Adding Records
Editing Records
Deleting Records
E-Mailing Records
Printing Records

Creating a Table
About Tables
Creating a Table
Entering Data into a Table
Formatting a Table

Formatting Text
Using the Zoom Box
Selecting Data
Cutting, Copying, and Pasting
Using the Format Painter
Using Undo and Redo
Checking your Spelling

Doing More with your Database
Creating Forms

What is a Form?
Bound vs. Unbound Controls
Creating a Form with the Wizard
Using Design View to Modify Your Form
Using Forms

Creating Queries
What is a Query?
Creating a Query with the Wizard
Using Design View to Modify a Query
Using Queries

Reports
What is a Report?
Creating a Report with the Wizard
Using Design View to Modify a Report
Using Reports

Sorting and Filtering Data
Using Find and Replace
Sort Ascending or Descending
Toggling Filter
Using Selection Sort
Using Advanced Sort

Viewing Data
Using the View Menu
Using the View Icons
Using the Tabs
Closing Individual Tabs