Access Working with Queries

Oak Tree Management & Training Ltd.
Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This course focuses on the role of the database designer in the specification and creation of queries and will cover Access queries in detail. Covering both the theory and practicalities of query design this course takes the delegates through the various queries available in Access. It will explain the theory and practical elements of select, multi-table and action queries, ensuring a comprehensive understanding of this particular type of Access object.

Having designed and created perfect tables to ensure that data has been entered consistently, a logical progression is to create Queries to select and 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; and 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 and bad queries ...''

Elements of this syllabus are subject to change.

Phone:(01284) 763040

School Address/Venue(s):

Park Farm Business Centre
Fornham St Genevieve
Bury St Edmunds
Suffolk
United Kingdom
IP28 6TS

Jobs & Resumes: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Houses & Roommates: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Travel Agencies: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Nottingham

Search other schools for Access Working with Queries training resources.

IOSH Supervising Safely Certificate
Fire Marshals & Fire Risk Assessment
Fire Marshal and Practical Fire Extinguisher
Cranes & Lifting Operation
Confined Spaces
Health and Safety in Health and Social Care
Health & Safety in the Workplace
Access Foundation
Access Intermediate
Access VBA
Acrobat
Illustrator CS
InDesign CS
PageMaker 7
Photoshop CS2
Crystal Reports - Advanced
Crystal Reports

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!