|
Coding No.
|
SKILL
|
Content Pages
|
Exercise Pages
|
Chapter
|
|
AC2000E.1.
|
Building and modifying tables
|
|
|
|
|
AC2000E.1.1
|
Set validation text
|
14
|
15
|
1
|
|
AC2000E.1.2
|
Define data validation criteria
|
14
|
15
|
1
|
|
AC2000E.1.3
|
Modify an input mask
|
17-18
|
16-18, 18
|
1
|
|
AC2000E.1.4
|
Create and modify Lookup Fields
|
19
|
19-20, 20-21
|
1
|
|
AC2000E.1.5
|
Optimize data type usage (double,
long, int, byte, etc.)
|
13-14
|
|
1
|
|
AC2000E.2
|
Building and modifying forms
|
|
|
|
|
AC2000E.2.1
|
Create a form in Design View
|
33-34
|
35-36
|
2
|
|
AC2000E.2.2
|
Insert a graphic on a form
|
36-37, 38
|
39-40
|
2
|
|
AC2000E.2.3
|
Modify control properties
|
45-46
|
46
|
2
|
|
AC2000E.2.4
|
Customize form sections (headers,
footers, detail)
|
40
|
41
|
2
|
|
AC2000E.2.5
|
Modify form properties
|
48
|
49
|
2
|
|
AC2000E.2.6
|
Use the Subform Control and synchronize
forms
|
49-50, 51-52
|
50-51
|
2
|
|
AC2000E.2.7
|
Create a Switchboard
|
53-54
|
54-55
|
2
|
|
AC2000E.3
|
Refining queries
|
|
|
|
|
AC2000E.3.1
|
Apply filters (filter by form
and filter by selection) in a query's record set
|
61-63
|
64-68
|
3
|
|
AC2000E.3.2
|
Create a totals query
|
68-70
|
70-71
|
3
|
|
AC2000E.3.3
|
Create a parameter query
|
75
|
76-78
|
3
|
|
AC2000E.3.4
|
Specify criteria in multiple
fields (AND vs. OR)
|
83
|
84-86
|
3
|
|
AC2000E.3.5
|
Modify query properties (field
formats, caption, input masks, etc.)
|
83-84
|
84-86
|
3
|
|
AC2000E.3.6
|
Create an action query (update,
delete, insert)
|
78-81
|
82
|
3
|
|
AC2000E.3.7
|
Optimize queries using indexes
|
148-149
|
149-150
|
5
|
|
AC2000E.3.8
|
Specify join properties for relationships
|
146-147
|
147
|
5
|
|
AC2000E.4
|
Producing reports
|
|
|
|
|
AC2000E.4.1
|
Insert a graphic on a report
|
108-109
|
109-110
|
4
|
|
AC2000E.4.2
|
Modify report properties
|
110-112
|
113-117
|
4
|
|
AC2000E.4.3
|
Create and modify a report in
Design View
|
96-98, 101-103
|
98-101, 103-105
|
4
|
|
AC2000E.4.4
|
Modify control properties
|
110-112
|
113-117
|
4
|
|
AC2000E.4.5
|
Set section properties
|
110-112
|
113-117
|
4
|
|
AC2000E.4.6
|
Use the Subreport Control and
synchronize reports
|
117-119
|
119-122
|
4
|
|
AC2000E.5
|
Defining relationships
|
|
|
|
|
AC2000E.5.1
|
Establish one-to-one relationships
|
130-137
|
137-139
|
5
|
|
AC2000E.5.2
|
Establish many-to-many relationships
|
130-137
|
140-141
|
5
|
|
AC2000E.5.3
|
Set Cascade Update and Cascade
Delete options
|
141-143
|
145
|
5
|
|
AC2000E.6
|
Utilizing web capabilities
|
|
|
|
|
AC2000E.6.1
|
Create hyperlinks
|
208
|
209-210
|
7
|
|
AC2000E.6.2
|
Use the group and sort features
of data access pages
|
205
|
205-207
|
7
|
|
AC2000E.6.3
|
Create a data access page
|
202
|
203-205,
|
7
|
|
AC2000E.7
|
Using Access tools
|
|
|
|
|
AC2000E.7.1
|
Set and modify a database password
|
155-156
|
156-157
|
6
|
|
AC2000E.7.2
|
Set startup options
|
159-160
|
160-161
|
6
|
|
AC2000E.7.3
|
Use Add-ins (Database Splitter,
Analyzer, Link Table Manager)
|
161, 167, 169-170,
|
162-164, 168-169, 170-171, 171-172
|
6
|
|
AC2000E.7.4
|
Encrypt and Decrypt a database
|
158
|
|
6
|
|
AC2000E.7.5
|
Use simple replication (copy
for a mobile user)
|
173-174
|
|
6
|
|
AC2000E.7.6
|
Run macros using controls
|
178
|
|
6
|
|
AC2000E.7.7
|
Create a macro using the Macro
Builder
|
174-176
|
177-178
|
6
|
|
AC2000E.7.8
|
Convert database to a previous
version
|
164
|
|
6
|
|
AC2000E.8
|
Data Integration
|
|
|
|
|
AC2000E.8.1
|
Export database records to Excel
|
187-188
|
189-190
|
7
|
|
AC2000E.8.2
|
Drag and drop tables and queries
to Excel
|
190
|
191-192
|
7
|
|
AC2000E.8.3
|
Present information as a chart
(MS Graph)
|
192
|
192-196
|
7
|
|
AC2000E.8.4
|
Link to existing data
|
169-170
|
170-171
|
6
|
