Microsoft assignments

Skills Assessment Assessment 1 Creating a Table in Design View; Creating a Lookup Field 1. Begin with 2-NPCGrades-A1-HOA open and enable the content, if necessary. 2. Create a new table in Design view using the following field names: StudentNo;

LastName; FirstName; Grade. Set the data type to Short Text for each field except Grade. At the Grade field, use the Lookup Wizard to create a drop-down list with the following grades: A+, A, B, C, D, F.

3. Restrict the Grade lookup properties to items within the list only and do not allow the values within the list to be edited from the datasheet.

4. Set the StudentNo field as the primary key field. 5. Save the table and name it AC478-01Grades. 6. Enter the following four records in the table in Datasheet view:

StudentNo 111-785-156 StudentNo 118-487-578 LastName Bastow LastName Andre FirstName Maren FirstName Ian Grade A+ Grade C

StudentNo 137-845-746 StudentNo 138-456-749 LastName Knowlton LastName Yiu FirstName Sherri FirstName Terry Grade B Grade D

7. Adjust all column widths to best fit the longest entries.

Marquee Series © Paradigm Publishing, LLC Access 365, 2019 Edition: Section 2, Skills Assessment 1 Hands On Activity