MS Access - create your first database

Posted on 24 Sep 08:49 | by mitsumi | 14 views
MS Access - create your first  database

Published 09/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 40 lectures (1h 36m) | Size: 1 GB


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
Requirements
MS Access (2016/2019/2021/365)
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

Download link

rapidgator.net:


uploadgig.com:


banned-scamhost.com:

1dl.net:

Related News

Noob to Ninja (SQL Server) - Beginner (1 of 2) Noob to Ninja (SQL Server) - Beginner (1 of 2)
Noob to Ninja (SQL Server) - Beginner (1 of 2) Published 10/2022 MP4 | Video: h264, 1280x720 |...
SQL/Oracle Database Administrator : Migration,Security,Query SQL/Oracle Database Administrator : Migration,Security,Query
SQL/Oracle Database Administrator : Migration,Security,Query MP4 | Video: h264, 1280x720 | Audio:...
MySQL from basic to advance : Level Up Masterclass 2022 MySQL from basic to advance : Level Up Masterclass 2022
MySQL from basic to advance : Level Up Masterclass 2022 Genre: eLearning | MP4 | Video: h264,...
Data Migration Engineer: MSSQL | Oracle | MySQL | MS Access Data Migration Engineer: MSSQL | Oracle | MySQL | MS Access
Published 06/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning |...

System Comment

Information

Error Users of Visitor are not allowed to comment this publication.

Facebook Comment

Member Area
Top News