|
Provided by: Wise Owl Business Solutions Ltd Basic Querying in Access 2007Access |
 |
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.
For a full list of course topics, see our website
For a full list of course topics, see our website
Related Software Programs or Products: Microsoft Access
|
|
||||||||||||||||||
Training
Provided by Wise Owl Business Solutions Ltd
Basic Querying in Access 2007
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
In order to attend this Microsoft Access training course you should already be a confident computer user. Most people find Access harder to learn than Excel or Word (for example). There will be a maximum of 6 people on each course, and each person will have their own computer.
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
In order to attend this Microsoft Access training course you should already be a confident computer user. Most people find Access harder to learn than Excel or Word (for example). There will be a maximum of 6 people on each course, and each person will have their own computer.
About The Training Provider: Wise Owl Business Solutions Ltd
Wise Owl Business Solutions Ltd - Looking for friendly but professional scheduled or onsite Microsoft training in the UK? We deliver courses in Access, Excel, Visual Basic, ASP. NET, PowerPoint, FrontPage, Word, Project at all levels.
If you want: a choice of venues (or if you want onsite Microsoft training, a company prepared to visit your premises to discuss your needs), experienced trainers who know their subject, clear...
