Access Database Design 1 Course Details

Database Design

• What is a Relational Database?

• Primary and Foreign Keys

• Relationships

Database Normalisation

• Theory of Normal Forms

• De-normalisation

• Naming Conventions

Designing Table Structures

• Table Design - Hints and Tips

• Creating Tables

• Switching Between Views

• Saving Tables

• Field Properties

• Field Size Property 

• Format and Input Mask Properties

• Caption Property

• Allow Zero Length Property

• Indexed Property

Using Field Properties for Protection

• Objectives

• Required

• Default Value

• Input Mask

• Validation Rule and Validation Text

• Lookups

Table Relationships

• What is a Relationship?

• Relationship Types 

• Creating and Editing Relationships

• Using Lookups for Referential Integrity

• Multi-table Datasheet View

BACK to Access Database Design 1

Queries

• Multi-table Queries

• Calculated Fields

• Adding a Calculated Field to a Query

• The Expression Builder

• Calculating Summary Information

• Crosstab Queries

• General Query Properties

• Checking Referential Integrity

Advanced Queries

• Parameter Queries

• Formatting Query Output
  Query Join Types

• Self Joins and Aliases

• Cross Joins

Action Queries

• What is an Action Query?

• Planning an Action Query

• Make Table Queries

• Append Queries

• Delete Queries

• Update Queries

Importing, Exporting, and Linking Data 

• Importing from Other Data Sources

• Linking Data

• Exporting Data

Database Management Tools

• Database Administration

• Documenting the Database Structure

• Backing Up and Restoring a Database

• Compacting and Repairing a Database

• Setting a Database Password

• Encrypting and Decrypting a Database

Access Performance Issues

• Indexes

• Data Validation

• Table Level Validation

• Relationships and Referential Integrity

• Relationships

• Field Types

• Referential Integrity Options

• Join Types

• Using Lookups for Referential Integrity

• Multi-Table Datasheet View