Introduction to Databases & Access

Explore the fundamentals of databases and Microsoft Access in this 31-minute video tutorial from the Highline College Business 216 Computer Applications course. Learn the basics of database management, understand how Access differs from Excel, and discover key Access objects like tables, forms, queries, and reports. Gain insights into record management, saving procedures, and undo functionality specific to Access. Compare Excel and Access for data analysis tasks, and familiarize yourself with the two main database views: "Top view" and Design View. Download accompanying files to practice alongside the instructor and enhance your understanding of database concepts and Access functionality.

) 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.