Microsoft Access 2016 Professional Diploma

Course

Online

Save 93%

Special Emagister price

£ 19 £ 297 VAT inc.

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Class hours

    16h

  • Duration

    Flexible

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

The Access 2016 is the latest database management system created by Microsoft. Professionals who want to create, store, and share data that will benefit in this training to help you navigate Access 2016 and use its features and tools.
You will be able to create a database after trying this Microsoft Access 2016 Professional Diploma. You can also learn how to create tables, forms, queries, and reports using Access 2016. If you are interested then start building your technical skills is the way to go.

Important information

Price for Emagister users:

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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 Management
  • Database
  • Database training
  • Microsoft Access
  • Convert a Macro to VBA
  • Using Data Validation
  • Determine Object Dependency
  • Document a Database
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Split a Database

Teachers and trainers (1)

Alpha Academy

Alpha 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
  • Activities – Microsoft Office 2016 Complete Diploma Level 3
Mock Exam

Final Exam

Assessment and Certification

At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39.

Microsoft Access 2016 Professional Diploma

Special Emagister price

£ 19 £ 297 VAT inc.