Access 2003 - Level 1

Designed for new Access users who require the skills necessary to set up & use a relational database. Learn the theory involved in designing the relationships between tables; how to create &customize forms & reports from the tables, how to use filters...

Course Outline

This course is designed for new Access users who require the skills necessary to set up and use a relational database. Students will learn the theory involved in designing the relationships between tables. This course will also show students how to create and customize forms and reports from the tables, as well as introduce how to use filters and create select queries.

Course Content

The Basics

• Database Concepts
• Getting Started
• Creating a Database
• Converting Access Files
• Working with Objects

Table Data

• Table Concepts
• Viewing Data in a Table
• Changing the Datasheet Appearance
• Entering and Editing Data
• Applying Filters

Table Design

• The Table Wizard
• Changing the Table Design
• Creating a Table in Design View

Data Entry

• Data Entry Concepts
• Data Formats
• Input Masks
• Input Validation
• Adding Records

Relationships

• Relationships Between Tables
• Creating a Relationship
• Referential Integrity
• Removing a Relationship
• Printing Relationships

Creating and Using Forms

• Creating a Form Using AutoForm
• Creating a Form Using the Form Wizard
• Creating a Form in Design View
• Opening a Form
• Changing a Form Design
• Adding Controls
• Placing Controls
• Multiple-Choice Controls
• Error Checking

Additional Details

Pre-Requisites

Good understanding of Windows and Microsoft software.

Certificates offered

Certificate of completion

Cancellation Policy

10 business days cancellation or full course fee will be charged

Map & Reviews

Technology Training Centre
[ View Provider's Profile ]

Reviews

 

   

Sue is an awesome instructor!

Reviewed by Cathy P. 2011