Access - Accelerated Introduction

Participants can bring work that they would like to put on a database. Over the 3 hour course participants can apply their new skills to work that is relevant to them and they can take their work away with them.

BASICS

• Starting and exiting Access
• Using the menus and help
• Opening and closing a database
• Aspects of the database window

USING A DATABASE

• Using a database
• Changing from table to form view
• Moving and resizing columns and rows
• Formatting the table

CREATING A TABLE

• Create a table
• Define fields
• Choose data types and field properties
• Setting default entries and validating data
• Delete, insert and rearrange fields
• Using the primary key and indexes

FIND, SORT AND FILTER

• Finding a record
• Sorting the database
• Create a filter, specify criteria. apply and save

WORKING WITH QUERIES

• Entering query criteria
• Choosing columns to show
• Calculating totals and averages
• Saving and modifying a query

CREATING REPORTS

• Designing a report using Report Wizard
• Grouping Fields
• Summary Information
• Detail Properties, Headers and Footers

Class Details

Venue:

Dates

Please contact us to book and for more information regarding this class.