Access 2010 - Level 1

Course details

In this course, students will create and modify new databases and their various objects. Students will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2010 with other applications. 

What will I learn?

Lesson 1: Getting Started with Access 2010

• Identify the Elements of the Access 2010 Interface
• Identify the Components of a Database
• Examine the Relational Database
• Design Process

Lesson 2: Building The Structure of a Database

• Create a New Database
• Create a Table Using Design View
• Modifying the Table Structure
• Establish Table Relationships

Lesson 3: Managing Data in a Table

• Modify Table Data
• Sort and Filter Records
• Work with Subdatasheets

Lesson 4: Querying a Database

• Create a Query
• Add Criteria to a Query
• Add a Calculated Field to a Query
• Perform Calculations on a Record Grouping

Lesson 5: Designing Forms

• Create a Form
• Modify the Design of a Form
• View and Add Data Using an Access Form

Lesson 6: Generating Reports

• Create a Report
• View an Access Report
• Add a Calculated Field to a Report
• Format the Controls in a Report
• Apply a Theme to a Report
• Prepare a Report for Print

Lesson 7: Controlling Data Entry

• Constrain Data Entry Using Field Properties
• Establish Data Entry Formats for Entering Field Values
• Create a List of Values for a Field

Lesson 8: Joining Tables

• Create Query Joins
• Join Unrelated Tables
• Relate Data Within a Table

Lesson 9: Creating Flexible Queries

• Retrieve Records Using Select Queries
• Retrieve Records Based On Input Criteria
• Manipulate Data Using Queries

Lesson 10: Improving Forms

• Design a Form Layout
• Enhance the Appearance of a Form
• Restrict Data Entry in Forms
• Add a Command Button to a Form
• Create a Subform

Lesson 11: Customizing Reports

• Organize Report Information
• Format Reports
• Control Report Pagination
• Summarize Report Information
• Add a Subreport to an Existing Report
• Create a Mailing Label Report

Lesson 12: Sharing Data Across Applications

• Import Data into Access
• Export Data
• Analyze Access Data in Excel
• Export Query Results
• Mail Merge Access Data With a Word Document

Prerequisites

Students should be familiar with using personal computers and have used a mouse and keyboard. Students should be comfortable with the Windows environment and be able to use Windows to manage information on their computer. Specifically, students should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.