Access 2019: Level 1
Learn to skillfully manage your data with Microsoft Office Access.
Access 2019: Level 1
Learn to skillfully manage your data with Microsoft Office Access.
What you’ll be able to do — competencies
- Navigate within the Access application environment, create a simple database and customize Access configuration options
- Organize and manage data stored within Access tables
- Use queries to join, sort and filter data from different tables
- Use forms to make it easier to view, access and input data
- Create and format custom reports
Course description
Data is everywhere. Today, most job roles involve some form of data management. Nearly everyone in every line of business is affected in some way by the need to wrangle data. A relational database application such as Microsoft Office Access can help you and your organization stay on top of this task.
This course focuses on the design and construction of an Access database: viewing, navigating, searching and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms and reports.
Note: The Microsoft Office Specialist (MOS) certification test voucher is also available as an option for specific applications.
Prerequisites
- Windows Introduction or equivalent knowledge
Syllabus
Lesson 1: Getting started with Microsoft Office Access 2019
- Launch Access and open a database
- Use tables to store data
- Use queries to combine, find, filter and sort data
- Use forms to view, add and update data
- Use reports to present data
- Get help and configure options in Microsoft Access
Lesson 2: Creating Tables
- Plan an Access database
- Start a new Access database
- Create a new table
- Establish table relationships
Lesson 3: Creating Queries
- Create basic queries
- Perform calculations in a query
- Sort and filter data in a query
Lesson 4: Creating Forms
- Start a new form
- Enhance a form
Lesson 5: Creating Reports
- Start a new report
- Enhance report layout
Next available start dates
Online — Days
Access 2019: Level 1
Total classroom hours
8 hours
Schedule
Online
Days, 1:00 PM - 5:00 PM, 2 T Th - 4/27/2021 - 4/29/2021
Quarter: Spring
Total cost
$299
Instructor: Cliff Hanks
Notes
Online courses require an internet connection and the ability to interact both through audio and video using either a webcam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity are the responsibility of the student.
Interested in custom learning solutions for your team?
Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.
Get started