Microsoft Access Introduction

Please reload

Duration - 2 day
Please reload

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