Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Access 2010 Level 1 Database Design

GK# 8254

Course Overview

TOP

In this course with hands-on labs, you will become familiar with introductory features and functionality relating to Microsoft Access 2010 databases.

What You'll Learn

TOP
  • Components of a database and how to work with those components
  • Open a table, find information stored there, and enter data
  • Create and customize a table design
  • Enter data into tables, and ensure its accuracy by using input masks and input validation formulas
  • Create relationships between tables to ensure data accuracy and to deploy referential integrity
  • Create forms for entering data into tables, and change the design elements that have been placed on those forms
  • Create several query types, edit and run queries, and use action and calculation queries
  • Create several report types, enhance reports, and print preview reports
  • Import and export data to and from various sources, including text files and Excel
  • Preview and print database objects, and change the page setup options

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. The Basics

  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access 2010 Files
  • Working with Objects
  • Using Access Help
  • Review Exercise

2. Table Data

  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters
  • Review Exercise

3. Table Design

  • Creating a Table
  • Changing the Table Design
  • Review Exercise

4. Data Entry

  • Data Entry Concepts
  • Data Formats
  • Input Masks
  • Input Validation
  • Adding Records
  • Review Exercise

5. Relationships

  • Relationships Between Tables
  • Creating a Relationship
  • Referential Integrity
  • Removing a Relationship
  • Printing Relationships
  • Review Exercise

6. Creating and Using Forms

  • Creating a Form Using AutoForm
  • Creating a Form Using the Form Wizard
  • Creating a Form in Design View
  • Opening a Form
  • Changing a Form Design
  • Adding Controls
  • Placing Controls
  • Multiple-Choice Controls
  • Error Checking
  • Review Exercise

7. Queries

  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries
  • Review Exercise

8. Reports

  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes
  • Review Exercise

9. Importing and Exporting Data

  • Importing and Exporting
  • Importing a Text File
  • Importing Data from an Access Database
  • Exporting Data
  • Troubleshooting Importing and Exporting Problems

10. Printing

  • Printing Objects
  • Print Preview

Who Should Attend

TOP

Those who are new to Microsoft Access 2010

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Request this course in a different delivery format.
Enroll