Course package

A02

Development and Implementation of an Access Database («A02»)

In this modular, six-day intensive seminar, our experienced trainers will teach you both the theory of relational databases and their implementation in Microsoft Access using several examples.
Vendor code

A03, A04, Digicomp A05

Duration 6 days
Price 3'600.–
Course documents Digital Digicomp courseware

Course facts

  • Designing, building and implementing Access databases

1 The Relational Database Model

  • Definitions and Structure
  • Normal shapes
  • Database modeling

2 Tables

  • Creating Tables
  • Import/Link Tables
  • Customizing Tables

3 Table connections

  • Defining Links
  • Setting Relationships

4 What else to know

  • Migrating Data
  • Access to database servers (MySQL, MS SQL server, etc.)
  • Publish Data

5 Queries

  • Single and multi-table queries
  • Filter/Sort
  • Calculations (horizontal/vertical)
  • Cross tables
  • SQL queries

6 Reports Forms

  • Simple Reports
  • Grouped Reports
  • Main and subreports
  • Mail Merge
  • Diagrams

7 Forms

  • The simple form
  • The main with subform
  • The split form
  • The navigation form

8 Automate Operations

  • Makros versus Module (VBA)
  • The Simple Macro
  • The Group Macro
  • The Autoexec macro
  • Macro conditions and filters
  • Create and customize VBA code with wizards

9 Database security

  • Backup Methods
  • Multi-user access

10 The finishing touch

  • The Startup Options
  • Custom Ribbons
  • Publish and package the database

PowerUsers and developers who need to build Microsoft Access databases and want to acquire the necessary knowledge in the shortest possible time

Good Windows (7, 8.x, or 10) and Office basics are required for this course.

Download

Questions

Choose your date

Further courses

Lernen Sie Ihre Trainer kennen