New Perspectives Access 2019 | Module 5: SAM Project 1b | Ridgedale College |

Описание: New Perspectives Access 2019 | Module 5: SAM Project 1b | Ridgedale College | ⁨@Solution512-r2j⁩


#New Perspectives Access 2019#Module 5: SAM Project 1b#Module 5
#Perspectives Access 2019 | Module 5: SAM Project 1b#SAM Project 1b
#New Perspectives Access 2019 | Module 5#Ridgedale College
#modifying TABLES AND QUERIES#NP_AC19_5b_FirstLastName_1.accdb
#NP_AC19_5b#Access 2019#Perspectives Access 2019 | Module 5
#new perspectives access 2019 module 5 sam project 1b#Project 1b
#ridgedale







Ridgedale College
MODIFYING TABLES AND QUERIES

GETTING STARTED
• Open the file NP_AC19_5b_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as NP_AC19_5b_FirstLastName_2.accdb by changing the “1” to a “2”.
o If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. You work in the Admissions Office at Ridgedale College to help track grants awarded to professors as well as teaching assistant assignments by class. You have created an Access database to organize these details. In this project, you will improve the tables and queries of the database.

In Design View of the TeachingAssistants table, add three new fields with the following specifications:

a. A field named TAEmail with a Hyperlink data type.
b. A field named TAPhoto with an Attachment data type.
c. A field named Evaluation with a Long Text data type.
d. For the Evaluation field, use Yes as the value for the Append Only property value. Save the TeachingAssistants table.