$245.00

1 days

Audience

Prerequisites

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

Aug 24 2017 - Aug 24 2017

8:00 am - 4:30 pm

11935 Market Place Ave, Baton Rouge, LA 70816

ENROLL

Sep 07 2017 - Sep 07 2017

8:00 am - 4:30 pm

11935 Market Place Ave, Baton Rouge, LA 70816

ENROLL

Oct 12 2017 - Oct 12 2017

8:00 am - 4:30 pm

11935 Market Place Ave, Baton Rouge, LA 70816

ENROLL

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