|
 Microsoft
Access - Intermediate
1
Day Course
This
Microsoft Access
Training Course
will
help you obtain skills required to create an efficient relational database.
You will learn the concepts of a relational database.
You will
learn to customise forms and reports and you will learn to calculate and
summarise data, and how to import data from other sources such as Excel.
Who is this Microsoft Access Training Course for?
If you
want to be able to design relational database structures using Microsoft
Access, by using advanced queries, forms & reports, this course is for you.
Course Prerequisites
Delegates should have ideally attended the
Microsoft Access Introduction
Training Course.
|
|
Screen Familiarity
Planning and Designing Databases
¨ Database
Objective
¨ Scope
Document
Planning and Designing Databases - Tables
¨ Review
existing data sources
¨ Normalisation
¨ Field Types
- Text, Number, Date, Yes/No, Memo and AutoNumber
¨ Identify
Field Sizes
¨ Identify
the Primary Key
¨ Identify
Field Properties
¨ Define
table relationships
Creating Tables
¨ Building
and Modifying Tables
¨ Assigning
the Primary Keys
¨ Identifying
Foreign Keys
Field
Properties - All
¨ Data
Validation - including logical
¨ Lookup
Wizard with Values
¨ Indexing
Testing
tables with Data Entry
Table Relationships
¨ Create
Relationships
¨ Enforce
referential integrity |
Designing Databases - Forms
¨ Form
Considerations - Data Entry, Menu
¨ Identify
Data Sources
Building
and Modifying Forms
¨ Create a
form with the Form Wizard
¨ Use the
Control Toolbox to add controls
¨ Moving and
resizing Objects
¨ Modify
Format Properties
¨ Use form
sections
¨ Yes/No
Alternatives
¨ Tab Order
¨ Adding
Graphics to a Form
¨ Creating
Sub-forms
Reports
¨ Create a
Report with the Report Wizard
¨ Move and
resize a control
¨ Modify
Format Properties
¨ Calculated
Reports
¨ Use report
sections + Page Breaks
¨ Adding
graphics to a Report
¨ Sort
Options
¨ Sub-Reports
Using Access Tools
¨ Print Table
Designs - Reporter
¨ Back-up and
restore a database
¨ Compact A
Database
¨ Repair a
Database
Importing data from Excel |
"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
|
