Microsoft Office Access 2016: Part 1 (Beginner)
What you'll learn
- Navigate within the Microsoft 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.
Requirements
- Just basic computer skills.
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.
You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
Who this course is for:
- This course is designed for you, if you 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.
Course content
- Preview03:04
- 04:28Orientation to Access
- Preview02:20
- 03:56Navigate Tables
- 02:05Navigate and Edit Data in Forms
- 03:42Relational Databases
- 01:32Use Queries - Introduction
- 01:50Use Queries
- 02:28Use Reports
- 06:56Create a New Database
- 05:12Get Help
- 06:03Configure Options in Access
- 3 questionsMicrosoft Access 2016 Part 1 Quiz 1
Instructor
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.