Course curriculum

  1. 1

    • Google Subtitles Instructions

    • MS Access List of Topics

    • Adventure Works

    • Country

    • Credit Card

    • Product

    • SQL Attach Function
  2. 2

    • 1. Creating and Saving a Table in Design Mode

    • 2. The Primary Key

    • 3. Important Field Properties
  3. 3

    • 4. The Select Query

    • 5. Filtering and Sorting Records using Numeric and Date Fields

    • 6. Filtering and Sorting Records using Text Fields and Wildcards

    • 7. Adding a Calculated Field to a Query
  4. 4

    • 8. Queries that Change Data

    • 9. Adding Pop Up Parameters to Queries
  5. 5

    • 10. Two Reasons for a Relational Database

    • 11. Creating Links Between Tables

    • 12. Multiple Table Queries
  6. 6

    • 13. Creating a Form Using the Wizard

    • 14. Creating and Editing a Form WITHOUT the Wizard

    • 15. The Clever ComboBox Record Finder
  7. 7

    • 16. Forms Within Forms in a Relational Database

    • 17. SubForms Based on Query Data
  8. 8

    • 18. Use of the SplitForm Feature
  9. 9

    • 19. Create a Report with the Wizard

    • 20. Create a Report from Scratch and add Special Fields

    • 21.Grouping with Reports
  10. 10

    • 22. Export Data into Excel

    • 23. Export a Report to Word or PDF
  11. 11

    • 24. Import from Excel

    • 25. Use of Paste Append

    • 26. Import an Access Table from another Database

    • 27. Create a Mail Merge in Word using Data from Access

    • 28. Mail Merging in Word using Data from Excel
  12. 12

    • 29. Introduction to Access Macros

    • 30. Introduction to Events in Access using VBA

    • 31. Create a Form with Buttons to open/close other objects

    • 32. Refresh the data in one combo box when another combo box is changed

    • 33. Decide on a course of action based on user input

    • 34. Using VBA to connect Access to a SQL Server backend database

    • 35. The special AUTOEXEC macro