Microsoft Access: Queries (1 Day)

Product Description

This course focuses on the role of the database designer in the

Specification & creation of queries & will cover Access queries in detail. Covering both the theory & practicalities of query design this course takes the delegates through the various queries available in Access. It will explain the theory & practical elements of select, multi-table & action queries, ensuring a comprehensive understanding of this particular type of Access object.

Having designed & created perfect tables to ensure that data has been entered consistently, a logical progression is to create Queries to select & manipulate the data. Users typically either struggle or rely on technical IT users to create queries for data analysis. Being able to create ad-hoc statistics or simple selection criteria for others; & understanding how to query any database is an advantageous skill set. Time is provided for delegates to carry out practical exercises to reinforce their knowledge.

• Focused course on Queries
• Understand the theory behind queries
• Create technical specification/requirement documents for developers
• Convert specification/requirement documents into real solutions
• Transferable skills to other database applications
• Start to build knowledge of SQL
• Be able to link tables in a query
• Create simple & complex criteria
• Perform statistical analysis on the data
• Practical examples of good & bad queries

This training may be available onsite; please contact us if you are interested.