Creating Advanced Queries and Enhancing Table Design
Creating Advanced Queries and Enhancing Table Design
Creating Advanced Queries and Enhancing Table Design
COMPREHENSIVE
Objectives XP
2
Objectives XP
3
Reviewing the Panorama Database XP
• Figure 5-1
4
Using a Pattern Match in a Query XP
5
Using a List-of-Values Match in a Query XP
6
Using the Not Operator in a Query XP
7
Using an AutoFilter to Filter Data XP
8
Assigning a Conditional Value XP
to a Calculated Field
• The & (ampersand) operator is a concatenation operator
that joins text expressions
• The IIf (Immediate If) function assigns one value to a
calculated field or control if a condition is true, and a second
value if the condition is false
• The IsNull function tests a field value or an expression for a
null value; if the field value or expression is null, the result is
true; otherwise, the result is false
• Figure 5-12
9
Creating a Parameter Query XP
10
Creating a Parameter Query XP
11
Creating a Crosstab Query XP
12
Creating a Crosstab Query XP
13
Creating a Crosstab Query XP
14
Creating a Find Duplicates Query XP
15
Creating a Find Unmatched Query XP
16
Creating a Find Unmatched Query XP
17
Creating a Top Values Query XP
18
Creating a Top Values Query XP
• Figure 5-29
19
Creating a Lookup Field XP
20
Creating a Lookup Field XP
• Figure 5-34
21
Using the Input Mask Wizard XP
22
Using the Input Mask Wizard XP
• Figure 5-36
23
Using the Input Mask Wizard XP
• Figure 5-37
24
Identifying Object Dependencies XP
25
Identifying Object Dependencies XP
• Figure 5-40
26
Defining Data Validation Rules XP
27
Defining Data Validation Rules XP
28
Working with Memo Fields XP
29
Designating a Trusted Folder XP
30