This course teaches students intermediate Access skills, including how to enhance your database designs
by using the principles of table relationships and referential
integrity, integrate data with other applications, modify
a table design to control data entry, find data with
filters and queries, customize forms and reports, and
create data access pages. Students will also learn many
additional intermediate-level skills, particularly those
related to creating more complex queries, customizing
your forms and reports, and broadening the availability
of your data. This course also serves as a prerequisite
for persons interested in learning more advanced skills
To ensure your success, we recommend you first take
the following course or have equivalent knowledge: MS
Access Level 1.
Upon successful completion of this course, students
will be able to:
Share data with other applications and enforce referential
Modify the design of a table to streamline data entry
and maintain data integrity.
Use a filter to show you records in a datasheet or
a form that match whatever conditions you specify,
and you will generate different query results by creating
different types of joins between tables.
Create select queries that display special records
and you will design other types of queries, including
parameter and action queries.
Create forms and change their designs to enhance the
appearance and usability of a form and to make your
form more professional.
Create reports and change their designs to better
organize and summarize information and to improve
the appearance by enhancing data layout and working
with report pagination.
Create and work with data access pages.