This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.
- Adding Controls to Forms
- Creating Subforms
- Organising Information with Tab Pages
- Displaying a Summary of Data in a Form
- Applying Conditional Formatting
- Field and Record Validation
- Form Validation
- Creating a Macro
- Restricting Records Using a Condition
- Validating Data Using a Macro
- Automating Data Entry Using a Macro
- Converting a Macro to VBA
- Linking Tables to External Data Sources
- Managing a Database
- Determining Object Dependency
- Documenting a Database
- Analysing the Performance of a Database
- Preparing a Database for Multiple User Access
- Implementing Security
- Setting Passwords
- Converting an Access Database to an ACCDE File
- Packaging a Database with a Digital Signature
- Creating a Database Switchboard
- Modifying a Database Switchboard
- Setting Startup Options
This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
Before attending this course, students must have attended Access 2010 – Level 1.
Upon successful completion of this course, students will be able to:
- Restructure data into appropriate tables to ensure data dependency and minimise redundancy
- Write advanced queries to analyse and summarise data
- Create macros
- Customise reports by using various Access features
- Maintain your database using Access tools
Register
Not currently scheduled
Fast track the availability of this course.
Add to watch list or call 1300 794 006.
Add to watch list or call 1300 794 006.
Request a Quote
About Microsoft On-Demand Learning
Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.
MOC On-Demand at a Glance
Self-Paced Learning
Immediate Feedback on Mastery
SATV Eligible
Direct From the Source
Learn Anywhere Anytime
Live Hands-on
Labs
