|
Course Outline
Duration
3 half days
Prerequisite
Experience with Microsoft Windows and use of a mouse.
.
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
Forms from Scratch
- Forms from scratch overview
- Creating a new form
- Working with the form
layout
- Attaching a data source
- Adding fields
- Selecting objects on
a form
- Moving objects and fields
- Aligning and spacing
objects
- Saving the form
- Auto formatting the
form
- Adding and formatting
a label box
- Changing for form behaviours
- The view property
- Quick Review
Display Controls
- Overview of display
controls
- Creating a blank form
- Adding unbound controls
- Attaching a field to
an unbound control
- Adding a tab control
- Adding fields to a tabbed
control
- Running the form
- Running the subform
- Enhancing the appearance
- Quick Review
Selection Controls
- Controls for selecting
data
- Adding a combo box
- Using a combo box
- Creating an option group
- Using an option group
- Adding a list box
- Using a list box
- Changing a control
- Quick Review
Expressions
- Expressions overview
- Using the expressions
builder
- Creating expressions
by typing
- Using functions in expressions
- Nesting functions
- Disguising information
controls
- Using data from sub-forms
in expressions
- Creating expressions
from a subform
- Hiding error messages
- Naming controls
- Using expressions in
calculations
- Quick Review
Querying Techniques
- Querying techniques
overview
- Understanding the jet
engine
- Understanding intellijoin
- Understanding autojoin
- Changing join types
- Using expressions in
queries
- Changing field properties
- Changing query properties
- Analysing query performance
- How to improve query
performance
- Quick Review
Cross Tabulation
- Cross tabulation overview
- Examining the data
- Creating a cross Tabulation
- Cross tabulating related
tables
- Using criteria in cross
tabs
- Creating a manual cross
tab
- Using expressions in
cross tabs
- Quick Review
Database Security
- Security Overview
- Setting a database password
- Hiding objects
- Understanding user-level
security
- The security process
- Creating a new workgroup
file
- Creating the administrator
- Removing the admin user
- Logging on as the system
administrator
- Securing the database
- Adding groups and users
- Assigning permissions
- Testing the security
- Joining another workgroup
- Quick Review
Creating an Application
- Creating an application
- Creating a form template
- Using the form template
- Using macros to automate
operations
- Macros that open forms
- Macros that run reports
- Macros the open tables
and queries
- Assigning macro actions
to menu forms
- More complex macros
- Closing forms
- Creating a dialog box
- Using the switchboard
manager
- Automating the start
up
- Quick Review
Visual Basics
- Visual basic overview
- Creating a simple procedure
- Running the macro
- Creating a more complex
procedure
- Navigating around the
module
- Quick Review
Conclusion
|
