GO19_AC_CH01_GRADER_1A_HW - Advising 1.0

Step

Instructions

Points Possible

1

Start Access. Open the file Student_Access_1A_Advising.accdb downloaded with this project. Then, in your textbook, turn to Project 1A and complete all of the steps in Activities 1.01-1.17.

0

2

Complete Activity 1.01 Using Good Design Techniques to Plan a Database

0

3

Complete Activity 1.02 Starting with a Blank Desktop Database.

0

4

Complete Activity 1.03 Assigning the Data Type and Name to Fields.

10

5

Complete Activity 1.04 Renaming Fields, Changing Data Types, and Setting Field Size in a Table.

4

6

Complete Activity 1.05 Adding a Record to a Table.

10

7

Complete Activity 1.06 Adding Additional Records to a Table.

10

8

Complete Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table.

10

9

Complete Activity 1.08 Deleting a Table Field in Design View.

5

10

Complete Activity 1.09 Adding Field Descriptions and Changing Field Size

9

11

Complete Activity 1.10 Viewing the Primary Key in Design View.

1

12

Complete Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet.

9

13

Complete Activity 1.12 Adjusting Column Widths and Viewing a Table in Print Preview.

0

14

Complete Activity 1.13 Viewing a Table in Print Preview.

0

15

Complete Activity 1.14 Creating a Query by Using the Simple Query Wizard.

10

16

Complete Activity 1.15 Creating a Form.

9

17

Complete Activity 1.16 Creating and Modifying a Report.

11

18

Complete Activity 1.17 Closing a Database and Close Access.

2

19

Save and close the file, and then submit the Access_1A_Advising.accdb database for grading.

0

Total Points

100