Access Query Design

1
Access Query Design
The Query design screen provides a mechanism for
selecting specific data from datafile(s) by
2
Access Query Screen
Query Design Screen
3
Access Query Screen (cont.)
Selecting Fields Highlight the field in the
active table. Drag the field from the active
table and drop it in the field view skeleton.
Selecting Records CRITERIA Enter criteria into
bottom section of the query design
screen. Character field
4
CRITERIA
5
CRITERIA (CONT.)
Numeric field
6
CRITERIA (CONT.)
Date Fields eg. before 27th July 1987 is
entered as
7
CRITERIA (CONT.)
Logical Fields
8
MULTIPLE CRITERIA
Condition1 AND Condition2 Enter conditions on
the same line.
9
MULTIPLE CRITERIA (CONT.)
10
MULTIPLE CRITERIA (CONT.)
11
MULTIPLE CRITERIA (CONT.)
Output
12
MULTIPLE CRITERIA (CONT.)
Condition1 OR Condition2 Enter conditions on
different lines in file skeleton
13
MULTIPLE CRITERIA (CONT.)
Output
14
MULTIPLE CRITERIA (CONT.)
15
MULTIPLE CRITERIA (CONT.)
Output
16
SORTING RECORDS
Access allows you to sort the output in ascending
or descending order on character, numeric date
fields.
17
SORTING RECORDS (CONT.)
Example 1 Sort all employees in ascending order
according to Name. Show Name, DOB Department
18
SORTING RECORDS (CONT.)
Output
19
SORTING RECORDS (CONT.)
Example 2 Sort all employees in ascending order
according to Name within each Department. Show
Name, DOB Department
20
SORTING RECORDS (CONT.)
Output
21
SHOWING RECORDS
Tick the SHOW box if you want the field to be
displayed. Note Not all SHOW boxes should be
ticked.
22
SORTING RECORDS (CONT.)
Output