|
Intended Audience |
This
course is designed for individuals who wish to learn how to create new
databases, tables, and relationships, as well as work with and revise
queries, forms, and reports. It also includes integrating Access data
with other applications such as Microsoft® Word or Excel. |
|
Description |
Upon successful completion of this course, individuals 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.
|
|
Prerequisites |
Individuals enrolling in this course should have
experience designing tables, simple queries, forms, and reports. To
ensure your success, we recommend you first take the following courses
or have equivalent knowledge:
- Microsoft Windows experience
- Access 2003 Beginning
|
|
Pre-Work Required |
None |
|
Suggested Class Size |
Minimum 3
Maximum 12 |
|
Course Length |
Full day |
|
Brazosport College