Learn to build, edit, and maintain a database in Microsoft Access 2016, complete with tables, reports, forms, macros, and queries to give you fast access to all your important information.
Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records.
Through easy-to-follow, step-by-step instructions, this course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage
Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Access 2016 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Learn to build, edit, and maintain a database in Microsoft Access 2016, complete with tables, reports, forms, macros, and queries to give you fast access to all your important information.
- Getting to Know Access 2016
- Controlling Your Access Table Fields
- Creating Tables and Relationships
- Building Powerful Forms
- Adding Versatility to Forms
- Interviewing Your Database
- Taking Queries to the Next Level
- Multi-Table Query Control
- Reporting on Your Tables
- Creating Query-Based Reports
- Mastering Report Design
- Automating Your Database With Macros
Self-Study
