Access 2010 Querying training course (1 day)

Have you got a corporate database from which you want to extract information? It might be Access, or it might be Sage or in SQL Server. This one-day course will not show you how to build new databases, but it will show you how to get information out of existing ones. The course explains how databases are constructed, then shows the ins and outs of creating queries and reports. Note that this course is an alternative to our 3-day Access for Developers course, not a precursor.

Access 2010 Querying training - Course Contents

The contents of our Access 2010 Querying course are as follows (any items marked with a * will be covered if time allows):

Designing a database
  • Identifying the tables
  • What are relationships?
  • Setting a primary key
  • Using multivalue fields
Creating tables
  • Defining fields
  • The types of field
  • Entering data
Drawing relationships (*)
  • Creating relationships
  • Referential integrity
Creating queries
  • The query design grid
  • Sorting
  • Setting criteria
  • Combining criteria
Advanced queries
  • Grouping and totalling
  • Creating expressions
  • Parameter queries
Joins (*)
  • Creating ad hoc joins
  • Types of join
Creating forms
  • Layout and design view
  • Using the form wizard
  • Split forms
  • Creating controls
Creating reports
  • Using the report wizard
  • The group, sort and total pane
  • Report design

Click on any link above to show free exercises for the topic in question. You should already be a confident Windows user to attend this course, but do not need to have used Access before. Note that most people find Access harder to learn than Excel. There will be a maximum of 6 people on each course, and each person will have their own computer.

SITE MAP

All content copyright Wise Owl Business Solutions Ltd 2012.  You can follow us on FaceBook. All rights reserved.