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.

Updated on 08 November, 2015

About New Horizons Singapore

Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business

See all New Horizons Singapore courses
Are you from New Horizons Singapore ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Access starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or