|
|
 |
| |
| ACCESS 2003 INTERMEDIATE |
|
Before taking this course, you should have the basic skills you need to work with a Microsoft® Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.
|
| |
| Prerequisites |
|
To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge:
|
 |
Microsoft Access 2003: Level 1 |
|
A basic understanding of Microsoft® Excel and Microsoft® Word would also be helpful, but is not required. |
|
| |
| Objectives |
|
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
|
|
Follow the steps required to properly design a simple database. |
|
Create a new database with related tables. |
|
Control data entry by modifying the design of a table to streamline data entry and maintain data integrity. |
|
Find and retrieve desired data by using filters and joins between tables and within a single table. |
|
Create flexible queries to display specified records; allow for user-determined query criteria; and add, update and delete data with queries. |
|
Enhance the appearance, data entry, and data access capabilities of your forms. |
|
Customize reports to better organize the displayed information and produce specific print layouts such as mailing labels. |
|
Use Access data in other applications, including Microsoft Word and Excel. |
| |
|
|
| |
|
|
| |
|
|
|
|
|
 |
|
|
|
|
|
|
|
|