Developing Database Applications(Intermediate MS Access)


You are here: [Developing Database Applications(Intermediate MS Access) Syllabus]

Printable Version

Developing Database Applications(Intermediate MS Access): Course Syllabus Fall 2018

Currently no courses scheduled for this term.

Class 1

  • 1. Introduction to Application Development
  • 2. Exchanging Data using MS Access (Methods, ODBC)
  • 3. Linking External Data
  • 4. Importing External Data
  • 5. Exporting External Data
  • 6. Linking MS Access Tables( Architecture, Splitting Databases, Linked Table Manager, Multi-User Apps)
  • Lunch Break
  • 7. Advanced Table Design (Table Properties, Validation Rules, Calculated Data Type)
  • 8. Data Macros (Before, After Events, Named Data Macros)

Class 2

  • 9. Multiple Table Queries
  • 10. Join Types (Equi, Outer, Self Joins)
  • 11. Introduction to SQL
  • 12. SQL Queries (Union, Pass-Through, DDL)
  • Lunch Break
  • 13. Advanced Query Design
  • 14. Action Queries(Make-Table, Append, Update, Delete)
  • 15. SQL Sub Queries (Scalar, Row, Table sub queries

Class 3

  • 16. Creating/Customizing Forms (Overview, Form design tools)
  • 17. Form Properties (Format, Data, Events, Other tab)
  • 18. Basic Form Controls (Selecting, Sizing, Moving, Copying, Deleting, Aligning)
  • Lunch Break
  • 19. Advanced Form Controls (Layouts, Anchoring, Bound, Unbound, Calculated)
  • 20. Text Box Control (Creating, Calculated, Properties)
  • 21. Combo/List Box Controls(Overview, Navigational, Lookup, Properties))

Class 4

  • 22. More Form Controls (Option, Check, Image, Command button, Web Browser, Conditional Formatting, Sub Form)
  • Lunch Break
  • 23. Report Basics(Overview, Report/Section Properties)
  • 24. Building Reports(Report design, Sorting/Grouping, Running Sum)
  • 25. Advanced Reports (Report Expression, Sub Reports, Advanced Sample Reports)

Class 5

  • 26. UI Macros (Overview, Creating, Sub macros, Object references)
  • 27. Advanced UI Macros( Conditions, Debugging, Error Handling, Variables, Actions)
  • Lunch break
  • 28. Using UI Macros in Forms and Reports
  • 29. Creating an Application(Customized navigation form, Customized ribbon)
  • 30.Startup Options (Autoexec macro, Startup options)
  • 31. Database Maintenance (Repair/Compact, Backing up, ACCDE database)