Microsoft Office Specialist Skill Standards

Each Microsoft Office Specialist certification has a set of Skill Standards, which are organized into broader skill sets. To prepare for an Office Specialist exam, you should confirm that you can meet its respective standards. This course will prepare you for the Microsoft Office Specialist exam for Microsoft Office Access 2003 at the Core level because it covers all the Skill Standards associated with that examination.

The following table lists the Skill Standards for the Microsoft Office Specialist Core Exam for Microsoft Office Access 2003, alongside the course lessons and topics in which each of those Skill Standards is addressed.

Office Specialist Skill Standard	Description	Lesson	Topic
AC03S.1	Structuring Databases
AC03S.1.1	Create Access databases	Creating a New Database	Creating New Databases
AC03S.1.10	Create reports	Working with Reports	Creating and Exploring Reports
AC03S.1.11	Add and modify report control properties	Working with Reports	Modifying a Report
AC03S.1.11	Add and modify report control properties	Working with Reports	Creating and Modifying a Report in Design View
AC03S.1.12	Create a data access page	Importing and Exporting Information	Sharing Information
AC03S.1.2	Create and modify tables	Creating a New Database	Creating Tables the Simple Way
AC03S.1.2	Create and modify tables	Creating a New Database	Exploring Tables in Design View
AC03S.1.3	Define and create field types	Creating a New Database	Exploring Tables in Design View
AC03S.1.4	Modify field properties	Creating a New Database	Exploring Tables in Design View
AC03S.1.5	Create and modify one-to-many relationships	Simplifying Data Entry with Forms	Adding a Subform to a Form
AC03S.1.6	Enforce referential integrity	Simplifying Data Entry with Forms	Adding a Subform to a Form
AC03S.1.7	Create and modify queries	Locating Specific Information	Creating Queries in Design View
AC03S.1.8	Create forms	Simplifying Data Entry with Forms	Creating and Exploring Forms
AC03S.1.9	Add and modify form controls and properties	Simplifying Data Entry with Forms	Refining Form Properties
AC03S.1.9	Add and modify form controls and properties	Simplifying Data Entry with Forms	Adding Controls to a Form
AC03S.2	Entering Data
AC03S.2.1	Enter, edit, and delete records	Creating a New Database	Editing Data
AC03S.2.2	Find and move among records	Getting to Know Access	Exploring Access and Database Objects
		Getting to Know Access	Exploring Forms and Reports
		Simplifying Data Entry with Forms	Creating and Exploring Forms
AC03S.2.3	Import data to Access	Importing and Exporting Information	Importing Information from a Spreadsheet
			Importing Information from a Text File
			Importing Information from a Database
			Importing Information from HTML and XML Documents
AC03S.3	Organizing Data
AC03S.3.1	Create and modify calculated fields and aggregate functions	Locating Specific Information	Performing Calculations in a Query
AC03S.3.2	Modify form layout	Simplifying Data Entry with Forms	Refining Form Layout
AC03S.3.2	Modify form layout	Simplifying Data Entry with Forms	Adding Controls to a Form
AC03S.3.3	Modify report layout and page setup	Working with Reports	Creating and Modifying a Report in Design View
AC03S.3.3	Modify report layout and page setup	Working with Reports	Adding Calculated Controls to Reports
AC03S.3.4	Format datasheets	Creating a New Database	Exploring Tables in Datasheet View
AC03S.3.5	Sort records	Locating Specific Information	Sorting Information
AC03S.3.6	Filter records	Locating Specific Information	Filtering Information in Tables and Forms
AC03S.4	Managing Databases
AC03S.4.1	Identify and modify object dependencies.	Keeping Information Secured	Sharing a Database
AC03S.4.2	View objects and object data in other views	Getting to Know Access	Exploring Access and Database Objects
			Exploring Queries
			Exploring Forms and Reports
		Working with Reports	Modifying a Report
		Working with Reports	Creating and Modifying a Report in Design View
		Simplifying Data Entry with Forms	Refining Form Properties
AC03S.4.3	Print database objects and data	Creating a New Database	Exploring a Database
		Creating a New Database	Exploring Tables in Datasheet View
		Working with Reports	Modifying a Report
		Simplifying Data Entry with Forms	Adding a Subform to a Form
AC03S.4.4	Export data from Access	Importing and Exporting Information	Exporting Information to Other Programs
AC03S.4.5	Back up a database	Keeping Information Secured	Protecting a Database Using a Password
AC03S.4.6	Compact and repair databases	Keeping Information Secured	Protecting a Database Using a Password