|
 Microsoft
Access - Introduction
1
Day Course
This
Microsoft Access
Training Course
is
designed to help you create a simple databases. You will learn to design
tables and queries and to create forms and reports using built-in tools.
Who is this
Microsoft Access Training Course for?
If you
want to be able to create simple databases or modify existing databases,
this course is for you.
Course
Prerequisites
You
should have basic knowledge of Microsoft Windows and be able to start an
application, get help, and open, close, and save files.
|
|
Access Overview
¨ What is a
database
¨ Object
explanation
¨ Role
Definition
Access
Objects
¨ Moving
between objects
Planning and Designing Databases
¨ Database
Objective
¨ Scope
Document
Planning and Designing Databases – Tables & Forms
¨ Document
table structure
¨ Field Types
- Text, Number, Date, Yes/No, Memo and AutoNumber
¨ Identify
Field Sizes
¨ Identify
the Primary Key
¨ Form
Considerations - Data Entry
Creating Tables
¨ Building
and Modifying Tables
¨ Screen
Familiarisation
¨ Field
Descriptions
¨ Assigning
the Primary Keys
¨ Assigning
Data Types
¨ Assigning
Field Sizes
Building and Modifying Forms
¨ Create a
form with the Form Wizard
¨ Basic
Editing of Forms |
Data Management
¨ Appending
Records
¨ Delete
records
¨ Editing
Data
Views
¨ Switching
between Design and View
Finding, Filtering & Sorting
¨ Find a
record
¨ Filter by
selection
¨ Sort
records
Select Queries
¨ Data
Sources
¨ Field
Selection
¨ Selection
Criteria Overview
¨ Show/Hide
¨ Logical
Operators
Reports
¨ Create a
report with the Report Wizard
¨ Preview and
print a report Screen Familiarity |
"Thanks for the
warm welcome,
you have a lovely group and the training you have with Lee-Anne is
one of the best for clarity
that I have attended for some time.
Access is a
struggle for those new to it,
I feel that bite size sessions are good."
Frances Haywood
North Norfolk District Council
|
