Microsoft Access 2013 Level 3

Difficulty
Rating
430,00 
+ VAT

We are sorry, but currently we don't know when the course will be arranged next time.
Please contact sales: +358 20 7776 670 or myyntipalvelu@sovelto.fi

Overview

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.

Objectives

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

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

 

Places left:
No participant limit
430,00  + VAT