Microsoft Access 2016 Advanced - CPD & IAO Accredited

Course

Online

Save 89%

Special Emagister price

£ 43 £ 404 VAT inc.

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Class hours

    16h

  • Duration

    Flexible

  • Start date

    Different dates available

Accessing Microsoft’s database application allows you to create and manage the database for all different purposes. Microsoft 2016 is a new version of Access program that combined few new features and connectivity option that you will learn.
This course aims to teach current and new users of Access 2016 tools and other features present in this program. You will learn how to share data across applications and utilize advanced reporting tools in this program.

Important information

Price for Emagister users:

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course


There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.


On receiving your request an academic officer from the course will call you to explain everything about the course, including how you can sign up, payment options and enrollment periods

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Database
  • Database training
  • Accredited
  • Microsoft Access
  • Create a Macro
  • Convert a Macro to VBA
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Field Validation
  • Validate Data Using a Macro

Teachers and trainers (1)

Adams Academy

Adams Academy

Instructor

Course programme

COURSE CURRICULUM

Implementing Advanced Form Design

  • Add Controls to Forms
  • Set Form Controls
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation with Forms
  • Format a Form
  • Apply Conditional Formatting

Using Data Validation

  • Field Validation
  • Form and Record Validation

Using Macros to Improve User Interface Design

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA

Using Advanced Database Management

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Distributing and Securing a Database

  • Split a Database for Multiple User Access
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

Microsoft Access 2016 Advanced - CPD & IAO Accredited

Special Emagister price

£ 43 £ 404 VAT inc.