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.
Duration: 3 Months
- Details
- Learn to build and customize tables to store data
- Learn how you can use relational databases to build forms, generate reports, and search for data with queries across thousands of records in hundreds of tables
- Discover how to use macros to automate repetitive tasks and increase your efficiency
- Develop not only strong Access skills, but a solid understanding of good database design concepts
- Course Outline
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 - Requirements
Prerequisites:
There are no prerequisites to take this course.
Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows XP or later.
- Mac: OS X Snow Leopard 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 Flash Player. Click here to download the Flash Player.
- Adobe Acrobat Reader. Click here to download the Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Course Fee: USD 120Now available at Afghanistan, Bangladesh, Bhutan, India, Maldives, Nepal, Pakstan and Sri Lanka