All about Queries

After last weeks mamoth effort on creating usable Access Forms, this week we're going to 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!

But before we get stuck into that, take a look at some screenshots of the new Office 2007 lineup! What's different? You'll see examples of the new Word, Excel, Outlook and Access.

If we have some time left over, we're going to see how we can record and modify VBA macros in MS Word just like we did in Excel, with a short activity!