|
Featured Tutorial
Featured Macro
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.
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.