Access 2002 Intermediate

Provide an overview of the features and tools of Access 2002 for the final downstream user.

• Relationships and referential integrity in Access 2002
• After completing this topic, you should be able to establish relationships between database tables and enforce referential integrity.
• Establishing a relationship in Access 2002
• After completing this topic, you should be able to relate tables in a database.
• Create and modify queries in Access 2002
• After completing this topic, you should be able to create and modify queries in Access 2002.
• Create and enter a query in Access 2002
• After completing this topic, you should be able to create and specify a query in Access 2002.
• Working with relationships and queries in Access 2002
• After completing this topic, you should be able to work with relationships and queries in Access 2002.
• Generating reports in Access 2002
• After completing this topic, you should be able to describe the different types, sections and controls and create a report using the Report Wizard in Access 2002.
• Adding content to a report in Access 2002
• After completing this topic, you should be able to add a field and a control to an Access 2002 report.
• Modification of controls and reporting sections
• After completing this topic, you should be able to modify sections of controls and reports in Access 2002.
• Working with reporting controls in Access 2002
• After completing this topic, you should be able to use reporting controls.
• Printing and shift reports Access 2002
• After completing this topic, you should be able to move and print reports in Access 2002.
• Creating a report in Access 2002
• After completing this topic, you should be able to create a report in Access 2002.
• Import and export data in Access 2002
• After completing this topic, you should be able to import and export data using Access 2002.
• Import data in Access 2002 and export to Excel
• After completing this topic, you should be able to import data into Access and export data to Excel.
• Adding hyperlinks in Access 2002
• After completing this topic, you should be able to add links to data sheets, tables and forms a database.
• Creating a hyperlink in Access 2002