Course 50532: Learn Microsoft Access 2010 Step by Step, Level 1

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:

June 3, 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 beginning level Access 2010 skills.
At course completion
After completing this course, students will be able to:
  • Work in Access 2010.
  • Understand database concepts.
  • Explore tables.
  • Explore forms.
  • Explore queries.
  • Explore reports.
  • Preview and print Access objects.
  • Create databases from templates.
  • Create databases and tables manually.
  • Manipulate table columns and rows.
  • Refine table structure.
  • Create relationships between tables.
  • Create forms by using the Form tool.
  • Change the look of forms.
  • Change the arrangement of forms.
  • Sort information in tables.
  • Filter information in tables.
  • Filter information by using forms.
  • Locate information that matches multiple criteria.
  • Create reports by using a wizard.
  • Modify report design.
  • Preview and print reports.
Course details
Course OutlineModule 1: Explore an Access 2010 Database
This module discusses the Access interface and explores various database components, including tables, forms, queries, and reports.
Lessons
  • Working in Access 2010
  • Understanding Database Concepts
  • Exploring Tables
  • Exploring Forms
  • Exploring Queries
  • Exploring Reports
  • Previewing and Printing Access Objects
Lab : Working in Access 2010
  • Explore the program window
  • Explore tables
  • Explore forms
  • Explore queries
  • Preview a report
  • Preview and print database objects
Lab : Exploring Tables
  • Explore the program window
  • Explore tables
  • Explore forms
  • Explore queries
  • Preview a report
  • Preview and print database objects
Lab : Exploring Reports
  • Explore the program window
  • Explore tables
  • Explore forms
  • Explore queries
  • Preview a report
  • Preview and print database objects
Lab : Exploring Forms
  • Explore the program window
  • Explore tables
  • Explore forms
  • Explore queries
  • Preview a report
  • Preview and print database objects
Lab : Exploring Queries
  • Explore the program window
  • Explore tables
  • Explore forms
  • Explore queries
  • Preview a report
  • Preview and print database objects
Lab : Previewing and Printing Access Objects
  • Explore the program window
  • Explore tables
  • Explore forms
  • Explore queries
  • Preview a report
  • Preview and print database objects
After completing this module, students will be able to:
  • Work in the Access environment.
  • Describe how a database works.
  • Open and move around in tables, forms, queries, reports, and other Access objects.
  • Preview and print objects, such as tables and forms.
Module 2: Create Databases and Simple Tables
This module explains how to create databases and tables, either manually or from templates, and how to change table formatting and structure. It also explains how to create relationships between tables.
Lessons
  • Creating Databases from Templates
  • Creating Databases and Tables Manually
  • Manipulating Table Columns and Rows
  • Refining Table Structure
  • Creating Relationships Between Tables
Lab : Creating Databases and Tables Manually
  • Use a template as the basis for a database
  • Create a table in a blank database, and then add records
  • Change table formatting
  • Change table structure
  • Create relationships between tables
Lab : Manipulating Table Columns and Rows
  • Use a template as the basis for a database
  • Create a table in a blank database, and then add records
  • Change table formatting
  • Change table structure
  • Create relationships between tables
Lab : Refining Table Structure
  • Use a template as the basis for a database
  • Create a table in a blank database, and then add records
  • Change table formatting
  • Change table structure
  • Create relationships between tables
Lab : Creating Relationships Between Tables
  • Use a template as the basis for a database
  • Create a table in a blank database, and then add records
  • Change table formatting
  • Change table structure
  • Create relationships between tables
Lab : Creating Databases from Templates
  • Use a template as the basis for a database
  • Create a table in a blank database, and then add records
  • Change table formatting
  • Change table structure
  • Create relationships between tables
After completing this module, students will be able to:
  • Create databases in various ways.
  • Add tables to a database.
  • Rearrange and size table columns and rows.
  • Modify, add, and delete table fields.
  • Define table relationships.
Module 3: Create Simple Forms
This module explains how to create forms to view and enter data, modify the appearance of a form, and customize the layout of a form.
Lessons
  • Creating Forms by Using the Form Tool
  • Changing the Look of Forms
  • Changing the Arrangement of Forms
Lab : Creating Forms by Using the Form Tool
  • Create a form that uses all the fields in a table
  • Change a form’s appearance
  • Arrange form labels and controls
Lab : Changing the Arrangement of Forms
  • Create a form that uses all the fields in a table
  • Change a form’s appearance
  • Arrange form labels and controls
Lab : Changing the Look of Forms
  • Create a form that uses all the fields in a table
  • Change a form’s appearance
  • Arrange form labels and controls
After completing this module, students will be able to:
  • Use the Form Tool to create a form based on a table.
  • Change the form’s properties.
  • Change the form’s layout.
Module 4: Display Data
This module explains how to display information in useful ways, by sorting and filtering tables, and by filtering information in forms.
Lessons
  • Sorting Information in Tables
  • Filtering Information in Tables
  • Filtering Information by Using Forms
  • Locating Information That Matches Multiple Criteria
Lab : Sorting Information in Tables
  • Sort a table in various ways
  • Filter a table
  • Use the Filter By Form command
  • Find information that matches two criteria
Lab : Filtering Information in Tables
  • Sort a table in various ways
  • Filter a table
  • Use the Filter By Form command
  • Find information that matches two criteria
Lab : Filtering Information by Using Forms
  • Sort a table in various ways
  • Filter a table
  • Use the Filter By Form command
  • Find information that matches two criteria
Lab : Locating Information That Matches Multiple Criteria
  • Sort a table in various ways
  • Filter a table
  • Use the Filter By Form command
  • Find information that matches two criteria
After completing this module, students will be able to:
  • Find information by sorting and filtering in tables.
  • Display information by filtering in forms.
  • Use the Advanced Filter/Sort command to find records that meet multiple criteria.
Module 5: Create Simple Reports
This module explains how to extract information from a database as a report. It also explains how to modify report design and preview and print reports.
Lessons
  • Creating Reports by Using a Wizard
  • Modifying Report Design
  • Previewing and Printing Reports
Lab : Creating Reports by Using a Wizard
  • Use a wizard to produce a report
  • Change the layout and formatting of a report
  • Preview and fine-tune a report
Lab : Modifying Report Design
  • Use a wizard to produce a report
  • Change the layout and formatting of a report
  • Preview and fine-tune a report
Lab : Previewing and Printing Reports
  • Use a wizard to produce a report
  • Change the layout and formatting of a report
  • Preview and fine-tune a report
After completing this module, students will be able to:
  • Create reports to extract information from a database.
  • Customize the design of reports.
  • Provide neatly printed copies of reports.
Prerequisites
Before attending this course, students must have:
  • Basic computer knowledge.
  • Basic file-management skills.
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