In this practical and project-oriented course, you will learn to build and customize tables to store data. This course explores relational databases and how to use them to build forms, generate reports, and search for data with queries across thousands of records in hundreds of tables. You will also discover how to use macros to automate repetitive tasks and increase your efficiency.
Through easy-to-follow, step-by-step instructions, this course will help you master Access 2013 and put it to creative, confident use. You will develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you finish the course, you will 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 2013
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. It is not suitable for Mac users.
Software Requirements:
- Windows XP or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Access 2013 (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