ESTIMATED AVERAGE TIME:

14hrs 30mins

​

PART 2 COURSE OUTLINED

This course is intended to help all users get up to speed on the different features of Access and to become familiar with its more advanced features. Students will cover how to complete advanced form design tasks, add field and record validation, create and manage macros, conduct advanced database management, distribute and secure a database, and manage switchboards.

​

 FREE DOWNLOAD LESSON 1 

​

Lesson 1: Advanced Form Design

Average time 3hrs: 42mins

The first lesson in this course covers how to add controls to forms, create subforms, and organize information with tab pages. It also covers how to display a summary of data in a form using PivotTables and PivotCharts, apply conditional formatting, and customize form options using contextual tabs.
 

Lesson 2: Field and Record Validation

Average time 2hrs: 13mins

In this lesson, students will learn about field, record, and form validation.
 

Lesson 3: Using Macros to Improve User Interface Design

Average time 3hrs: 12mins

This lesson covers how to create macros, restrict records using a condition, validate data using a macro, automate data entry using a macro, and convert a macro to VBA.

Lesson 4: Advanced Database Management

Average time 1hr: 56mins

Next, students will learn how to link tables to external data sources, manage a database, determine object dependency, document a database, and analyze the performance of a database.
 

Lesson 5: Distributing and Securing a Database

Average time 2hrs: 49mins

Preparing a database for multiple user access, securing a database, and setting database passwords will be covered in this lesson. This lesson also covers how to convert an Access database to an ACCDE file format and how to package a database with a digital signature.
 

Lesson 6: Managing Switchboards

Average time 38mins

In the final lesson, students will learn how to create a database switchboard, modify a database switchboard, and set startup options.