![[The University of Leicester]](unilogo.gif)
Querying Access Databases
| Information |
Course description |
|---|---|
|
Course Overview
|
It is good to know more about what you can do once data is input. The quick analysis is really useful"
Having created a database you will want to retrieve your data using a variety of querying techniques. This course will begin with the basics of creating a simple query and take you through the steps needed to refine your queries with different criteria and querying across multiple tables. |
|
Date(s) |
Monday 18 June 2012 (1.30pm - 5.00pm) |
| What can I expect to cover? |
You will learn how to create and amend queries which extract data from one or several tables. You will add criteria to query between dates and numeric ranges or search for more than one text criteria. You will create queries which prompt you to enter criteria. You will learn how to sort the results and how to use queries to calculate on fields or create new fields and tables. |
| What will I get out of this course? |
The most useful aspects of the session were Querying Techniques and Parameter Queries. I can already see areas in which I will be able to use both of the above in my database."
Topics covered:
|
| Who is it for? |
All staff. This course is aimed at those familiar with the concepts of Access Databases and some previous experience of using and creating a database. It would be useful for delegates to have an idea for a database that they wish to create following the course. |
| Participant preparation needed? |
You need to be familiar with the concepts of access databases and have some previous experience of using a database. |
| Additional Information |
Please see Access database courses |
| What prior experience do I need? |
Before attending: Delegates must have attended the course Introduction to Using an Access Database and Creating an Access Database or already have knowledge of:
|
| Formal assessment |
No |
| Facilitator(s) |
Nevin Moledina (IT Services) |
| Delegate places |
Maximum 11 delegates Minimum 5 delegates |
| How to make your reservation |
Please complete the appropriate On-line Booking Form submitting to the Staff Development Partnership. Booking Conditions apply |
| Questions |
About the workshop content: |
| For Office Use Only |
Course Code: SDCCT057 |
