Microsoft Access Masterclass
Learn how to use the different features built into the powerful Microsoft Access software in order to create and expertly manage databases.
Databases are an important part of the information landscape and this free online Microsoft Access tutorial will show you how to proficiently leverage data with the use of Microsoft Access. You will learn how to design and build tables, forms, reports, controls and queries that work efficiently, access macros and program control structures in Visual Basic for Applications (VBA) as well as fix Excel data import errors.
What You Will Learn In This Free Course
Working With Tables
In this module, you will learn how to navigate existing tables, edit records, sort data, filter records and use the find and replace features in Access. You will be taught the fundamentals of creating new tables and how to set field properties and what look-ups are used for. On top of this, you will learn how to define, create and manage controls, reports and queries.
Database Design
In this module, you will learn how to create and manage forms. You will be taught how to explain Access to experts that are used to working with spreadsheets and codes. You will learn the rules of normalization, how to use primary keys, referential integrity and how the different types of relationships in databases are managed in Microsoft Access.
Advanced Features
In this module, you will learn how to import excel into Access using the GUI as well as how to organize and structure data after importation. You will be shown how control structures are used for selection and looping, how macros, a simplified programming language are created and how to import Excel into Access using VBA which is also a program.
Course assessment
User Reviews
Be the first to review “Microsoft Access Masterclass”
You must be logged in to post a review.
There are no reviews yet.