Expert answer:Access 2010
Expert answer:I need help with attached assignment. Thank youI need help with attached assignment. Thank youI need help with attached assignment. Thank youI need help with attached assignment. Thank youI need help with attached assignment. Thank you
access_2010___level_1.pdf
Unformatted Attachment Preview
L E S S O N
6
–
C R E A T I N G
R E P O R T S
Class Project – Employee Database
You are the owner of Rodney’s Video store. Create a new database called “RVS
Employees”
Create a table with includes the following fields: Employee ID, First Name, Last
Name, Address, Home Phone, Cell Phone Social Security Number, Date Hired,
Title, Salary, email address and Department. Be sure to follow naming conventions
when creating your database objects and fields.
Create a form named “frmEmployees” that you can use to enter in employee
information. Enter at least 8 records using your form.
Create a query that only lists employees whose salary is greater than $25,000 (when
entering in your data, make sure to include a couple of records for employees who
fall under the $25,000 salary range). Save and name your query “qryMore_than_25”
Create another query that lists only employees from a particular state (you choose)
and whose salary is greater than $30,000. Name the query something meaningful.
Create an employee report based upon your “qryMore_than_25”. Make any changes
that you feel would improve the appearance of the report. Save the report as
rptMore_than_25.
Create a mailing label report for your employees based upon your employees tables.
Only include relevant fields in your report (i.e. name and address fields). Save your
report as “rptLabels”
© 2010 PCM Courseware, LLC
231
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades