Introduction to MS Access

Access Basics

• What is a relational database?
• Access database objects
• Working with an existing Access database
• Add, edit, delete a record using a table and a form
• Check spelling and AutoCorrect
• Find and replace data
• Sort data
• Filter data
• Print data

Database Design Concepts

• Organise data
• Normalization
• Relationships
• Referential integrity
• Primary key/foreign key
• Constraints
• Indexes
• Data types

Create an Access Database

• Using Wizards
• Defining relationships in Access
• Access data types
• Access database limitations

Access Table Design

• Using design view
• Adding and naming fields
• Assigning field types
• Assigning field properties
• Creating key fields
• Index considerations

Forms

• Using the Form Wizard
• Modifying the form design
• Using a form to locate and organise information

Queries

• Create a query in Design View
• Joining tables in a query
• Add criteria to a query
• Using wildcards
• Add calculations to a query

Reports

• AutoReport
• Report Wizard
• Modify a report