Microsoft Access Introduction

Microsoft Access Introduction

About the course:
This course aims to introduce delegates to basic techniques and terminology, and provide them with the skills required to use Access effectively in their work environment.

By the end of the course delegates will be able to create a database containing one table; filter and sort date; interrogate data using queries; produce forms and reports.

Course Content:
Introducing Access

• Looking at Access
• Examine the Database Window
• Change the Default File Format

Examining Tables

• Understanding Tables
• Navigate in Tables
• Modifying Columns and Rows
• View Multiple Tables

Entering and Working with Table Data

• Enter Data in Datasheet View
• Use AutoCorrect
• Modify Table Data
• Find Records
• Delete Table Data
• Sort Table Data

Creating Databases and Tables

• Explore and Use the Database Wizard
• Create Blank Databases from Scratch
• Examine Primary Keys
• Understand Data Types
• Create Tables in Design View

Creating Relationships

• Understand Relationships
• Add Tables to Relationship Window
• Create Table Relationships
• Enfore and Test Referential Integrity
• Edit Existing Relationships
• Organise and Print Relationships
• View Subdatasheets

Using Forms

• Understanding Forms
• Create Autoforms
• Using the Form Wizard
• Entering Data in a Form
• Working in Design View
• Modify Control Properties

Filtering Data

• Understand Filters
• Use Filter by Form
• Use Filter by Selection
• Sorting Records

Running Queries

• Understanding Queries
• Creating Single-Table Queries
• Delete, Move and Hide Query Fields
• Using the Query Wizard

Working with Reports

• Understanding Reports
• Create and Save AutoReports
• Using the Report Wizard
• Previewing Multiple Pages
• Modify Page Orientation and Margins
• Printing Reports

Equipment Requirements:
All equipment will be supplied by City Business.

Assessment:
Due to the workshop nature of this one day course, there are no formal examinations or assessments.

Progression:
Delegates may wish to extend their knowledge by attending an Access Intermediate course after successfully completing the Introduction level.

Code : Time : Duration : Day : Tuition Fee : Admin Fee
B02180 003 09:30 - 16:30 04/11/2009 - 04/11/2009 Wednesday Fee Enquiry

B02180 008 09:30 - 16:30 20/04/2010 - 20/04/2010 Tuesday Fee Enquiry