Access 2003 - Introductory level

View our full Access Course Schedule or call 0845 485 1173 today for more details

You can view this course outline as a PDF for printing

Objectives

After completing this course you will know how to:

• Create a database
• Use queries to interrogate the data
• Use forms to input the data
• Create and print reports

Pre-requisites

• Experience of Windows 2000 or later. Basic keyboard skills

Course Contents

Getting started

• Database concepts
• Exploring the Access environment
• Getting help
• Closing a database and Access

Databases and tables

• Planning and designing databases
• Exploring tables
• Creating tables

Fields and records

• Changing the design of a table
• Finding and editing records
• Organizing records

Data entry rules

• Setting field properties
• Working with input masks
• Setting validation rules

Using indexes

Simple queries

• Creating and using queries
• Modifying query results and queries
• Performing operations in queries

Using form

• Creating forms
• Using the Form Wizard
• Using Design view

Finding, sorting, and filtering records

Working with reports

• Creating reports
• Modifying and printing reports

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk

Name:* Please enter your name

Company:

Email:* Please enter your email

Telephone:

Contact us for:* Booking Enquiry Information Request

Course interest: Access Dreamweaver Excel Google AdWords Illustrator Indesign Not Listed/Other Outlook Photoshop PowerPoint Project Publisher Word

Message: Please enter your message