new perspectives microsoft office 365 & excel 2019 comprehensive ebook

The Student table you created has the same design as the MoreStudents table.

Jeremiah created a database named Support_AC_1_Records.accdb that contains a MoreStudents table with additional student data. Enter the records shown in Figure 1–40 into the Student table.ġ4. Use the Navigation Pane to open the Student table.ġ3. Save the table as Registration and close the table.ġ2. Add the final field called PaymentPlan to the table. Add the following two fields to the table in the following order: TotalCost and BalanceDue. Use Foreign key as the descriptions for the StudentID and InstanceID fields.ĩ. Make SignupID the primary key and use Primary key as its description. In Design view, begin creating a second table containing the following three Short Text fields in the following order: SignupID, StudentID, and InstanceID.Ĩ. Save the table as Student and close the table.ħ. Add a final field called Assessment to the table, which is of the Yes/No data type.Ħ. Add a field called BirthDate to the table, which is of the Date/Time data type.ĥ. Resize the columns as necessary so that the complete field names are displayed.Ĥ. Add the following eight fields to the new table in the order shown all of them are Short Text fields: FirstName, LastName, Address, City, State, Zip, Phone, and Email.

Change the data type of the StudentID field to Short Text.ģ. Rename the default ID primary key field to StudentID.

In Datasheet view, begin creating a table. Create a new, blank database named Career and save it in the folder where you are storing your files, as specified by your instructor.Ģ. He needs your help in creating this database. Jeremiah wants to use Access to maintain information about the courses offered by Great Giraffe, the students who enroll at the school, and the payment information for students. Great Giraffe offers part-time and full-time courses in areas of study that are in high demand by industries in the area, including data science, digital marketing, and bookkeeping. Great Giraffe Jeremiah Garver is the operations manager at Great Giraffe, a career school in Denver, Colorado. Data File needed for this Case Problem: Support_AC_1_Records.accdb

New perspectives microsoft office 365 & excel 2019 comprehensive ebook