In this practical and project-oriented course, you will learn how to use this award-winning MS Office software to create and customize tables. You will build relationships between your tables to eliminate redundancies and slash data entry time.
In addition, you will find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You will learn how to retrieve exactly what you need from your database with powerful queries and reports, and you will even start automating routine tasks with labor-saving macros.
By the time you finish this course, you will know how to create an effective database for any information you need to store, document, and manage—at home or on the job.
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 2010
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 can be taken on either a PC or Mac.
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 and Safari are also compatible.
- Microsoft Access 2010 (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