MKTG 3880-001 Computer Project – ACCESS Due Date: December 10. 2020
Part A: Create an Access database using the sample data and questions.
Part B Create your group Access database and retrieve the information using the Access query function based on the database created
Sample data and questions:
1. Create a data for ATY Company – AT Y accdb
a. Create a personal data file of ATY Company.
b. Create an index using the strlD field that does not allow “duplicate’.
c. Create a resource data file of A TV Company.
d. Create a product data file of ATY Company.
1. Print the personal data file of ATY Company.
2. Print the resource data file of ATY Company.
3. Print the product data file of ATY Company.
4. Sort the personal data file alphabetically by last name (in Ascending order) and print it.
5. Retrieve all of the ATY company employees’ EPID. first name, hiring date using the personal data file. Then print it.
6. Query all of the ATY sales representatives’ EPID, last name, address. Hours per week.
Pay Rate, and Product Code Compute their gross pay and change the text Expr 1 in the concatenated field to “Gross Pay”.
1. Retrieve the information of all sales representatives who handle RDI 00 with their pay- rate.
2. Retrieve the information of all sales representatives who cam more than $900 dollars per week their EPID, last name, first name, and Hours per week.
3. Query all sales representatives whose gross pay is greater than $1200 dollars and prim it.
4. Retrieve the information of MK sales representatives who work 20 hour*;