|
Course
Description
Microsoft Access: Level 4 is for students who have
a thorough understanding of the basic and advanced user
features of the Access program, and are interested in
developing introductory-level administrator skill sets.
Students will extend their Access skills to create and
implement switchboard forms, to develop data access
pages that include advanced controls, to protect that
information using security protocols, and to make your
data more accessible and portable. Additionally, students
will take the next step up to the world of VBA programming.
This course is also for the student who may be working
in a multi-user environment and will need to adapt Access
applications to the environment.
Prerequisites
The course is designed for the student who has mastered
the basic Access user skills covered in Levels
1 through 3 of this training series, such as designing
and creating relational databases, running queries to
find information, creating customized forms and reports,
understanding the principles of table relationships
and referential integrity, integrating data with other
applications, modifying a table design to control data
entry, finding data with filters and queries, customizing
forms and reports, and creating data access pages. In
addition, the student should understand the advanced
Access skills, including how to structure existing
data, summarize data, simplify tasks with macros, and
add interaction and automation with macros.
Course
Objectives
Upon successful completion of this course, students
will be able to:
- Create
and modify a database switchboard, and set and modify
your startup options.
- Develop
a data access page and include in it a PivotTable
and PivotChart.
- Distribute
a database and add security features to it.
- Integrate
Access more fully into your business operations.
- Automate
a business process using VBA.
|
