$710.00 CAD / 2 DAYS

1) Select Location for Dates in Your City:


Choose Date

Date is Guaranteed to Run

Notify me Click on date to Register Now or click Notify Me to receive an email notification when course is Guaranteed to Run. once the following courses become Guaranteed to run.

No available dates.
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,

Jump to Shopping Cart Continue shopping

ACC10INT: Microsoft Access 2010 – Level 1 / Intro

 

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