On this Microsoft Access 2013 intermediate course (USA Standards), provided by Global Edulink, a well-respected provider of online training courses globally, you are skilfully guided through the use of the software by qualified trainers who are specialists in their field. We make it easy for you to understand the intermediate aspects of this application, such as: relational database design, joining tables and querying their joints, efficient organisation of databases, import and export of data to and from Access, useful mail merges, and finally, its advanced reporting tools.
Microsoft Access 2013 is the number one database application in the world and is designed to make databases easier to create and use. It’s used to store a set of information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data.
Many businesses use Microsoft Access, from small one-person outfits to the largest corporations world-wide, because it’s easy to maintain and requires very little infrastructure to support. Understanding Access is vital to real-world database use and, at Global Edulink, our course will furnish you with skills that we believe can certainly progress your career.
Please Note: This Course is Based on USA Standards.
1. Relational Database | |||
Relational Database Design | 00:12:00 | ||
Create a Table – Access | 00:05:00 | ||
Create Table Relationships | 00:09:00 | ||
2. Joining Tables | |||
Create Query Joins | 00:10:00 | ||
Join Tables That Have No Common Fields | 00:03:00 | ||
Relate Data within a Table | 00:05:00 | ||
Work with Subdatasheets | 00:04:00 | ||
Create Subqueries | 00:05:00 | ||
3. Organizing a Database for Efficiency | |||
Data Normalization | 00:13:00 | ||
Create a Junction Table | 00:06:00 | ||
Improve Table Structure | 00:03:00 | ||
4. Import and Export the Data | |||
Import Data into Access | 00:11:00 | ||
Export Data to Text File Formats | 00:06:00 | ||
Export Access Data to Excel | 00:03:00 | ||
5. Mail Merge | |||
Create a Mail Merge | 00:10:00 | ||
6. Advanced Reporting | |||
Organize Report Information | 00:18:00 | ||
Format Reports | 00:17:00 | ||
Control Formatting in a Report | 00:03:00 | ||
Add a Calculated Field to a Report | 00:05:00 | ||
Subreport to an Existing Report | 00:03:00 | ||
Mock Exam | |||
Mock Exam: Microsoft Access 2013 – Intermediate | 00:20:00 | ||
Final Exam | |||
Exam : Microsoft Access 2013 – Intermediate | 00:35:00 | ||
Certificate Download Guide | |||
Certificate Download Guide | 00:03:00 |
Andilina adole
Very well designed, throughout course with attention to detail. If you used excel before, as you’ll be familiar with the usage of access. Worth the money, give confidence in using access.