 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2003 Intermediate
Course Aims
This course is designed to help you to obtain the skills required to create a relational database. You will learn relational database concepts and practice and understand the importance of documenting and maintaining database files.
You will learn to customise forms, reports, and Data Access Pages in design view. Finally, you will be able to calculate and summarise data and import and export data in different formats for different purposes, like mail merge, analysis, or reporting. |
Assumed Knowledge
Ideally, you will have completed the course "Microsoft Access 2003 Introduction". You should be able to use Microsoft Access to create a database, tables, queries, forms, and reports. |
Course Audience
Those wanting to design relational database structures using Access and master the design and customisation tools available for queries, forms, and reports. |
|
Table of Contents
|
Access 2003 - Designing a Relational Database
|
Describe basic principles of relational database management systems
|
|
Split a database into relational tables using key fields
|
|
Understand the importance of referential integrity
|
|
Design a table for a relational database
|
|
|
|
Access 2003 - Creating Table Relationships
|
Create and edit table relationships
|
|
Arrange tables in the Relationship window
|
|
Enforce referential integrity
|
|
Display related records in a subdatasheet
|
|
|
|
Access 2003 - Joining Tables with Queries
|
Create and modify a multi-table select query
|
|
Specify join properties for relationships
|
|
Understand the effect of join types in a query
|
|
Use self joins and cross joins
|
|
|
|
Access 2002 - Enforcing Referential Integrity
|
Use the Find Unmatched and Find Duplicates Query Wizards
|
|
Set Cascade Update and Cascade Delete options
|
|
|
|
Access 2003 - Summarising and Calculating Data
|
Create a query to summarise values
|
|
Add a calculated field to query output
|
|
Add a calculated field to form or report
|
|
Use the Expression Builder to create expressions
|
|
|
|
Access 2003 - Creating a Summary Report
|
Create a summary report using the Report Wizard
|
|
Add and remove group headers and footers
|
|
Modify group and detail section sort orders
|
|
Modify report section properties
|
|
|
|
|
Access 2003 - Using Parameter and Crosstab Queries
|
|
|
Access 2003 - Designing Forms and Reports
|
Create a new form or report in design view
|
|
Understand the use of different sections
|
|
Display, hide, and resize a section
|
|
Modify form/report, section, and control properties
|
|
Use the Control Wizard to add a control (list box, combo box, check box, option group)
|
|
|
Access 2003 - Modifying Controls
|
Select a single control or multiple controls
|
|
Move, resize, align, and distribute controls
|
|
Change the tab order of controls on a form
|
|
Identify and resolve errors
|
|
Modify control properties
|
|
Create a form/report template
|
|
|
|
Access 2003 - Importing Data
|
Import data from different sources (spreadsheet, text file, database, Outlook/Exchange Address Book)
|
|
Use Drag-and-Drop and the Clipboard to copy and paste data
|
|
|
|
Access 2003 - Exporting Data
|
Export a table or query to Excel
|
|
Export data to Word and complete a mail merge
|
|
Save data in other file formats
|
|
Export data objects to a different database
|
|
Save a table, query, or form as a web page
|
|
|
|
Access 2003 - Designing a Data Access Page
|
Create a Data Access Page
|
|
Modify the connection properties of a data access page
|
|
Use the grouping and sorting features of a data access page
|
|
Modify the design of a data access page
|
|
Add and modify fields and controls
|
|
Delete a data access page
|
|
|
|
Access 2003 - Managing the Database File
|
Document database structure
|
|
Identify object dependencies
|
|
Compact and repair a database
|
|
Apply password protection to a database file
|
|
Encrypt and decrypt a database
|
|
Convert a database between different Access versions
|
|
|
|
|
|
