Details

Goals

Be able to create an Access database.

Prerequisite

Know the Windows environment. No Access knowledge required.

Contents

Relational database design

  • Table Design

  • Relational schema design

Terminology

  • Create a database table

  • Edit a the structure of a table in datasheet view

  • Edit the structure of a table in design view

  • Set field properties

  • Create a combobox (dropdown list)

  • Index a field

  • Set a primary key

Relationships

  • Create a relationship between two tables

  • Enable referential integrity

  • Manage database relationships

  • Display/edit related data in a subdatasheet

  • Print database relationships

Sign up

Next session(s)

This training is exclusively on request. Contact us to get a personalized offer.

Sessions available in

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!