Microsoft Access 2016 - Level 1
Learn how to create a variety of data tables and forms, analyze the data, and write reports. In Level 1 examine basic database concepts, create and modify databases, and be introduced to basic concepts of performing queries and building reports.
Previous knowledge or experience: Understanding of the basics of Windows
Target Student: This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Overview: A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data.
In this course, you will learn how to 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.
Course Objectives: In this course, you will learn to create and manage a fundamental Access 2016 database.
You will: Navigate within the Microsoft Access application environment and create a simple database. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Create advanced queries, including action queries and parameter queries. Create and format custom reports. Customize Access configuration options.
Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help in Microsoft Access
Lesson 2: Working with Table Data
Topic A: Modify Table Data
Topic B: Sort and Filter Records
Topic C: Create Lookups
Lesson 3: Querying a Database Topic A: Join Data from Different Tables in a Query
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query
Lesson 4: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Create Action Queries
Topic C: Create Unmatched and Duplicate Queries
Topic D: Summarize Data
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 Lesson 6: Customizing the Access Environment Topic A: The Access Options Dialog Box
|Dates:||July 15, 2020 Check for other dates|
|Meets:||One Wed., 9AM-4PM 07/15|
|Location:||CFU LOWRY: Near 1st & Quebec|
You could save $15.00 on this course by becoming a member of CFU Membership
There are still openings remaining at this time.
A valid credit card will be required for payment. Please have your card information ready.
Enrollment Progress ... What's This?