About This Training Course

This Brisbane Microsoft Access Training Course has been designed to introduce new users to Access 2010 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 and how to create an Access database including forms queries and reports . Students will consolidate their knowledge by creating a simple database on day two of the course.

Subjects Covered

"Getting Started
• What is Microsoft Access?
• What’s New in Access 2010?
• 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 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 in Access 2010

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

Getting Help

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

Access 2010 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 and 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 Queri

Training Course Outcomes

Students who need to learn basic database techniques as well as the skills required to modify an existing database or create a new database.

Prerequisites

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