Access Module 1 SAM Project B Ridgedale College | Access Module 1 SAM Project 1b

Hire Me and All Whole Semesters
Contact Me on my Whatsapp:=====================
WhatsApp No: +923019769937
Whatsapp Contact Link: https://rb.gy/ej2o95
#Access Module 1 SAM Project B
#Access_Module_1_SAM_Project_B
#AccessModule1SAMProjectB
#Access Module 1 SAM Project 1b
#Access_Module_1_SAM_Project_1b
#AccessModule1SAMProject1b
#Access Module 1 SAM Project B Ridgedale College
#Access_Module_1_SAM_Project_B_Ridgedale_College
#AccessModule1SAMProjectBRidgedaleCollege
#New Perspectives Access 2019 Module 1 SAM Project 1b
#New_Perspectives_Access_2019_Module_1_SAM_Project_1b
#NewPerspectivesAccess2019Module1SAMProject1b
#shelly cashman access 2019 module 1 sam project 1b
#shellycashmanaccess2019module1samproject1b
#shelly_cashman_access_2019_module_1_sam_project_1b
#Ridgedale College
#RidgedaleCollege
#Ridgedale_College
#CREATING AND MODIFYING TABLES AND OTHER DATABASE OBJECTS
#CREATINGANDMODIFYINGTABLESANDOTHERDATABASEOBJECTS
#CREATING_AND_MODIFYING_TABLES_AND_OTHER_DATABASE_OBJECTS
#NP_AC19_1b_FirstLastName_1.accdb
#NP_AC19_1b_FirstLastName_2.accdb
#NP_AC19_1b
#cengage
#np
#AC19
#Cengage_Access_Module_1_SAM_Project_B
PROJECT STEPS
1. You are a graduate teaching assistant for Ridgedale College, a private college in the Midwest. To help the college better manage their course scheduling, you have created an Access database and are working on the tables.

Create a new table in Datasheet View with the following options:
a. Rename the ID field to DeptID and change the data type to Short Text.
b. Change the field size of the DeptID field to 4.
c. Add a new field with the name DeptName and the Short Text data type. Save the table and use Departments as the table name.

2. With the Departments table still open in Datasheet View, add the seven records shown in Table 1. Save and close the Departments table.

3. Create a new table in Design View to store the teaching assistants at Ridgedale College as follows:
a. Add a field with the name TAID and the AutoNumber data type.
b. Make TAID the table's primary key. Save the table with the name TeachingAssistants but do not close it.
4. With the TeachingAssistants table still open in Design View, add a second and third field to the table with the field names TAFirstName and TALastName, each with the Short Text data type. Save the TeachingAssistants table and then close it.
5. Open the Professors table in Design View and use ProfFirstName as the new field name for the FirstName field and use ProfLastName as the new field name for the LastName field.
#AccessModule1SAMProjectA
#AccessModule1SAMProjectB
#AccessModule2SAMProjectA
#AccessModule2SAMProjectB
#AccessModule3SAMProjectA
#AccessModule3SAMProjectB
#AccessModule4SAMProjectA
#AccessModule4SAMProjectB
#AccessModule5SAMProjectA
#AccessModule5SAMProjectB
#AccessModule6SAMProjectA
#AccessModule6SAMProjectB
#AccessModule7SAMProjectA
#AccessModule7SAMProjectB
#AccessModule8SAMProjectA
#AccessModule8SAMProjectB
#AccessModule9SAMProjectA
#AccessModule9SAMProjectB
#AccessModule10SAMProjectA
#AccessModule10SAMProjectB
#AccessModule11SAMProjectA
#AccessModule11SAMProjectB
#AccessModule12SAMProjectA
#AccessModule12SAMProjectB
#NP_AC19_1a_FirstLastName_1.accdb
#NP_AC19_1b_FirstLastName_1.accdb
#NP_AC19_2a_FirstLastName_1.accdb
#NP_AC19_2b_FirstLastName_1.accdb
#NP_AC19_3a_FirstLastName_1.accdb
#NP_AC19_3b_FirstLastName_1.accdb
#NP_AC19_4a_FirstLastName_1.accdb
#NP_AC19_4b_FirstLastName_1.accdb
#NP_AC19_5a_FirstLastName_1.accdb
#NP_AC19_5b_FirstLastName_1.accdb

#NP_AC19_6a_FirstLastName_1.accdb
#NP_AC19_6b_FirstLastName_1.accdb
#NP_AC19_7a_FirstLastName_1.accdb
#NP_AC19_7b_FirstLastName_1.accdb
#NP_AC19_8a_FirstLastName_1.accdb
#NP_AC19_8b_FirstLastName_1.accdb
#NP_AC19_9a_FirstLastName_1.accdb
#NP_AC19_9b_FirstLastName_1.accdb
#NP_AC19_10a_FirstLastName_1.accdb
#NP_AC19_10b_FirstLastName_1.accdb
#NP_AC19_11a_FirstLastName_1.accdb
#NP_AC19_11b_FirstLastName_1.accdb
#NP_AC19_12a_FirstLastName_1.accdb
#NP_AC19_12b_FirstLastName_1.accdb
#NP_AC19_1a
#NP_AC19_1b
#NP_AC19_2a
#NP_AC19_2b
#NP_AC19_3a
#NP_AC19_3b
#NP_AC19_4a
#NP_AC19_4b
#NP_AC19_5a
#NP_AC19_5b
#NP_AC19_6a
#NP_AC19_6b
#NP_AC19_7a
#NP_AC19_7b
#NP_AC19_8a
#NP_AC19_8b
#NP_AC19_9a
#NP_AC19_9b
#NP_AC19_10a
#NP_AC19_10b
#NP_AC19_11a
#NP_AC19_11b
#NP_AC19_12a
#NP_AC19_12b

Видео Access Module 1 SAM Project B Ridgedale College | Access Module 1 SAM Project 1b канала Cengage Assignment