Access, computer questions help

User Generated

gten

Computer Science

Description

See the question in doc file

Unformatted Attachment Preview

1. Open MS Access and create a new blank database. Create a query in MS Access SQL View to CREATE the VENDOR table as outlined below. Run and test the SQL command to be sure it works correctly. You may need to delete the table if you run the command multiple times. Be sure to save the query and give it useful name such as “Create_Vendor_Table”. View the VENDOR table in design view and review each column/field in the table to be sure it is correct (note any differences). Be sure the table has the appropriate PK – V_CODE. Be sure to save the query and give it useful name such as “Create_Vendor_Table”. Table name: VENDOR PK: V_CODE (unique) Constraints: all attributes are required / no nulls Answer the following questions: a. Show (copy and paste) your SQL command code. b. How did MS Access define Char and VarChar data types? c. How did MS Access indicate “no nulls” for a column/field? NOTE: for this question (2) below, you have to answer only (b) red question because I have already answer other questions, however, you may have to answer them in order to answer (b) red question 2. Using the database created in # 1, create queries in MS Access SQL View to INSERT 4 rows/records into the VENDOR table as outlined below. Run and test the SQL command to be sure it works correctly. Be sure to save the query and give it useful name such as “Insert_Vendor_Record_1”. Answer the following questions: a. Show (copy and paste) your SQL command code each of the 4 record inserts. 3. Using the database created in # 1, create queries in MS Access SQL View to UPDATE 1 rows/records into the VENDOR table as outlined below. Run and test the SQL command to be sure it works correctly. Be sure to save the query and give it useful name such as “Update_Vendor_Record”. Change contact and phone number for Vendor 21231 as follows: V_CONTACT = Jonhsten V_PHONE = 828-3687 Answer the following questions: a. Show (copy and paste) your SQL command code for the update. 4. Using the database created in # 1, create queries in MS Access SQL View to DELETE a rows/records from the VENDOR table as outlined below. Run and test the SQL command to be sure it works correctly. Be sure to save the query and give it useful name such as “Update_Vendor_Record”. Delete Vendor 21225. Answer the following questions: a. Show (copy and paste) your SQL command code for the delete. 5. Using the database created in # 1, create queries in MS Access SQL View to SELECT all records in remaining in the VENDOR table (show all columns/fields for all rows/records). Run and test the SQL command to be sure it works correctly. Be sure to save the query and give it useful name such as “Select_All_Vendor_Records”. Answer the following questions: a. Show (copy and paste) your SQL command code for the select. b. Show (copy and paste query result table) showing all VENDOR rows/records. 3- Answer the following questions from 1 to 3. 1. Write a query to count the number of employees with 10 or more years of employment. 2. Write the SQL code to find the average years of employment (EMP_YEARS) for employees in the EMPLOYEE table. 3. Write the SQL code that will produce a listing of employees in the EMPLOYEE table in descending order by the employee years of service (EMP_YEARS). For this question you may need only the last table, however I share other tables in case
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

I hope you like it..In case of any issues, please consult me first

ACCESS ASSIGNMENT
STUDENT NAME:
INSTITUTION NAME:

1.
a. Show (copy and paste) your SQL command code.
VENDOR PK:V_CODE
ATTRIBUTE NAME DATA DECLARATION
NULL
V_NAME
VARCHAR(35)
NOT NULL
V_ORDER
CHAR(1)
NOT NULL
V_PHONE
CHAR(8)
NOT NULL
V_STATE
CHAR(2)
NOT NULL
V_ARAECODE
CHAR(3)
NOT NULL UNIQUE
V_CODE
INTERGER
NOT NULL
V_CONTACT
VARCHAR(15)
NOT NULL

b. How d...


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags