Microsoft Access

Using Access

• Introduction to the Relationship Database Model
• A Short Access Tour
• Wizards, Cue Cards, and Help
• Working with an existing database for customer and product manipulation
• Entering Adding and Editing Data into Tables
• Table Field Properties
• Customizing data sheets for better data manipulation
• Copying, Moving and Deleting data

Creating a new database

• Creating tables for data storing
• Setting relationships between tables
• Modifying Table Properties
• Data Types and Validation

Forms

• An Introduction to Forms and Form Controls
• Entering and Validating data through forms
• Intermediate Forms
• Customising Forms
• Dates, Expressions and Artificial Fields in Queries
• Creating a user friendly form

Queries and Reports

• Introduction to Queries
• Multitable Queries
• Parameter Queries
• Append, Delete, and Top Queries
• Use queries to analyse data
• Utilizing Queries for competitive advantage
• Forms with Subforms
• Form Control Properties
• Advanced Forms
• Expressions in Reports and Queries
• Basic Reports
• Intermediate Reports
• Reporting for Management
• Creating mailing labels
• Mail merge for producing standardised letters

Graphs

Other tasks

• Complex Reports
• Introduction to Macros
• Sophisticated Queries (Update, Crosstab)
• Customizing Access