ACCESS / IT · 2 Days

Microsoft Access Introduction

At the end of this course you will be able to identify the common objects of an Access database, design and build the structure of a database, input and maintain data, design user-friendly data entry forms, search the database using queries, and generate reports from your data.

Duration: 2 Days From £550/day (up to 8 learners) 1-to-1 or Groups of up to 8 Learners (Larger by Arrangement) M365 (Desktop & Web) · Office 2021/2024 Certificate · Manuals · 1-Year Support

Complete Course Syllabus

Database Concepts & Table Design

  • The Access interface, relational database terminology, and core objects (Tables, Queries, Forms, Reports)
  • Planning and designing tables, creating fields, and selecting appropriate data types
  • Setting field properties (Field Size, Format, Input Mask, Validation Rules, Default Value)
  • Entering, editing, sorting, filtering, and deleting table records

Table Relationships & Referential Integrity

  • Defining Primary Keys and Foreign Keys
  • Understanding One-to-Many and Many-to-Many table relationships
  • Enforcing Referential Integrity and cascading updates/deletes
  • Working with table subdatasheets

Designing Select Queries & Calculations

  • Creating Select Queries using the Query Wizard and Query Design View
  • Specifying single and multi-field query criteria, wildcards, and AND/OR logic
  • Sorting query results, hiding fields, and adding calculated fields

Creating Data Entry Forms & Reports

  • Creating user-friendly data entry forms and modifying form sections and controls
  • Building main forms with embedded subforms
  • Creating list reports, configuring grouping and sorting levels, and adding summary totals
Copied to Clipboard ✓

Ready to Share