Microsoft Access Intro Training Course Glasgow

Duration:

2 day course for people new to using Microsoft Access.

Objectives:

The object of this session is to introduce the student to the concepts of databases and to Microsoft Access. The student will be led, via a series of hands on exercises, step by step through the topics listed. All will be explained in a clear and concise manner, using everyday language to explain database terminology.

Course Topics:

What is a Database?
The Planning Stages
Database Structure/Design
The Access Screen/Toolbar /Icons

Creating a Database Table

Queries

Field Names/Field Types/Descriptions
Changing the Field Properties
Using Validations
Primary Keys

Using Tables

Opening and Closing
Menu Options/Toolbars
Cursor Movement Keys
Edit Mode/Insert & Replace
Record Selection Keys

Changing the Table Format

Changing the Column Widths
Formatting Fonts & Numbers
Hiding/Showing
Freeze/Unfreeze Columns
Changing the Column Order

Adding/Editing/Deleting Records

Using FIND

Wildcards: Characters/Numbers/Special
Sorting & Filtering the Data

Data Entry Forms

The form Wizard
Toolbox Contents/Palette
Adding, Selecting. Editing Fields

Queries

Specifying Criteria – Wildcards
Setting Parameter Queries
AND or OR
Overview of Reports
The Report Wizard

Creating/Formatting Reports

Page & Report Headers & Footers
Page No’s/Date and Time etc
Formatting the Headers and Footers
Sorting and Grouping
Inserting Totals & Sub Total Fields

Preview & Printing

Page Set Up
Changing the Margins
Orientation
No Copies
Individual Page

Questions and Answers

Venues and Delivery:

We offer this course on a regular basis at our training venue in at the Travelodge Conference Room, Auchenkilns, Cumbernauld, as well as offering in-house or bespoke training for HR departments or companies.

Please visit our IT training course schedule page to find out when our Access Intro training is running.

For corporate or business IT Training or for more info how Insight provide some of Scotland’s and Europe’s leading companies with in-house IT training, for further information Contact Us and we will get back to you very quickly.

Booking:

To book this course, please complete our online form or contact us on 01236 873498 or
email: bookings@uk-insight.org.uk