Access 365 Foundations Everything you need to create a DB

Learn database foundation skills that can be used in learning Mongo, Oracle or even SQL Cloud
Access 365 Foundations Everything you need to create a DB
File Size :
3.14 GB
Total length :
5h 51m


Robin Solonenko


Last update




Access 365 Foundations Everything you need to create a DB

What you’ll learn

You will learn what Relational Databases are and how to build one from scratch.
Learn to create tables with various properties and controls.
Understand how to create relationships between all those tables.
Learn to create queries to questions those tables and return data sets.
Learn to create forms for your users to collect all your data.
Create reports based on those queries or tables and generate PDFs.

Access 365 Foundations Everything you need to create a DB


No Database knowledge is required for this course.
Having strong Excel skills in functions will greatly enhance your learning experience.
You must have MS Access installed on your system – subscription to O365 will be necessary.


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 InstructorRobin Solonenko


Section 1: Getting Started

Lecture 1 Coruse & Instructor Introductions

Lecture 2 Support Notes for Students

Lecture 3 Courses Resource Files & PDF Manual

Lecture 4 Contacting the Instructor

Lecture 5 Let’s Set Some Expectations

Lecture 6 PDF Manual & Video Correlation

Section 2: Introduction to Databases

Lecture 7 What is a Database?

Lecture 8 Database Objects

Lecture 9 Access Environment

Lecture 10 Basic Actions

Lecture 11 Working in Datasheet View

Lecture 12 Design View of Any Object

Lecture 13 Section 2 / Lession 1 Exercise

Section 3: Creating Access Tables

Lecture 14 Creating a Database

Lecture 15 Creating Tables & Assigning Data Types

Lecture 16 Setting Primary Key

Lecture 17 Setting Field Properties

Lecture 18 Copying / Pasting Existing Tables

Lecture 19 Section 3 / Lession 2 Exercise

Section 4: Data Normalization & Relationships

Lecture 20 What is Data Normailization

Lecture 21 Setting Table Relationships

Lecture 22 Foreign Keys & Integrity Rules

Lecture 23 Creating Relationships

Lecture 24 Section 4 / Lesson 3 Exercise

Section 5: Creating Forms to Collect Data

Lecture 25 The Basics of Forms

Lecture 26 Creating Forms w/Form Wizard

Lecture 27 Working with Controls

Lecture 28 Working with Property Sheet

Lecture 29 Modifying Form Layout

Lecture 30 Creating a Calculated Control

Lecture 31 Setting the Form Tab Order

Lecture 32 Creating a Split Form

Lecture 33 Instructions to Create the Next Forms

Lecture 34 Creating the Cars Form

Lecture 35 Creating the Tickets Form

Lecture 36 Creating the Mechanics Form

Lecture 37 Creating the Service Orders Form

Lecture 38 Section 5 / Lesson 4 Exercise

Section 6: Selecting Data with Queries

Lecture 39 Select Queries

Lecture 40 Creating a Query

Lecture 41 Creating a Multi-Table Query

Lecture 42 Adding Criteria to a Query

Lecture 43 Performing Calculations in Queries

Lecture 44 Creating a Parameter Query

Lecture 45 Adding Totals to Datasheets

Lecture 46 Section 6 / Lesson 5 Exercise

Section 7: Presenting Data with Reports

Lecture 47 Using the Report Wizard

Lecture 48 Using Controls & Report Views

Lecture 49 Report Sorting & Grouping Levels

Lecture 50 Adding Page Breaks & PDF

Lecture 51 Section 7 / Lesson 6 Exercise

Section 8: Next Steps

Lecture 52 Instructor Thankyou

Lecture 53 Access Foundations Project

Anyone who needs to create a database to hold all your data for your business.,Anyone who has outgrown using Excel to hold and collect your data.,Anyone who wants a better understanding of Relational Databases

Course Information:

Udemy | English | 5h 51m | 3.14 GB
Created by: Robin Solonenko

You Can See More Courses in the Office Productivity >> Greetings from

New Courses

Scroll to Top