Access Query Writing Training Course
|
Summary
|
|
|||||||||||||
Access Query Writing Training Course
Access Query Writing - 1 day course in Crawley
This 1 day training course is designed to teach delegates that are new or existing users of Access how to equery writing techniques for quick, easy and accurate data extraction.
By the end of the course delegates will be able to:
- Create select queries from multiple tables
- Include calculations and parameters in queries
- Create unmatched queries
- Create action queries to manipulate data
- Create de-duplication queries
If you want to find out more about Access Query Writing Training Course, you can make an information request below and the school will contact you with further information.
Suitability and application
This Access Query Writing Course is designed for new or existing users of Microsoft Access who need to write and use queries for extracting information out of databases. It covers query writing techniques for quick, easy and accurate data extraction. You should be competent in using a PC for general business use, familiarity of Access would be an advantage.
Pre-requisites: You should be competent in using a PC for general business use. No previous experience of Access is required.
Enquire to see if this Access Query Writing Course is suitable for you here.
Access Queries and Reports Course - Essentials Course Content
This Access Queries and Reports Course - Essentials Course is designed to cover the following areas:
Starting to use Access
- Opening Access
- Opening a database
- Database objects
- Keys and indexes
- Amending data
- Using forms
Working with data
- Sorting data
- Searching for information
- Filtering data
Creating simple queries
- Creating select queries
- Adding criteria
- Creating parameter queries
Calculations in queries
- Adding calculations to queries
- Formatting data in queries
Building multi table queries
- Deciding which tables to use
- Adding tables to the query
- Creating links between tables
- Join properties
Printing and reporting
- Using the report wizard
- Amending reports
- Adding calculations
- Adding headers and footers
Exporting data
- Exporting Word
- Exporting to Excel
- Exporting to a snapshot
Access Query Writing Course Content
This Microsoft Access Query Writing training course is designed to cover the following subjects:
The Database Structure
- Database objects
- Table structure
- Keys and indexes
- Relational databases
Query Writing Principles
- Extracting data using select queries
- Setting criteria
- Creating parameter queries
- Calculations in queries
Multi Table Queries
- Linking tables in queries
- Join types
- Creating queries to find unmatched data
Query Options
- Top values queries
- Unique values queries
- Formatting query output
Summary Queries
- Adding totals to your queries
- Building crosstab queries
Action Queries (Part 1)
- Using make table queries
- Using append queries
Action Queries (Part 2)
- Using delete queries
- Using update queries
De-duplication techniques
- Using the duplicates query wizard
- Eliminating duplicates using an append query
- Finding differences between tables
Access Query Writing Course Content
This Microsoft Access Query Writing training course is designed to cover the following subjects:
The Database Structure
- Database objects
- Table structure
- Keys and indexes
- Relational databases
Query Writing Principles
- Extracting data using select queries
- Setting criteria
- Creating parameter queries
- Calculations in queries
Multi Table Queries
- Linking tables in queries
- Join types
- Creating queries to find unmatched data
Query Options
- Top values queries
- Unique values queries
- Formatting query output
Summary Queries
- Adding totals to your queries
- Building crosstab queries
Action Queries (Part 1)
- Using make table queries
- Using append queries
Action Queries (Part 2)
- Using delete queries
- Using update queries
De-duplication techniques
- Using the duplicates query wizard
- Eliminating duplicates using an append query
- Finding differences between tables
Expenses
The cost of this Access Queries and Reports Course - Essentials Course is £175.00 + VAT.
The following Versions are available: 2003, 2007, 2010
Lunch and refreshments: As part of your time with us you will enjoy delicious hot and cold food and refreshments daily from our restaurant.
Reference material: As part of your training you will be provided with a participant manual for you to use during your training. You can then take it away with you to use as a practical reference tool back at the office.
In House training: Should you want to hold a bespoke course at a different venue, please contact us here.
Thales Training
Thales Training - Business Training Courses & Bespoke Training Services
Thales Training & Consultancy, part of the international Thales Group, is an established training services organisation who works in partnership with our customers to develop individual, organisational and commercial advantage. Since 1998 we have been providing innovative training and managed services. Each year we continue to see our business grow delivering training and development solutions to over 10,000 participants internationally.
What we do
Thales Training & Consultancy delivers over 100 training courses in the areas of Management and People Development, IT and Computing, Technology, Project and Risk Management and Systems Engineering. All our courses are highly practical, include examples of best practice and can equip you with the skills and confidence you need to succeed in the workplace.
- Short Training Courses
- Outsourced Training Managed Service /Training Supply Management services
- Management and People Development Training
- IT / Computer Training
- Training Design and Consultancy
- Coaching Consultancy
- Health and Safety Training
- Bespoke Learning and Development Solutions
Courses designed by our trainers
All our courses are exclusively designed and regularly updated by our team of business experienced and expert trainers. This means when you attend one of our training courses you always benefit from the latest thinking and developments.
Our learning environment
All our training courses are held at our state of the art training centre in Crawley. The training centre provides a learning environment that is relaxed, offers great food, easy access, free parking and an exceptional customer service. All of which leads to time out of the office that we believe you’ll want to do again.
Show all courses with
Thales Training
Request information - obligation free
Contact information for Thales Training
Thales Training
RH10 9XN Crawley
Phone no: +44 (0)800 028 3045 
www.thales-trainingconsultancy.com
Contact Thales Training
Reviews by course attendees
Show all reviews
To request information from Access Query Writing Training Course, please fill out the following details:
| Average rating | Quantity | Rec. | ||
| 5.0 | 1 | 100 % |
