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

Focused View

Robin Solonenko

5:48:19

101 View

1. Getting Started

1. Coruse & Instructor Introductions.mp4

01:12

2. Support Notes for Students.html

3.1 Access 365 Foundations Data Files.zip

3. Courses Resource Files & PDF Manual.html

4. Contacting the Instructor.mp4

00:52

5. Lets Set Some Expectations.mp4

03:48

6. PDF Manual & Video Correlation.html

2. Introduction to Databases

1. What is a Database.mp4

02:07

2. Database Objects.mp4

05:46

3. Access Environment.mp4

06:43

4. Basic Actions.mp4

06:21

5. Working in Datasheet View.mp4

07:53

6. Design View of Any Object.mp4

05:33

7. Section 2 Lession 1 Exercise.mp4

00:52

3. Creating Access Tables

1. Creating a Database.mp4

02:55

2. Creating Tables & Assigning Data Types.mp4

15:15

3. Setting Primary Key.mp4

04:22

4. Setting Field Properties.mp4

10:43

5. Copying Pasting Existing Tables.mp4

09:33

6. Section 3 Lession 2 Exercise.mp4

00:53

4. Data Normalization & Relationships

1. What is Data Normailization.mp4

03:21

2. Setting Table Relationships.mp4

03:36

3. Foreign Keys & Integrity Rules.mp4

06:47

4. Creating Relationships.mp4

08:19

5. Section 4 Lesson 3 Exercise.mp4

00:57

5. Creating Forms to Collect Data

1. The Basics of Forms.mp4

04:27

2. Creating Forms wForm Wizard.mp4

03:30

3. Working with Controls.mp4

19:42

4. Working with Property Sheet.mp4

08:48

5. Modifying Form Layout.mp4

08:13

6. Creating a Calculated Control.mp4

16:34

7. Setting the Form Tab Order.mp4

04:07

8. Creating a Split Form.mp4

02:32

9. Instructions to Create the Next Forms.mp4

02:31

10. Creating the Cars Form.mp4

10:27

11. Creating the Tickets Form.mp4

11:27

12. Creating the Mechanics Form.mp4

06:00

13. Creating the Service Orders Form.mp4

07:40

14. Section 5 Lesson 4 Exercise.mp4

00:58

6. Selecting Data with Queries

1. Select Queries.mp4

03:33

2. Creating a Query.mp4

21:03

3. Creating a Multi-Table Query.mp4

10:46

4. Adding Criteria to a Query.mp4

14:12

5. Performing Calculations in Queries.mp4

05:54

6. Creating a Parameter Query.mp4

15:02

7. Adding Totals to Datasheets.mp4

12:24

8. Section 6 Lesson 5 Exercise.mp4

00:55

7. Presenting Data with Reports

1. Using the Report Wizard.mp4

09:22

2. Using Controls & Report Views.mp4

20:42

3. Report Sorting & Grouping Levels.mp4

11:19

4. Adding Page Breaks & PDF.mp4

05:21

5. Section 7 Lesson 6 Exercise.mp4

00:31

8. Next Steps

1. Instructor Thankyou.mp4

00:42

2. Access Foundations Project.mp4

01:49

Description

Learn database foundation skills that can be used in learning Mongo, Oracle or even SQL Cloud

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.

Who is this for?

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

More details

Description
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
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Having over 25 years of Microsoft training under my belt, I am well versed in Microsoft products and have delivered and developed Microsoft courses for corporate giant Suncor Energy and currently technical education institutes across western Canada. I am also well versed in MS Power BI, DAX, PowerApps, Power Automate and SharePoint Administration.I have created and released NAIT's first Power Platform certificate program being released in November 2022. I bring extensive knowledge of end user Microsoft applications and their integration to our every day office lives. I love to empower my students and help them take their knowledge to the next level in any course to make them feel confident in the workplace.I have been instructing Microsoft products since 1997 and have developed course content since 2013 by writing manuals for all the courses I instruct today. From the Power line of products (Power BI, PowerApps, Power Automate) to SharePoint Online to Access Databases I can teach you and your employees in any environment.From classroom instruction to virtual training to course video content, I offer you hands on training and skills development for all levels of these products and because I write my own content (manuals) for these products I can maintain their accuracy and keep them current with all the changes that Microsoft pushes out.I am glad to be a part of your educational journey and I hope my course(s) give you the confidence you need to use the products at your employment to your fullest potential.Thank you once again and I will see you on the other side.Robin Solonenko

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.