Access 365 Foundations: Everything you need to create a DB.

If you are a small organization or self employed and need to move beyond using Excel to hold your data, then you need MS Access 365. Access 365 is a desktop relational database that has been around for 30 years and does the job needed to hold your data. But in fact, it does more than just hold your data - you can execute complex queries to run your reports and get the data analysis you need on your organization.

But it all starts with a good foundation and learning from the beginning on how to create a rock-solid database with proper relationships and referential integrity, so your tables hold correct data and not create windows and orphans.

Microsoft Access 365 is a desktop database application that provides the ability to store large amounts of data and the objects within the database – Queries, Forms, Reports, and Code Modules enable the user to add or extract data easily and present the data in different formats.

The term Relational Database refers to the idea that the data collected in the various tables are related to each other in one fashion or another. The database could hold information about customers and each of the table would have information about those customers like their personal info, all the transactions they have generated and all the products they purchased.

Students will learn to create an entire database with Tables, Forms, Queries and Reports and build a foundation of knowledge of how databases of any kind work. Knowledge of Excel functions and the ability to problem solve will be required assets for this course. Students must also have MS Access 365 version installed on their local computer.

Your Instructor
Robin Solonenko