Microsoft Access Training for new users

Duration:

2 day course for people new to using Microsoft Access.

Objectives:

The object of this session is to introduce the new user to the concepts of databases and to Microsoft Access. The session can be tailored for users who have a grasp of database concepts in general or who have used other database applications. It is also suitable for those who have dabbled with previous Access versions. A large part of the course is devoted to"hands-on" experience of the package and the student is led through a series of exercises.

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 Nos/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 Moodiesburn House Hotel - located on the A80 Cumbernauld Road, 10 minutes north of Glasgow, as well as offering in-house or bespoke training for HR departments or companies.

Please visit our schedule page to find out when 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 inhouse IT training, please contact us.

Booking:

To book this course, please complete our online form or contact us on 01236 733898 or
email: bookings@uk-insight.org.uk
Microsoft Office Access Training in Scotland