COURSE TITLE

1 DAY

$295.00

Audience

Prerequisites

Course Files

DESCRIPTION

A relational database application such as Microsoft® Office Access® 2016 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 use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

WHAT YOU WILL LEARN HERE
A relational database application such as Microsoft® Office Access® 2016 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 use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

OUTLINE
LESSON 1: GETTING STARTED WITH ACCESS
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help and Configure Options in Microsoft Access
LESSON 2: WORKING WITH TABLE DATA
Topic A: Modify Table Data
Topic B: Sort and Filter Records
LESSON 3: QUERYING A DATABASE
Topic A: Create Basic Queries
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query
LESSON 4: USING FORMS
Topic A: Create Basic Access Forms
Topic B: Work with Data on Access Forms
LESSON 5: GENERATING REPORTS
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print
Topic E: Organize Report Information
Topic F: Format Reports

SCHEDULED COURSES

DON’T SEE WHAT YOU ARE LOOKING FOR?
Team Real World is prepared to handle your unique and custom course needs. Submit your request for specific course dates, times and locations and we will be in touch to help coordinate a schedule that best suits your needs. Even if you don’t see a course on the list, let us know what you need. We are happy to consider all course suggestions.

Return to Live Events Catalog