|
Course Outline
Duration
3 half days
Prerequisite
Experience with Access Introductory functions.
Objectives
To provide a thorough understanding of the comprehensive
concepts and skills that will enable the participant to
effectively use Microsoft Access.
Methodology
Group and individual instruction, hands on practical exercises,
visual aids, comprehensive course documentation.
Confirmation of Assessment Plan
This will be issued to the trainee at commencement of training
session.
Expected Outcome
By the end of the course the participant should be able
to use the following functions and features of Microsoft
Access.
CONTENT
Review of Basics
Importing Records
- Importing Overview
- Importing from Microsoft
Excel
- Importing from a text
file
- Importing from a database
- Quick Review
Sorting Data
- Sorting Overview
- Sorting data in a Column
- Sorting contiguous data
- Sorting non-contiguous
data
- Quick Review
Parameter Queries
- Overiew of parameter queries
- Creating a parameter query
- Saving a parameter query
- Running a parameter query
- Creating a data query
- Creating a value range
parameter query
- Quick Review
Calculated Queries
- Overview of calculated
queries
- Creating calculated fields
- Formatting calculated
fields
- Nested calculations
- Using calculated fields
- Calculations that summarise
- Grouping summaries
- Quick Review
Mailing Labels
- Overview of mailing labels
- Using the label wizard
- Printing labels
- Creating a query for labels
- Creating a label report
from a query
- Creating a custom label
- Quick Review
Relational Databases
- Relational database overview
- Types of relationships
- Referential integrity
- Developing a database
system
- Developing the overall
concept
- Mock up report
- Determining the data fields
- Entering sample data
- Normalising the database
- Achieving first, second
and third normal forms
- Data modelling workshop
- Quick Review
Multi-Table Systems
- Multi-table database overview
- Creating the tables
- Importing lookup data
- Using the lookup data
- Creating a manual lookup
- Setting relationships
- Creating a related query
- Testing the relationships
- Quick Review
Relational Forms
-
Overview
of relational forms
-
Creating
a relational form
-
Using
a relation form
-
Changing
the form layout
-
Changing
subform column widths
-
Totalling
subform values
-
Passing
a value to the main form
-
Running
the modified form
-
Quick
Review
Relational Reports
- Relational report overview
- Creating a relational
query
- Creating a nested query
- Creating a relational
report
- Modifying a relational
report
- Running a relational report
- Quick Review
Access Macros
-
Overview
of Access macros
-
Working
with a macro
-
Creating
simple macros
-
Running
macros
-
Placing
macros on forms
-
Running
macros on forms
-
Adding
more macros
-
Quick
Review
Conclusion
-
Where
to from here
-
Further
reading and consolidation
 |