Microsoft Access Level I
Most of us work with data every day. It is part of our daily lives in the workplace and our personal lives. We are awash in data including prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics. And, because data is everywhere, most jobs today involve some form of data management. A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data.
Learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
This class is taught in Microsoft Office 2013. The UWM-SCE computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.
Hannah Goodman builds custom database applications. She earned her master’s degree in computer science from UWM in 1986. Hannah worked for the Medical College of Wisconsin as a systems analyst, designing databases, writing custom programs and performing statistical analysis. In ... read more
Course Content Microsoft Access Level I
Lesson 1: Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database
Get Help in Microsoft Access
Lesson 2: Working with Table Data
Modify Table Data
Sort and Filter Records
Lesson 3: Querying a Database
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query
Lesson 4: Creating Advanced Queries
Create Parameter Queries
Create Action Queries
Create Unmatched and Duplicate Queries
Lesson 5: Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Lesson 6: Customizing the Access Environment
The Access Options Dialog Box
Experience using Windows
Public courses on Microsoft Excel and Access are taught in Office 2013. If you are using Office 2010 – the functions and features you will learn are similar to 2013 and can be applied in the 2010 environment. If you would like group training on any MS Office 2010 programs, please contact Pam Nellen at email@example.com or 414-227-3208
"Hannah is an excellent instructor. She encouraged questions and really took the time to answer them thoroughly. I came to class with almost no knowledge of databases and am leaving with a foundational understanding of their components and how they work. Thank you!" — Student, 2015
"Fantastic overview of Access. The instructor is very knowledgeable and provided some wisdom from her experience. Gave very good insight and advice." — Student, 2015
All sessions are Face-to-Face unless otherwise noted.