The Microsoft Access 2010 training Level 2 is a one-day class that introduces students with intermediate level features and functions of Microsoft Access 2010.
Completion of the course equips the participants with the following skill set:
Module 1: Maintain Data Integrity
Lab: Restricting the Type of Data
Lab: Restricting the Amount of Data
Lab: Restricting the Format of Data
Lab: Restricting Data by Using Validation Rules
Lab: Restricting Data to Values in Lists
Lab: Restricting Data to Values in Other Tables
Module 2: Create Custom Forms
Lab: Modifying Forms Created by Using a Wizard
Lab: Adding Controls
Lab: Adding Subforms
Module 3: Create Queries
Lab: Creating Queries by Using a Wizard
Lab: Creating Queries Manually
Lab: Using Queries to Summarize Data
Lab: Using Queries to Perform Calculations
Lab: Using Queries to Update Records
Lab: Using Queries to Delete Records
Module 4: Create Custom Reports
Lab: Creating Reports Manually
Lab: Modifying Report Content
Lab: Adding Sub-Reports
This course is beneficial for information workers who want to learn intermediate level Access 2010 skills.
Before attending this course, candidates must have:
Name | Code | Fee |
---|
OR