Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Introduction to Databases & Access

ExcelIsFun via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course provides an introduction to databases and Access, focusing on the basics of databases, Access features, and the differences between Excel and Access. Students will learn about Access objects such as Tables, Forms, Queries, and Reports, as well as how to change records and understand the concepts of saving and undoing actions. The course also covers the choice between Excel and Access for data analysis, and introduces the two views in a database: "Top view" and Design View. The teaching method includes video lectures and practical demonstrations. This course is intended for individuals interested in learning about databases, Access, and data analysis.

Syllabus

) Introduction.
) Basics of a Database.
) Basics of Access and how it is different from Excel.
) Look at the Access objects Tables, Forms, Queries and Reports.
) Change records and see that records using a form and then see that the Table, Queries and Reports all update .
) How Save is different: Records are automatically saved, but objects are not.
) How Undo is different: Undo works in a single record, but not across multiple records, and undo works when creating objects.
) Excel or Access for Data Analysis?.
) Learn about the two views in a database: “Top view” and Design View.

Taught by

ExcelIsFun

Reviews

Start your review of Introduction to Databases & Access

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.