Microsoft Access Course

Microsoft Access Course

Categories: Data Analysis & BI
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Access has been around for over two decades, and it’s not going anywhere due to its ability to be ‘up and running very quickly! Sure, big companies like extensive databases that serve the company’s need on an enterprise level, but the value of Access is about what can be done at a local level, in small teams, and on smaller or temporary projects.

For example, if you are working in a small company and you want to be able to manage your data, whether that be some kind of sales data, expenses, marketing information, or project focus data and you need to get up and running quickly with a database to handle it, well Microsoft Access training course is definitely the thing for you. You can be up and running in an afternoon with no need to get IT permissions or ask for a big budget! That’s why you need to learn Microsoft Access, which is known as a self-serving or end-user tool.

Given that how to use Access now shows that we have built a Microsoft Access tutorial with exactly that in mind to teach you how to use Access for it to be a great end-user tool that you can get up and run quickly but also gives your Database more advanced capability if you wish to.

In order to build the right Microsoft Access course for you, we worked with Guy Vaccaro, who has been building Databases, including Access Databases, for over two decades. Rather than build an unnecessarily long training, Guy has condensed his two decades of mastery in less than 6.5 much focused hours, not learning unnecessary functionality so you can get up, run and maintain your Database in a very quick time frame!

Show More

What Will You Learn?

  • Creating Tables
  • Creating Queries
  • Action Queries
  • Linking Tables
  • Creating Forms, Sub-Forms & Split-Forms
  • Creating Reports
  • Importing & Exporting Data
  • Building VBA/Macros to automate your databases

Course Content

Creating Tables

  • Creating and saving a table in design mode in Access, including best practice with regard to naming conventions for Access objects and fields within tables and the correct choice of data type.
  • The Primary Key: the why and the How
  • Some important field properties: Default values, masks, caption, Required and validation rules

Creating Queries

Action Queries

Linking Tables

Creating Forms

Creating SubForms

Creating SplitForms

Creating Reports

Exporting Data

Importing Data

Building VBA/Macros

Your Instructor