What Does This Logo Mean?

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