Microsoft Access Topics

Access is a Relational Database Management Application

(Stores and Organizes raw data & retrieves information)

Access Basic Course

  1. What is Access?  What is a Database?
  2. What are Related Tables?
  3. Database Concept
  4. Getting Started Screen
  5. Opening a database & Exploring Environment (blank- Template- Existing)
  6. Differences from Excel- Similarities with PowerPoint
  7. Getting Help
  8. How to plan a database?
  9. Explore tables in datasheet & design views
  10. Creating tables in Datasheet view
  11. Creating tables in design View
  12. Changing The Design Of A Table
  13. Effective & Ineffective field names
  14. Deleting, inserting & Moving Fields
  15. Attachment Data Type
  16. Add a Total row.
  17. Finding And Editing Records
  18. Sorting records
  19. Filtering a table
  20. Setting Field Properties
  21. Working With Input Masks
  22. Setting Validation Rules
  23. What is a query?
  24. Create Queries using a Wizard
  25. Creating And Using in Design view
  26. Modifying Query Results And Queries
  27. Performing Operations In Queries
  28. What is a form
  29. Form Views
  30. Creating Forms by using form Button
  31. Creating Forms by using the Wizard
  32. Using Design View to create a form
  33. Sorting And Filtering Records in a form
  34. What is a Report?
  35. Different views of a Report
  36. Change default view
  37. How to create a report by using the wizard
  38. Create a Report in Design view
  39. 7 Sections of a report- Properties
  40. Grouping feature in Reports
  41. Modifying and printing reports

Access Intermediate Course

  1. What is a well-structured table (Normalized)? Table Analyzer
  2. Object Dependency (Condition)
  3. Importance of Table Relationships- Types – How To- Printing Relationships
  4. Enforcing Referential Integrity- Cascading Deletes & Updates.
  5. Database Normalization
  6. How to Relate Tables
  7. Implementing Referential Integrity
  8. What is lookup field? Types
  9. How to add a Multivalued field
  10. How to create a Lookup Field
  11. Modify lookup field properties (Value list Combo box- Edit list column)
  12. Use a Subdatasheet
  13. Create outer join, inner join, and self-join queries
  14. Types of Queries- Unmatched Q- Find Duplicates Q
  15. Create calculated fields in a query – Rule – Expression Builder
  16. View summarized and grouped data from tables by using queries
  17. Joining Fields Using the Expression Builder
  18. Joining Tables In Queries
  19. How to create a Form? Types of controls
  20. Use controls to add graphics
  21. Arranging, Aligning & Formatting Controls
  22. Bind a control to a calculated field
  23. Create a Calculated Control
  24. Add a combo box (= lookup field)
  25. Conditional Formatting in a form
  26. Create advanced form types (Multiple Value- Split-Datasheet-  Subform)
  27. Adding Unbound Controls & Topic B: Adding Graphics
  28. Adding Calculated Values
  29. Adding Combo Boxes
  30. Creating Advanced Form Types
  31. Customize headers and footers in a report
  32. Show report sections.
  33. Set properties for grouping data, and modify the appearance of a report
  34. Add calculated values in a report by using functions
  35. Print database objects and a report of database design
  36. Create labels report
  37. Create and modify a chart in a form
  38. Create and modify a chart in a report

Access Advanced Course

  1. What is Querying with SQL
  2. Writing SQL statement
  3. Adding Field Aliases
  4. Displaying Matching data from related tables
  5. Displaying Unmatched Records
  6. Create SQL Query in SQL view
  7. Context Sensitive Help
  8. Attaching SQL queries to control
  9. Creating Advanced queries
  10. Creating Crosstab queries
  11. The Crosstab query wizard
  12. Create Parameter Queries
  13. Wild Cards in Parameter queries
  14. Using Action Queries
  15. Creating an Append Queries:
  16. Creating a Delete Queries:
  17. Creating an Update query
  18. Creating a Make Table queries
  19. Create and run macros to automate tasks.
  20. What is a Macro?
  21. Modifying macros
  22. Attach macros to events of database objects.
  23. Creating Advanced Macros
  24. Create Data Validation & Data entry Macro
  25. Create Macros that run a parameter query.
  26. Create AutoKeys and AutoExec macros.
  27. Create macros to import and export database objects.
  28. Importing, Exporting & Linking
  29. Importing Objects
  30. Exporting Objects
  31. Working with XML documents
  32. Exporting & Importing XML documents
  33. Exporting with an XSL File
  34. Save an Access Object as an XPS file
  35. Saving a table as an XPS file
  36. Linking Access Objects
  37. Linking to an Access table
  38. Using the Linked Table Manager:
  39. Creating Links to Excel
  40. Linking to an Excel workbook
  41. Using Hyperlinks Fields
  42. Database Management
  43. Optimizing Resources
  44. Converting databases to earlier version
  45. Analyzing database performance
  46. Splitting databases
  47. Compacting & repairing databases:
  48. Backing up the database
  49. Protecting Databases
  50. Setting Options and properties