ACC10INT: Microsoft Access 2010 - Level 1 / Intro

Start Date Time Days Price GTR Availability
September 05, 2017 09:00 (EST) 2 $710.00 Register
October 16, 2017 09:00 (EST) 2 $710.00 Register
October 16, 2017 09:00 (EST) 2 $710.00 Register

Duration: 2 days

Course Description

Students will learn how to use the Access 2007/2010 interface to create a simple database including tables, forms, queries and reports.

Prerequisites

Students should be familiar with Windows 7 or 8 and Microsoft Office.

Course Objectives

In this course, you will learn how to use Access 2010 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Audience

For individuals and organizations needing to collect and manage large amounts of data.

Course Content

The New Interface

  • Using the Quick Access Toolbar
  • Basics of Tabs
  • The Home Tab
  • The Create Tab
  • The External Data Tab
  • The Database Tools Tab

Creating a Database

  • Creating a Database
  • Understanding the Different Objects
  • Using the Getting Started Window
  • The Trust Center
  • Getting Help

Tables

  • Creating a Table
  • Creating Fields
  • Naming Fields
  • Type of Data
  • Field Description
  • Primary Key
  • Saving a Table
  • View Table Relationships

Queries

  • The Queries Window
  • Basic Queries
  • Multi Table Queries

Forms

  • Creating a Default Form
  • Creating a Form in Design View
  • Adding Controls
  • Formatting a Form
  • Form Design Tool
  • Form Properties
  • Adding Felds to a Form

Reports

  • Creating a Report
  • Using the Report Wizard
  • Creating a Report in Design View
  • Formatting a Report

Additional tools

  • Sorting and Filtering Data
  • Viewing Data
  • Printing a Database Object