ACSL3: Microsoft Access - Creating Complex Databases

To ensure your success it is recommended you have completed the Microsoft Access 2016 Creating Relational Databases course or have experience working with Microsoft Access 2016, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. 

After completing this course, students will be able to:

• Customise a form layout to improve usability and efficiency of data entry.
• Share data across applications.
• Use macros to improve user interface design.
• Use VBA to enhance tasks.
• Organise data into appropriate tables to ensure data dependency and minimize redundancy.
• Lock down and prepare a database for distribution to multiple users.
• Create and modify a database switchboard and set the startup options.

Implementing Advanced Form Design 
 Add Controls to Forms 
 Enhance Navigation and Organization of Forms 
 Apply Conditional Formatting 

Sharing Data Across Applications 
 Import Data into Access 
 Export Access Data 
 Link Tables to External Data Sources 
 Create a Mail Merge 

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 

Using VBA 
 Getting Started with VBA 
 Enhance Access Using VBA
 
Using Advanced Database Management 
 Manage a Database 
 Determine Object Dependency 
 Document a Database 

Distributing and Securing a Database 
 Splitting a Database for Multiple User Access 
 Implement Security 
 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