All about Access Queries

After some warmup fun with VBA macros, we're going to start our day by seeing how all the VBA Macro stuff we've learned in Excel works exactly the same in MS Word! (We'll be recording and editing macros in Word in no time)

After a brief break, we'll get a chance to work in pairs or small groups to have a go at creating the Student Enrollment database that we began designing last week. Our aim is to create the necessary tables, link them together with relationships so that we can enrol students into courses! We'll get together to discuss the pro's and con's of our implementations.

Finally, we'll tackle some of the more advanced Queries in Access. Specifically, we'll:

• Create queries based on multiple tables
• See how we can use calculated fields in a query
• Use special aggregate functions in a query (like summing or averaging the results of our query)
• Create action queries (to delete or modify our data!)
• Create parameter queries that ask us a question before running the query!

Any time left over will be for working on our second assignments! (Our Excel applications) See you then!