 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2002 (XP) Intermediate
Course Aims
This intensive course will help readers to build on their basic understanding of Microsoft Access 2002, in order to produce more comprehensive and robust database applications. Readers will get experience in the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports. |
Assumed Knowledge
Readers should have some experience in creating a basic database in Access (including designing a table and specifying field data types and basic properties), of adding and editing data and using wizards to create queries, forms and reports. |
Course Audience
Existing users of Access 2002 who want to get grips with some of the more advanced features of this package as quickly as possible. |
|
Table of Contents
|
Relational Database Management Systems
|
Design and plan a database
|
|
Determine appropriate data inputs and outputs
|
|
Describe basic principles of relational database management systems
|
|
Split a database into relational tables using primary keys
|
|
|
|
Table relationships
|
Create and edit table relationships
|
|
Enforce referential integrity
|
|
Specify join properties for relationships
|
|
Display related records in a subdatasheet
|
|
|
|
Modifying a table
|
Set table field properties
|
|
Use the Input Mask Wizard
|
|
Modify a table in design view
|
|
Import data to a new table
|
|
Use the Office Clipboard to copy and paste data
|
|
|
|
Customizing queries
|
Create and modify a multi-table select query
|
|
Add calculated fields to the query output
|
|
Use the Expression Builder to create expressions
|
|
|
Customizing forms
|
Use form sections (header, footer and detail)
|
|
Use the Toolbox to add controls
|
|
Modify format properties of controls
|
|
Add a calculated control to a form
|
|
|
|
Customising reports
|
Use report sections (header, footer and detail)
|
|
Use the Toolbox to add controls
|
|
Modify format properties of controls
|
|
Add a calculated control to a report
|
|
Save a table, query or form as a web page
|
|
|
|
Database tools
|
Create a backup copy of a database
|
|
Use Microsoft Backup to create a backup set
|
|
Compact and repair a database
|
|
|
|
|
Glossary
|
|
|
|
|
