I Want Answers
By submitting this form, you are giving your express
written consent for PPG to contact you regarding our
services using email, telephone or text - including our
use of automated technology for calls and periodic texts
to any wireless number you provide.
Access Introduction (2016, 2019, 365)
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.
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to: • 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.
There are no prerequisites for this course.
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
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323