Excel to Access Intro to Microsoft Access for Excel Users
Isi Folder / Files :
1. Introduction - Course Layout and Objectives
10. Migrating from Excel to Access 2 Design the Correct Structure
11. Migrating from Excel to Access 3 Building the New Tables
12. The FORMS Object 1 - Create a Customer Form and an Orders Subform
13. The FORMS Object 2 - Form Building Shortcuts and More on Subforms
14. The FORMS Object 3 - Moving Between Forms
15. The FORMS Object 4 - Adding Customers and Orders
16. Create an Invoice with One Click!
17. Automate the Opening and Closing of the Database
18. Add Tab Controls to Forms
19. Conclusion and Where to Go From Here
2. Why You Need Access
20. BONUS!
3. The TABLE Object
4. The REPORT Object
5. The QUERY Object - SELECT Queries
6. Reports Revisited
7. Unique Value TOP and Total Queries
8. ACTION Queries
9. Migrating from Excel to Access 1 Get the Data Into Access
Keywords :