Calendar

May 2012 June 2012
Mo Tu We Th Fr Sa Su
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31

Search

Search

Access 1 2010
Download PDF

Next Dates:
Wed, 31. Oct. 2012
Tue, 30. Oct. 2012
Thu, 13. Sep. 2012
Wed, 12. Sep. 2012
Tue, 12. Jun. 2012
Mon, 11. Jun. 2012

Choose a date:



Mode:

Length:
2 days

Location:
Ottawa

Language:
EE

Max Attendees:
10 Students

Price:
$ 470

Target audience & Prerequisites:
Participants should have basic knowledge of Windows, keyboard and mouse operations.

Learning objectives:
On completion of course, participants will be able to design and modify tables, create relationships, use queries, design and modify forms and reports.

Course Outline:

Getting Started with Access 2010
  • Identify the Elements of the User Interface
  • Identify the Tabs and Commands on the Ribbon
  • Obtain Help in Access
  • Identifying the Components of a Database
  • Define Database Concepts
  • Identify the Components of a Database
  • Examine the Relational Database Design Process
Organizing Data in Tables
  • Create a Table
  • Modify Table Data and Properties
  • Create a Table Relationship
Viewing Data in Tables
  • Sort Records
  • Filter Records
  • View Data from Related Tables
Querying a Database
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
Designing Forms
  • Create a Form
  • View Data Using an Access Form
  • Modify a Form
Generating Reports
  • View an Access Report
  • Create a 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

      Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca: