Excel Forum
Similar Content
Introduction to Using Filters to Refine Data in Excel
Tutorial: Filtering allows you to hide rows of data which you are not interested in so that you can ...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
How to Find and Understand Excel Functions
Tutorial: In this tutorial I am going to show you how to find and understand new Excel Functions. If...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Office 2010 Class #41: Introduction to Databases and Access


Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
This video goes with the Highline Community College Busn 216 Computer Applications Class Access 2010.
Topics Covered In Video:
1. Basics of a what a database is
2. Basics of Access and how it is different from Excel
3. Look at the Access objects Tables, Forms, Queries and Reports
4. Learn about the two views in a database: "Top view" and Design View
5. Delete, add and change records and see that records using a form and then see that the Table, Queries and Reports all update
6. Use navigation buttons to find records
7. Use Ctrl + F to find records
8. See that Save and Undo are different in Access and Open are different than in Excel and Word
9. Records are automatically saved, but objects are not
10. Undo works in a single record, but not across multiple records, and undo works when creating objects
11. To open two databases, use Windows Explorer.





Got a Question? Ask it Here in the Forum.