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.

See specific content information below in the "Attend and You Will Learn" section.

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.

Attend and You Will Receive

Participants who successfully complete this course will receive a certificate of completion from NC State University

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
Online
Days
T
Time
9:00AM to 4:00PM
Dates
Sep 01, 2020
Schedule and Location
Contact Hours
7.0
Location
  • Off Campus
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors
Section Title
Access Level 1
Type
Online
Days
Th
Time
9:00AM to 4:00PM
Dates
Nov 19, 2020
Schedule and Location
Contact Hours
7.0
Location
  • Off Campus
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors