This course is the follow-on course from the Introduction to Microsoft Access. The course covers how to put a database together and interrogate the data through queries, forms, and reports. The course explains how to carry out a detailed analysis of the data set used. At the end of the course, you should be able to create a relational database with a macro-driven front end including command buttons set to navigate and manage your database.

What will you learn in this course?

• Update queries
• Append queries
• Make table queries
• Delete queries
• Calculations in queries
• Sub Totals in queries
• Parameter queries
• Form calculations
• Form tab controls
• Form option groups
• Form images
• Forms and subforms
• Report calculations
• Report concatenation
• Basic functions, IIF, Average, Sum, Count, Max
• Basic command buttons
• Macros, Autoexec, Auto keys, IF, send to and more
• Navigation options
• Event properties, macro attached to properties
• Splitting a database and properties