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

AC03S-3

Organizing Data

AC03S-3-1

Create and modify calculated fields and aggregate functions

129, 140

AC03S-3-2

Modify form layout

92, 95, 186

AC03S-3-3

Modify report layout and page setup

191

AC03S-3-4

Format datasheets

51

AC03S-3-5

Sort records

118, 126

AC03S-3-6

Filter records

121, 123

AC03S04

Managing Databases

AC03S-4-1

Identify and modify object dependencies

217

AC03S-4-2

View objects and object data in other views

197

AC03S-4-3

Print database objects and data

22, 197

AC03S-4-4

Export data from Access

73

AC03S-4-5

Back up a database

238

AC03S-4-6

Compact and repair databases

217