Microsoft Access Introduction - In-company / Bespoke

Introducing Microsoft Access

• The Access interface

Database terminology

• Access database objects
• Fields and records
• Properties

Designing a database

• Planning and designing a table
• Creating fields
• Setting common field properties
• Defining key fields

Working with table data

• Entering and editing data
• Sorting and filtering table records
• Deleting records

Relationships

• Why use table relationships?
• Relationship types
• Referential Integrity
• Working with table subdatasheets

Querying a database

• Creating simple Select Queries
• Specifying query criteria
• Sorting query results
• Adding calculated fields

Designing Forms

• Creating simple forms for data entry
• Designing custom forms
• Working with form sections
• Creating sub forms

Designing Reports

• Creating basic list reports
• Working with grouping and sorting in a report
• Adding totals to a report