Microsoft Access Introduction

Microsoft Access Introduction
Overview
This course is designed for beginners that have no prior knowledge of Microsoft Access. On completion of the course the delegates will be able to understand database concepts and terminology. They will be able to produce their own database, design and create tables, select specific records from queries and produce reports.
Course Content
Introduction

• What is a database?
• Preparing a database

Creating a Database

• Blank database
• Table design view/datasheet view
• Creating a table, inserting fields, data types and field properties

Modifying a Table

• Adding and deleting a record
• Changing column widths
• Freezing columns
• Hiding and moving columns
• Changing field properties

Sort, Find and Filter

• Sort alphabetically in a table
• Finding and editing records
• Filter by selection and form

Creating Queries

• Creating a new query
• Selecting criteria
• Modifying a query
• Using relational operators

Creating a Report

• Using report wizard
• Tabular reports
• Modifying a report

Format
This course is instructor led in a classroom environment. We recommend a maximum of 8 delegates per course to ensure that all delegates gain the maximum benefit from the course.
Duration
This is a one day course. Standard hours are 9:30 to 16:30, with a one hour lunch break, and short breaks mid morning and mid afternoon. It may be possible to change this arrangement by request.
Location & Cost
This course is available on-site at your offices, using your own equipment for £300 + £20 per delegate + VAT. We may be able to arrange an alternative venue or equipment hire at extra cost - please contact us to discuss if required.