SOC 1500 Lecture Notes - Lecture 3: Unique Key, Microsoft Excel, Microsoft Access

• School: University of Guelph
• Department: Sociology
• Course: SOC 1500
• Professor: Alexander Shvarts

Document Summary

In the following project, you will create tables, queries, and forms. Visual basic, sort reports, and add conditional formatting. For the purpose of grading the project you are required to perform the following tasks: Open the acc_capcatalog. xlsx excel file and delete columns d and g. in the first row, change the column heading from fee to coursefee save and close the file. Create a new art catalog table by importing the excel file acc_capcatalog. xlsx. Catalogid as the primary key with a data type of integer. Save the import steps with the description import catalog excel file. Open the art class sections query query in sql view, change the where clause to return values from > 6/1/2018 instead of > 8/1/2018. Summer and fall art class sections query close the query. Create a delete perspective drawing query that deletes the perspective drawing entries from the art catalog table.