About This Training Course

This 2 day Microsoft Access 2007 - Introduction Training Course has been designed to introduce new users to Access 2007 databases. Students will learn about the components of a database, and the necessary procedures to ensure the integrity of data is maintained in a database. Students will consolidate their knowledge by creating a simple database on day two of the Microsoft Access 2007 - Introduction Training Course.

* Multiple-day course sessions are conducted 8-days apart to enable participant’s greater opportunity to absorb and practice learned topics, and cement transfer of skills to their everyday job roles. Our experience is that this course structure assists with the most effective learning and skills retention.

Subjects Covered

This Microsoft Access 2007 - Introduction Training Course will cover the following subjects:

GETTING STARTED
• 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

GETTING HELP IN ACCESS 2007
• Opening the Help Screen
• Overview of the Help Screen
• Online Help vs. Offline Help
• Searching for Help

THE TRUST CENTRE
• Warnings You May See when Opening a Database
• Enabling Content
• About Digital Signatures
• About Trusted Locations
• Opening the Trust Centre
• 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

ACCESS 2007 INTERFACE
• Using the Quick Access Toolbar
• About the Default Buttons
• Adding Buttons
• Removing Buttons
• Customizing the Toolbar
• Basics of Ribbons
• Opening Dialog Boxes from the Ribbon
• About the Office Menu
• Reviewing the Ribbon Tabs

CREATING A DATABASE
• Planning a Database
• Creating a Database from a Template
• Creating a Blank Database
• Using Database Objects
• Setting Navigation Options

ABOUT RECORDS & TABLES
• 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

CREATING FORMS TO VIEW AND EDIT DATA
• 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 TO SELECT RECORDS
• What is a Query?
• Creating a Query with the Wizard
• Using Design View to Modify a Query
• Using Queries

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

VIEWING & FILTERING DATA
• Using the View Menu
• Using the View Icons
• Using the Tabs
• Closing Individual Tabs Using Find and Replace
• Sort Ascending or Descending
• Toggling Filter
• Using Selection Sort
• Using Advanced Sort

PRINTING DATA
• Using the Quick Print Icon
• Using the Print Menu
• Using Print Preview
• Using the Print Preview Ribbon
• Printing vs. Exporting

Training Course Outcomes

At the end of this Microsoft Access 2007 - Introduction Training Course students will learn about the components of a database, and the necessary procedures to ensure the integrity of data is maintained in a database. Students will consolidate their knowledge by creating a simple database on day two of the Microsoft Access 2007 - Introduction Training Course.

Prerequisites

For best outcomes, participants should be familiar with the Windows operating system and basic mouse and keyboard techniques.

Other Information

If you need more information contact Startnextweek.com.au on 1300 728 102