Microsoft Access 2010 Training Course Beginners

Course: Microsoft Access 2010 Public Course
Level: Introduction
Date: 1st August 2012
Duration: 1 Day
Venue: Cambourne (Near Cambridge) Computer Tutoring Venue
Price: £200 + VAT Includes:

1 Day's Interactive Training
1 Months Post Training Support
Comprehensive Manual
Lunch

In this course you will learn the basics of Microsoft Access 2010 and create and modify new databases and their various objects. You will also learn how to identify the basic components of an Access database, build the structure of a database, manage data in tables, query a database, design forms and generate reports.

Microsoft Access 2010 Training Course (Beginners) Outline -

Getting Started with Access Databases

Identify the Elements of the Access 2010 Interface
Identify the Components of a Database
Examine the Relational Database Design Process

Building the Structure of a Database

Create a New Database
Create a Table Using the Design View
Manage Tables
Establish Table Relationships

Managing Data in a Table

Modify Table Data
Sort and Filter Records
Work with Subdatasheets

Querying a Database

Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping

Designing Forms

Create a Form
Modify the Design of a Form
View and Edit Data Using an Access Form

Generating Reports

Create a Report
Add a Control to a Report
Format the Controls in a Report
Enhance the Appearance of a Report
Prepare a Report for Print

Microsoft-Access-2010-Training-Course-Beginners

Course Duration: 1 Day