Learn Microsoft Access 2010 Step by Step, Level 2

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 Outline

Module 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 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

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 Wizard

Lab : Adding Controls

Lab : 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 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

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 Manually

Lab : Modifying Report Content

Lab : 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.

Training Schedule

Learn Microsoft Access 2010 Step by Step, Level 2
2019 - 2020
Training schedule not found.
BACK TO TOP
Close