Course details

In this course, students 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.

Course Outline

1 - Implementing Advanced Form Design

  • Add Controls to Forms 
  • Create Subforms 
  • Organize Information with Tab Pages 
  • Enhance Navigation of Forms 
  • Apply Conditional Formatting

2 - Using Data Validation

  • Field and Record Validation 
  • Form Validation

3 - 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

4 - 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

5 - Distributing and Securing a Database

  • Splitting 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

6 - Managing Switchboards

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

Target Audience: Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills. This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.

Updated on 08 November, 2015

About New Horizons Ireland

With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.

We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.

Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.

See all New Horizons Ireland courses
Are you from New Horizons Ireland ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Access starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or