Access 2019/365 – Level 1

Introduction

• Understand what a relational database managing system is (differences between Excel & Access)
• Understand the Access environment (goal, specific vocabulary…)
• Know the purpose of the various objects (tables, queries, forms, reports)

Tables

• Using data view
  • Viewing, adding, deleting and updating records
  • Searching, sorting and filtering
  • Table formatting

• Creating tables
  • Understand design view
  • Know the various data types (basic and secondary types)
  • Master field properties

Selection queries

• Understand the basic query concept
• Master the query creation interface (selecting, moving fields, adding, removing a table)
  • Sorting query results
  • Hiding a field in a query result
  • Saving a query
  • Selecting record (filtering)
  • Using logical criteria AND / OR
  • Using operators such as « like », « ? », « * »
  • Using parameters « [] »
  • Other operators : « Null » « Not »
  • Creating calculated fields
  • Using the expression builder
  • Creating a calculated field using a formula
  • Learning how to use Access functions
  • Formatting a calculated field (format and caption)
  • Inserting a parameter in a calculation
  • Grouping
  • Using statistical functions (sum, average, min, max, count)
  • Other criteria : « Where »

Relationships

• Understanding the necessity of relationships
• Knowing the 3 types of relationships (1 to 1, 1 to many, many to many)
• Understanding the concept of primary key and foreign key
• Mastering referential integrity
• Implementing a 1 to many relationship in Access
• Creating selection queries that use several tables

Forms

• Creating forms using the wizard
• Using basic controls
• Using conditional formatting

Reports

• Creating reports using the wizard
• Using basic controls
• Using label creation wizard