| It means this book has been approved by the Microsoft Office Specialist program to be certified courseware for learning Microsoft Office Access 2003 and preparing for the certification exam. This book will prepare you fully for the Microsoft Office Specialist exam at the specialist level for Microsoft Office Access 2003. Each certification level has a set of objectives, which are organized into broader skill sets. Throughout this book, content that pertains to a Microsoft Office Specialist objective is identified with the Microsoft Office Specialist logo and objective number below the title of the topic:  Access 2003 Specialist Objectives | Objective | Skill | Page | | AC03S-1 | Structuring Databases | AC03S-1-1 | Create Access databases | 40-41, 46-47 | AC03S-1-2 | Create and modify tables | 50-51, 56 | AC03S-1-3 | Define and create field types | 56, 68, 70, 84-85 | AC03S-1-4 | Modify field properties | 70, 76-77 | AC03S-1-5 | Create and modify one-to-many relationships | 60-61 | AC03S-1-6 | Enforce referential integrity | 62 | AC03S-1-7 | Create and modify queries | 119-121, 129-131, 136-137 | AC03S-1-8 | Create forms | 142-145 | AC03S-1-9 | Add and modify form controls and properties | 148-151, 184-185 | AC03S-1-10 | Create reports | 160-161, 164-165 | AC03S-1-11 | Add and modify report controls properties | 172-173 | AC03S-1-12 | Create a data access page | 222-223 | | AC03S-2 | Entering Data | AC03S-2-1 | Enter, edit and delete records | 88, 96-97 | AC03S-2-2 | Find and move among records | 89, 90 | AC03S-2-3 | Import data to Access | 55, 238-239 | | AC03S-3 | Organizing Data | AC03S-3-1 | Create and modify calculated fields and aggregate functions | 128 | AC03S-3-2 | Modify form layout | 184-185, 192-193 | AC03S-3-3 | Modify report layout and page setup | 164-165, 180, 192-193 | AC03S-3-4 | Format datasheets | 106 | AC03S-3-5 | Sort records | 108-109 | AC03S-3-6 | Filter records | 112-113 | | AC03S-4 | Managing Databases | AC03S-4-1 | Identify and modify object dependencies | 63-64 | AC03S-4-2 | View objects and object data in other views | 181, 222-224, 230 | AC03S-4-3 | Print database objects and data | 182 | AC03S-4-4 | Export data from Access | 244-246, 242-243 | AC03S-4-5 | Back up a database | 262 | AC03S-4-6 | Compact and repair databases | 263 | |
|
