Course 50533A: Learn Microsoft Access 2010 Step by Step, Level 2

Type:Course
Audience(s):information workers
Technology:Microsoft Access
Level:100
This Revision:A
Delivery method:
Instructor-led (classroom)
Length:1 day
Language(s):English

First published:

03 June 2011
Overview
About this course
This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Access 2010.
Audience profile
This course is intended for information workers who want to learn intermediate-level Access 2010 skills.
At course completion
After completing this course, students will be able to:
  • Restrict the type of data.
  • Restrict the amount of data.
  • Restrict the format of data.
  • Restrict data by using validation rules.
  • Restrict data to values in lists.
  • Restrict data to values in other tables.
  • Modify forms created by using a wizard.
  • Add controls.
  • Add subforms.
  • Use e-mail forms to collect data.
  • Create queries by using a wizard.
  • Create queries manually.
  • Use queries to summarize data.
  • Use queries to perform calculations.
  • Use queries to update records.
  • Use queries to delete records.
  • Create reports manually.
  • Modify report content.
  • Add subreports.
Course details
Course OutlineModule 1: Maintain Data Integrity
This module explains how to ways to help ensure the accuracy of data entered into a database.
Lessons
  • Restricting the Type of Data
  • Restricting the Amount of Data
  • Restricting the Format of Data
  • Restricting Data by Using Validation Rules
  • Restricting Data to Values in Lists
  • Restricting Data to Values in Other Tables
Lab : Restricting the Type of DataLab : Restricting the Amount of DataLab : Restricting the Format of DataLab : Restricting Data by Using Validation RulesLab : Restricting Data to Values in ListsLab : Restricting Data to Values in Other Tables
After completing this module, students will be able to:
  • Restrict the type and amount of data entered into a field.
  • Require that data entered in a field be in a certain format.
  • Use validation rules to prohibit invalid data.
  • Limit the options for entering information in a database.
  • Create a list of possible values for a field from the entries in a field in a related table.
Module 2: Create Custom Forms
This module explains how to customize forms to facilitate data entry and display.
Lessons
  • Modifying Forms Created by Using a Wizard
  • Adding Controls
  • Adding Subforms
  • Using E-Mail Forms to Collect Data
Lab : Modifying Forms Created by Using a WizardLab : Adding ControlsLab : Adding Subforms
After completing this module, students will be able to:
  • Work in Design view to modify a form.
  • Customize forms by adding controls.
  • Use subforms to enter data in more than one table.
Module 3: Create Queries
This module explains how to use the Query wizard to create a select query, how to use the Query Designer to created less common queries, and how to perform calculations and update and delete table information.
Lessons
  • Creating Queries by Using a Wizard
  • Creating Queries Manually
  • Using Queries to Summarize Data
  • Using Queries to Perform Calculations
  • Using Queries to Update Records
  • Using Queries to Delete Records
Lab : Creating Queries by Using a WizardLab : Creating Queries ManuallyLab : Using Queries to Summarize DataLab : Using Queries to Perform CalculationsLab : Using Queries to Update RecordsLab : Using Queries to Delete Records
After completing this module, students will be able to:
  • Create queries to find records and create calculated fields.
  • Summarize matched records.
  • Have Access update and delete records.
Module 4: Create Custom Reports
This module explains how to extract information from a database as a report. It also explains how to modify a report content and add a subreport.
Lessons
  • Creating Reports Manually
  • Modifying Report Content
  • Adding Subreports
Lab : Creating Reports ManuallyLab : Modifying Report ContentLab : Adding Subreports
After completing this module, students will be able to:
  • Create reports to extract information from a database.
  • Customize the appearance and contents of a report.
  • Insert a subreport within a report and perform calculations in it.
Prerequisites
Before attending this course, students must have:
  • Basic computer knowledge.
  • Basic file-management skills.
  • Basic knowledge of the Access 2010 interface and database, table, and form creation and manipulation.
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you