MS Access - create your first database

Focused View

Paulina Klama

1:35:56

169 View

1. DOWNLOADS

1.1 Exercises__MS_Access_create-your-first-database.pdf

1.2 Joins__MS_Access-create-your-first-database.pdf

1.3 Presentation__MS_Access-create-your-first-database.pdf

1. Materials.html

2.1 Customers.xlsx

2.2 Products.xlsx

2.3 SalesHistory.xlsx

2.4 SalesHistory2.xlsx

2. Excel files.html

2. PREFACE

1. Welcome.mp4

00:32

3. INTRODUCTION TO DATABASE DESIGN

1. INTRO.mp4

00:47

2. Basic definitions.mp4

01:11

3. Data Models.mp4

02:57

4. Data types.mp4

00:44

5. Relational database, primary and foreign keys.mp4

02:57

6. Relationship types.mp4

01:46

7. Relationship (one to many) - visualized example.mp4

01:33

8. Data normalization.mp4

01:06

9. First Normal Form (1NF).mp4

00:44

10. Second Normal Form (2NF).mp4

01:53

11. Third Normal Form (3NF).mp4

01:48

12. SQL language - introduction.mp4

03:27

13. The order of writing and executing commands.mp4

00:50

14. Objects of MS Access database (1).mp4

01:14

15. Objects of MS Access database (2).mp4

01:09

16. Differences between MS Access and MS Excel.mp4

00:55

4. THEORY TEST

1. Knowledge test - theory.html

5. CREATING TABLES

1. INTRO.mp4

00:20

2. CREATE A TABLE CONTAINING PRODUCT DATA (1.1.).mp4

07:46

3. INSERT DATA INTO A TABLE WITH PRODUCTS (1.2.).mp4

04:20

4. CREATE A TABLE WITH SALES HISTORY (1.3.).mp4

06:39

5. IMPORT DATA TO THE SALES HISTORY TABLE (1.4.).mp4

04:52

6. CREATING QUERIES

1. INTRO.mp4

00:15

2. CREATE A QUERY WITH SALES HISTORY (2.1.).mp4

03:19

3. ADD COLUMN WITH SALES VALUE (NET) TO CREATED QUERY (2.2.).mp4

06:13

4. CREATE A QUERY WITH PRODUCT SALES SUMMARY (2.3.).mp4

03:45

5. CREATE A QUERY WITH SUMMARY SALES OF CALCULATORS (2.4.).mp4

01:48

7. CREATING FORMS

1. INTRO.mp4

00:15

2. CREATE A FORM TO ADDING AND EDITING PRODUCT DATA (3.1.).mp4

05:59

3. CREATE A FORM TO ADDING AND EDITING SALES HISTORY DATA (3.2.).mp4

02:58

4. CREATE A REPORTING FORM INCLUDING EXPORT BUTTONS (3.3.).mp4

09:14

8. CREATING REPORTS AND DATA EXPORT

1. INTRO.mp4

00:10

2. CREATE A REPORT BASED ON A QUERY WITH SALES HISTORY DETAILS (4.1.).mp4

04:36

3. ADD THE OPTION TO OPEN QUERY WITH SALES SUMMARY AND EXPORT DATA (4.2.).mp4

01:57

4. ADD THE OPTION TO EXPORT QUERY WITH SALES OF CALCULATORS AND EXPORT DATA (4.3.).mp4

01:17

5. PASSWORD.html

9. PRACTICE TEST

1. Knowledge test - practice.html

10. ADDITIONAL INFO (FRONT-END - BACK-END)

1.1 links.zip

1. Split database (optional).mp4

04:30

11. END

1. Thanks.mp4

00:10

Description

Learn Database Design with MS Access

What You'll Learn?

Understanding database basic definitions
Understanding database normalization process (1NF, 2NF, 3NF)
Understanding SQL language - basics
Creating Tables
Creating Queries
Creating Forms
Creating Reports

Who is this for?

Data Analysts

Novice Data Scientists

Reporting Specialists

Novice SQL Developers

Beginners in MS Access

Computer Science Students

What You Need to Know?

MS Access (2016/2019/2021 or 365)

More details

Description
The course "MS Access - create your first database" is designed for people who are beginning their work with databases, such as Computer Science students or novice SQL Developers and Data Scientists.
It can also be a great compendium for Data Analysts and Reporting Specialists who want to understand the structure of databases and create reports based on them.

The training includes both lectures with discussion of the necessary theory and lectures with implementation of practical exercises.

The course comes with materials such as:
1. Presentation with theory and screenshots of MS Access options with description
2. A list of exercises, which includes the content of all the exercises discussed + tips + some exercises for self-implementation
3. Extra presentation with examples describing the types of JOINS in SQL queries

My course also includes two multiple-choice tests, one on theory and one on practice, so you can check the level of knowledge you have acquired.

You will learn such things as:

* THEORY: Basics of database design:
>>> Basic definitions
>>> Data models
>>> Relationship types
>>> Database normalization (1NF, 2NF, 3NF)
>>> SQL language basics
>>> Objects of MS Access
>>> Main differences between MSÂ Excel and MS Access

* PRACTICE: MS Access database creation:
>>> Creating tables and relationships
>>> Creating queries
>>> Creating forms
>>> Creating reports
>>> Importing and exporting data

... and you will learn some other interesting facts :)

See you on my course!
Who this course is for:
Data Analysts
Novice Data Scientists
Reporting Specialists
Novice SQL Developers
Beginners in MS Access
Computer Science Students

User Reviews

Rating

average 0

Total votes0

Focused display

Hi!My name is Paulina and I'm here to share the knowledge I gain from my daily work.I have about 7 years of experience working with data analysis.By education I am a Computer Scientist and a Master of Management.I have practical knowledge of: MS Excel, Visual Basic (VBA), Power Query, MS Access, Oracle SQL Developer, SQL Server Management Studio, IBM Cognos, Power BI.I conduct my courses in a very simple and accessible language, so that anyone can get a lot of knowledge from them and use it in practice.I invite you to learn and expand your horizons! :)

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.