This innovative series of classes works with attendees to help them build and understand how databases work. Beginning with the first class, attendees will be taught how to design and build a custom learning management system from the ground up. Each class will build on the work of previous classes, and introduce concepts of database theory and user experience design (UX). Though not a requirement, it is suggested that everyone attend the classes in the order offered.
Microsoft Access: Data and Tables (Level 1)
Get started with Access by learning the fundamentals of database features. This class will explore how to use Access efficiently and introduce the concepts of good Relational Database design. It’s a maxim that all data is stored in Tables in Access, but not all Tables are equal. You will learn the elements of the user interface, and dig into the Table Object. You will use the Datasheet and the Design views, and gain a strong understanding of how data is linked together.
Microsoft Access: Queries (Level 2)
Understanding Queries in Access begins with learning how to ask simple questions about your data, like “how many?” and “which ones?” As you explore topics like relationships and referential integrity, however, you’ll learn how to select, update and delete records using queries. This class will also introduce you to the concept of joins and crosstab queries. As your experience grows during the class, more advanced features like the Query Wizard and Expression Builder will be introduced.
Microsoft Access: Forms (Level 3)
Access uses a special object type called Forms to represent data visually on screen. Forms are a great method to add exciting front-end user functionality to boring databases, and offer ways to protect your data from well-intentioned mistakes. Starting with simple forms and the Forms Wizard, you will quickly move to more complex forms that include sub-forms. Good form design will rocket your database into the next level of professional recognition and usability.
Microsoft Access: Reports (Level 4)
Reports give you the ability to aggregate the data you are interested in and print it out in creative and professional looking documents. You will start with form letters, but quickly move to adding charts and graphs based on your data. You will also learn the tips and tricks to make large sets of data play nicely with any printer you choose.
Microsoft Access: Modules and Macros (Level 5)
Every good database designer needs a tool belt with lots of tricks, and Macros are the 5-star tool you need to automate repetitive tasks. (And let’s face it, databases are full of repetitive tasks!) You will be introduced to writing Macros using the Visual Basic Editor, and learn how to trigger Macros in forms by events like button clicks. You’ll also learn how to use Temporary variables and constants, as well as how to work securely with this powerful tool. The class will finish up with a topic on Database Administration, where you will learn how to make backups and split your database into a front-end and a back-end system.