Coding No.

Objective/Sub-Objective Topic

Content Page(s)

Exercise Page(s)

Chapter(s)

AC2000.1

Planning and designing databases

AC2000.1.1

Determine appropriate data inputs for your database

778-781, 849-850

19, 21

AC2000.1.2

Determine appropriate data outputs for your database

792-795, 871, 888, 884-886

19, 21

AC2000.1.3

Create table structure

781-788

784-786, 787-788

19

AC2000.1.4

Establish table relationships

813-815, 819-826

823-828

20

AC2000.2

Working with Access

AC2000.2.1

Use the Office Assistant

805

19

AC2000.2.2

Select an object using the Objects Bar

853, 857, 871, 874

857-858, 874-875

21

AC2000.2.3

Print database objects (tables, forms, reports, queries)

792-795, 850-851

793, 795, 851

19, 21

AC2000.2.4

Navigate through records in a table, query, or form

850-851

851

21

AC2000.2.5

Create a database (using a Wizard or in Design View)

781-795, 899-906

784-788, 790-792, 903-906

19, 22

AC2000.3

Building and modifying tables

AC2000.3.1

Create tables by using the Table Wizard

832-840

832-834, 836-838

20

AC2000.3.2

Set primary keys

815-818

816-818

20

AC2000.3.3

Modify field properties

797-803

19

AC2000.3.4

Use multiple data types

779-781, 784-785

784-785

19

AC2000.3.5

Modify tables using Design View

797-805

801-803, 804-805

19

AC2000.3.6

Use the Lookup Wizard

799-803

19

AC2000.3.7

Use the input mask wizard

797-803

19

AC2000.4

Building and modifying forms

AC2000.4.1

Create a form with the Form Wizard

853-859

857-859

21

AC2000.4.2

Use the Control Toolbox to add controls

866-869

867-868, 869-870

21

AC2000.4.3

Modify Format Properties (font, style, font size, color, caption, etc.) of controls

862-869

862-869, 868-870

21

AC2000.4.4

Use form sections (headers, footers, detail)

866-869

867-868

21

AC2000.4.5

Use a Calculated Control on a form

869-870

869-870

21

AC2000.5

Viewing and organizing information

AC2000.5.1

Use the Office Clipboard

918-919

22

AC2000.5.2

Switch between object Views

788, 797, 801

801-803

19

AC2000.5.3

Enter records using a datasheet

789-792

19

AC2000.5.4

Enter records using a form

852-853

852-853

21

AC2000.5.5

Delete records from a table

796-797

796-797

19

AC2000.5.6

Find a record

796-797

796-797

19

AC2000.5.7

Sort records

805-806

806

19

AC2000.5.8

Apply and remove filters (filter by form and filter by selection)

948-952

948-949, 950-952

23

AC2000.5.9

Specify criteria in a query

933-944

937-941, 943, 944

23

AC2000.5.10

Display records in a subdatasheet

829-831

20

AC2000.5.11

Create a calculated field

945

945

23

AC2000.5.12

Create and modify a multi-table select query

939-941

939-941

23

AC2000.6

Defining relationships

AC2000.6.1

Establish relationships

819-826

823-826

20

AC2000.6.2

Enforce referential integrity

821-826

823-826

20

AC2000.7

Producing reports

AC2000.7.1

Create a report with the Report Wizard

871-877

874-875, 876-877

21

AC2000.7.2

Preview and print report

874-875

874-875

21

AC2000.7.3

Move and resize a control

879-883

21

AC2000.7.4

Modify format properties (font, style, font size, color, caption, etc.)

879-883

880-883

21

AC2000.7.5

Use the Control Toolbox to add controls

879-883

880-883

21

AC2000.7.6

Use report sections (headers, footers, detail)

879-883

880-883

21

AC2000.7.7

Use a Calculated Control in a report

879-883

880-883

21

AC2000.8

Integrating with other applications

AC2000.8.1

Import data to a new table

915-916

915-916

22

AC2000.8.2

Save a table, query, form as a Web page

920-924

22

AC2000.8.3

Add Hyperlinks

921-924

22

AC2000.9

Using Access Tools

AC2000.9.1

Print Database Relationships

822-826

823-826

20

AC2000.9.2

Backup and Restore a database

924-925

22

AC2000.9.3

Compact and Repair a database

925

22