For more experienced users of MS Access, this pack demonstrates the different types of queries that can be used to interrogate data within an MS Access database. Students are taken through select, action, delete, update, append, make-table, unmatched, crosstab and find duplicate queries. As students work through the pack they will learn when to use each type of query, as well as learning how to create, run, save and edit queries by working through 32 practical exercises (with suggested solutions provided). They will also learn how to perform calculations in a query.
NOTE: This pack is a re-write of Packs 14/228 and 03/29 to reflect the significant differences between Office 2013 and previous versions.
Order online and download your product immediately
New customers are subject to verification