Microsoft Access 2007 - Introduction
Duration: 1 Day

Introduction
Microsoft Access 2007 Introduction course is suitable for complete beginners to Ms-Access. Working knowledge of Ms-Windows is required.

At the end of this course you will have a good working knowledge of Microsoft access 2007 training basics. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports.

Course Contents
Database Concepts	Creating and Using Forms
Database concepts and terminology Exploring the Access environment Planning and designing databases Getting help Closing a database and Access	Creating forms by using AutoForm Using the form wizard Using design view Finding, sorting and filtering records

Access Basics	Creating and Using Reports
Exploring tables Examining queries Exploring reports	Using the report wizard and queries Creating, modifying and printing reports

Creating Databases	Importing, Exporting and Linking Objects
Creating a database Using the table wizard Working in design view	Importing Access objects Exporting Access objects Linking Access objects

Working with Fields and Records
Changing the design of a table Adding and deleting records Finding and editing records Sorting and filtering records Querying Tables Creating and using queries Modifying query results and queries Using calculations in queries