|
This chapter will enable you to use Microsoft Access
to create tables, queries, and reports. The skills you learn in
this chapter will enhance your ability to organize and work with
data. You will be able to select specific information out of an
entire set of data by striking just a few keys.
|
|
|
|
By the end of this tutorial, you will:
- Understand the
different aspects of a report
- Be able to make
a report using Report Wizard
- Be able to make
a query
- Be able to group
your data
- Be able to
create a Crosstab Query
- Be able to
create an Action Query
|
|
These lessons and exercises will teach you how
several aspects of Access
|
|
Lesson
|
Description
|
Link
|
|
Lesson
1:
|
Understanding what a report is and the tools needed
to make a report.
|
Report
|
|
Lesson
2:
|
Using Report Wizard, the simplest way to make a
report.
|
Report
Wizard
|
|
Lesson 3:
|
Learning how to find out about selected information
about your report by using Queries.
|
Queries
|
|
Lesson 4:
|
Grouping Records in a report to organize data to be
referenced at any given time.
|
Grouping
|
|
Lesson 5:
|
Learning how to create Crosstab and Action
Queries. Learning the uses of the different types of Action
Queries.
|
Crosstab
and Action
|
|
Exercise
|
Description
|
Link
|
|
Exercise
1:
|
Creating a Table to use for exercise 2 and 3.
|
Table
Exercise
|
|
Exercise
2:
|
Creating a Report using your table.
|
Report
Exercise
|
|
Exercise
3:
|
Creating a Query using your table.
|
Query
Exercise
|
|
Query
Exercise 4:
|
Creating Queries for Exercise 4 - 8
Creating a Make-Table
|
Query
Make-Table
|
|
Exercise
5:
|
Creating a Delete Table
|
Delete
Table
|
|
Exercise
6:
|
Creating an Append Query
|
Append
Query
|
|
Exercise
7:
|
Creating an Update Query
|
Update
Query
|
|
Exercise
8:
|
Creating a Crosstab Query
|
Crosstab
Query
|
|
20
Projects
|
20 Additional Practice Projects.
|
20
Projects
|
|
PowerPoint
Presentation:
|
View the PowerPoint presentation for this chapter.
|
PowerPoint Presentation
|
|
Final Cumulative Exam
|
This exam tests you on the information taught on
this web site. Your percentage correct will give you an idea of
how well you understood the material and how to use the aspects taught
in Chapter 3.
|
Exam
|
|
100 Hands
on Exam Question
|
100 hands on exam questions.
|
100 Exam
Questions
|
|
Instructor Resources
|
View the answers to the final exam.
|
Exam
Answers
|
|
Answer Key
|
Answers to 100 hands on exam questions and 20
projects.
|
Answers to
20 Projects
Answers
to 100 Exam Questions
|
|
 Back to Programs
|
: Chapter 3
