About this course

Course type Essentials
Course code DAC13L3
Duration 1 Day

You've covered many of the basic functions of Microsoft Access and now you're ready to learn advanced Access features such as: database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Target Audience:

Your training in and use of Microsoft Access 2013 has provided you with a solid foundation in the basic and intermediate skills. You have worked with the various Access objects, such as tables, queries, forms and reports.

Prerequisites

  • Understand the steps required to properly design a database
  • Create a database
  • Create tables and table relationships
  • Control data entry with field properties
  • Create queries and understand query joins
  • Create reports and subreports
  • Add and format controls on forms and reports
  • Import and export data

Delegates will learn how to

At the end of this course you will be able to:

  • Create and customise advanced forms
  • Work with data validation
  • Create and revise Access 2013 macros
  • Use tools to manage database efficiency
  • Distribute and secure databases
  • Work with switchboards and startup options

Outline

Lesson 1: Implementing Advanced Form Design

  • Topic A: Add Controls to Forms
  • Topic B: Create Subforms
  • Topic C: Organise Information with Tab Pages
  • Topic D: Enhance Navigation of Forms
  • Topic E: Apply Conditional Formatting

Lesson 2: Using Data Validation

  • Topic A: Field and Record Validation
  • Topic B: Form Validation

Lesson 3: Using Macros to Improve User Interface Design

  • Topic A: Create a Macro
  • Topic B: Restrict Records Using a Condition
  • Topic C: Validate Data Using a Macro
  • Topic D: Automate Data Entry Using a Macro
  • Topic E: Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

  • Topic A: Link Tables to External Data Sources
  • Topic B: Manage a Database
  • Topic C: Determine Object Dependency
  • Topic D: Document a Database
  • Topic E: Analyse the Performance of a Database

Lesson 5: Distributing and Securing a Database

  • Topic A: Splitting a Database for Multiple User Access
  • Topic B: Implement Security
  • Topic C: Set Passwords
  • Topic D: Convert an Access Database to an ACCDE File
  • Topic E: Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

  • Topic A: Create a Database Switchboard
  • Topic B: Modify a Database Switchboard
  • Topic C: Set Startup Options
Essentials

1 Day

Duration
Microsoft Access
Delivery Method

Delivery method

Classroom / Attend from Anywhere

Receive classroom training at one of our nationwide training centres, or attend remotely via web access from anywhere.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.