Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / Prior to opening your Access file, you will need to go to the file properties and unblock the file to allow you to work in it
Prior to opening your Access file, you will need to go to the file properties and unblock the file to allow you to work in it. Open the Access and Excel file attached. Open the Employee Data table in Access and ensure the fields match the column headers in Excel. Import the Excel file to fill out the Employee Data table. Ensure that you have an Employee ID automatically assigned to current and new employees. Make the First name, Last name, and Hire Date required fields on the table. Add a rule so that only Ratings between A-E can be added. Use your discretion when adding the text that is displayed when the rule is triggered. Change the text length of the Job Title field to match the maximum character length. Build a Mini Table for Location on the Employee Data table. On the Warehouse Activity Table, create calculated fields for Cost per Unit and Profit. Add a Notes field to Warehouse Activity. Ensure the formatting is correct for the field. Make Ajax the default value for the Distribution Centre field. Add conditional formatting to the Quantity field to highlight orders with less than 5000 quantity as the criteria. Change the formatting of the Quantity field to ensure the numbers are easier to read. Build a Form for Warehouse Activity that uses all the fields available. Include a Header and Footer that has the Company name, Company logo, and "Created By [your name]". Add Buttons on your Form to navigate to the next and previous record, to save a record, to close the form, and to run a Query. Create 3 Queries that represent realistic criteria. Each query must have at least 3 different fields. The queries can be for either Master Table. Ensure all your tables are closed and save your file as Access Exercise_[First and Last name].
