Microsoft
Office
Specialis
Microsoft Office
Specialist Skill Standards
Each Microsoft Office Specialist certification has a set of corresponding skill standards
that describe areas of individual, Microsoft Office program use. You should master
each skill standard to prepare for the corresponding Microsoft Office Specialist
certification exam.
Microsoft
This book will fully prepare you for the Microsoft Office Specialist certification at
Office
the Specialist level. Throughout this book, content that pertains to a Microsoft Office
Specialist
t
Specialist skill standard is identified with the logo shown in the margin.
Standard
Skill
Page
AC03S-1 Structuring Databases
AC03S-1-1 Create Access databases
32, 41
AC03S-1-2 Create and modify tables
41, 44, 51
AC03S-1-3 Define and create field types
44, 146, 160
AC03S-1-4 Modify field properties
150, 152
AC03S-1-5 Create and modify one-to-many relationships
106
AC03S-1-6 Enforce referential integrity
106
AC03S-1-7 Create and modify queries
129, 138, 166
AC03S-1-8 Create forms
84, 104
AC03S-1-9 Add and modify form controls and properties
86, 95
AC03S-1-10 Create reports
176, 186
AC03S-1-11 Add and modify report control properties
180
AC03S-1-12 Create a data access page
283
AC03S-2 Entering Data
AC03S-2-1 Enter, edit and delete records
36, 170
AC03S-2-2 Find and move among records
6
AC03S-2-3 Import data to Access
58, 61, 63,
66, 68, 69, 71
xxv
|
|