Loading...

Course Description

A relational database application such as Microsoft® Office Access® can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Related Courses

Other Courses

Why You Should Attend

This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities and who want to use the application to be more productive in their work.

Prerequisites

It is best if you have prior experience with Windows operating systems and basic knowledge of Microsoft Word and/or Excel.

Attend and You Will Learn / Expected Outcome

Attend And You Will Learn

Getting Started with Access

  • Orientation to Microsoft Access
  • Creating a simple Access database
  • Getting help in Microsoft Access

Working with Table Data

  • Working with table data
  • Modifying table data
  • Sorting and filter records
  • Creating lookups

Querying a Database

  • Joining data from different tables in a query
  • Sorting and filter data in a query
  • Performing calculations in a query

Creating Advanced Queries

  • Creating parameter queries
  • Creating action queries
  • Creating unmatched and duplicate queries
  • Summarizing data

Generating Reports

  • Creating a report
  • Adding controls to a report
  • Enhancing the appearance of a report
  • Preparing a report for print

Customizing the Access Environment

  • The Access options dialog box

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Access Level 1
Type
In-Class
Days
W
Time
9:00AM to 4:30PM
Dates
Mar 11, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors
Section Title
Access Level 1
Type
In-Class
Days
T
Time
9:00AM to 4:30PM
Dates
May 05, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors
Section Title
Access Level 1
Type
In-Class
Days
T
Time
9:00AM to 4:30PM
Dates
Jul 14, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors