Delegates are introduced to the 4 main parts of Access, namely tables, queries, forms and reports..

Suitable for

Those with either none or minimal knowledge of Access and how databases work    

What experience you will need

Basic keyboard and mouse skills needed to help navigate and explore the windows environment
    
What the course will include

Introduction to MS Access
- What is a Database?
- Overview of the components of an Access Database

Getting Started with Access
- Access 2000 Opening Screen
- The Status Bar, Menus and Submenus
- The Database Window

Getting Assistance with Access
- Using the Office Assistant
- Manipulating the Help Window

Creating Tables & Adding Records
- Datasheet view, adding a record
- Saving changes, moving around the Database
- Finding a record; modifying and deleting records

Working with Data
- Sorting Data
- Filtering Data
- Using Advanced Filters   
    

Simple Forms
- What is a Form?
- Entering Data using a Form
- Using AutoForm to design forms

Simple Select Queries
- What is a Query?
- Creating a Query
- Modifying a Query

Simple Reports
- Reporting from Access
- Designing a Report
- Modifying a Report

CD Rom/Manual
- Instructions on How to Open the User Manual

Course Duration  -   1 day

Course cost  -  £120

Follow on courses - Access Intermediate
                                - Access Advanced

Tags: access, microsoft, office