Basic Querying in Access 2007
Categories: Microsoft Access
Basic Querying in Access 2007.

About the Course:
This course is for Microsoft Access 2007. Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered.

Course Overview:
- 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
 
Tools
 
Key Details
Duration1 day
 
£225
per delegate