GO19_AC_CH01_GRADER_1A_HW_Instructions.docx
Grader - Instructions Access 2019 Project
GO19_AC_CH01_GRADER_1A_HW - Advising 1.0
Project Description:
Instructional project 1A Advising Database with Two Tables. This project will be completed by following the Activities in the Project A of your GO! textbook. You can use the print or eText version to locate and read the Activity instructions. For the purpose of grading the project you are required to perform the following tasks:
Steps to Perform:
|
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
|
Created On: 07/11/2019 1 GO19_AC_CH01_GRADER_1A_HW - Advising 1.0
expmen
