GO19_AC_CH02_GRADER_2A_HW - Instructors and Courses 1.1

Step

Instructions

Points Possible

1

Start Access. Open the file Student_Access_2A_Instructors_Courses.accdb downloaded with this project. Then, in your textbook, turn to Project 2A and complete all of the steps in Activities 2.01-2.16.

0

2

Complete Activity 2.01 Opening an Existing Database and Viewing Tables.

0

3

Complete Activity 2.02 Selecting the Tables and Common Field to Establish the Table Relationship.

2

4

Complete Activity 2.03 Setting Relationship Options.

3

5

Complete Activity 2.04 Saving a Relationship Report. Save the report as Relationships for 2A_Instructors_Courses.

5

6

Complete Activity 2.05 Displaying Subdatasheet Records.

0

7

Complete Activity 2.06 Testing Cascade Options.

6

8

Complete Activity 2.07 Sorting Records in a Table in Ascending or Descending Order.

0

9

Complete Activity 2.08 Sorting Records in a Table on Multiple Fields.

4

10

Complete Activity 2.09 Creating a New Select Query in Design View.

6

11

Complete Activity 2.10 Running, Saving, Printing, and Closing a Query.

4

12

Complete Activity 2.11 Copying an Existing Query.

10

13

Complete Activity 2.12 Modifying the Design of a Query.

10

14

Complete Activity 2.13 Sorting Query Results.

10

15

Complete Activity 2.14 Specifying Text Criteria in a Query.

15

16

Complete Activity 2.15 Specifying Criteria and Hiding the Field in the Query Results.

15

17

Complete Activity 2.16 Using Is Null Criteria to Find Empty Fields.

10

18

Save and close the database, and then submit for grading.

0

Total Points

100