Microsoft Access Introduction
Duration - 2 day
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