Reference no: EM131830191
Question: In this project, you will be working with the pet store database from Chapter 3, Fix It 3.6. The store is currently having trouble with some queries. Find and fix its problems. Be sure to save the database objects after you make changes.
Skills needed to complete this project:
• Using a Parameter Query
• Adding a Calculated Field to a Query
• Hiding and Showing Fields in a Query
• Adding Numeric and Date Criteria to a Query
• Specifying the Sort Order in a Query
• Adding Text Criteria to a Query
• Using AND in a Query
• Using OR in a Query
• Combining AND and OR in a Query
• Importing Data from Excel
IMPORTANT: Download the resource file needed for this project from the Resources link. Be sure to extract the file after downloading the resources zipped folder. Please visit SIMnet Instant Help for step-by-step instructions.
1. Open the start file AC2016-FixIt-4-6.
2. If the database opens in Protected View, click the Enable Editing button in the Message Bar at the top of the database so you can modify it.
3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
4. The CustomersByPhone query is not working properly. Fix it so when this query is run, it prompts the user to enter a phone number in order to find a particular customer. Use the prompt: Enter customer phone number
5. Fix the FeeIncrease query to correctly display a calculated field that increases the pet adoption fees by 10 percent and hides the original adoption fee. Change the name of the calculated field to: NewFee
6. The OlderDogAdoptions query has several problems. Fix it so it correctly displays only dogs that are at least four months of age. Sort the results by pet age from the youngest to the oldest.
7. Fix the Customers-W&B query so only customers whose last names begin with a W or a B appear in the query results.
8. A previous volunteer kept the employee list in an Excel spreadsheet. Import the data from the Staff Excel spreadsheet into a new table named: Staff
The Excel file is located with the data files for this project.
a. The first row of the Excel file contains column headings.
b. The HourlyRate field should be imported using the Currency data type.
A Skills Approach: Access 2016 Chapter 4: Using Queries and Organizing Information
c. The table should use the StaffID field as the primary key.
d. The imported table should be named: Staff
9. Close the database and exit Access.
10. Upload and save the project file.
11. Submit project for grading.
Information related to above question is enclosed below:
Attachment:- U.Weng-AC2016-FixIt-4-6.accdb.rar
What is the minimum annual payment that you would accept
: Someone offers to buy your car for four, equal annual payments, beginning 2 years from today. what is the minimum annual payment that you would accept?
|
Generating function of some standard distributions
: Compute the moment generating function of some standard distributions, such as the binomial, geometric, Poisson, exponential, gamma, uniform
|
How much in passive losses can spencer deduct
: Spencer has an ownership interest in three passive activities. How much in passive losses can Spencer deduct
|
Find the mean and variance of the binomial
: Find the mean and variance of the binomial, Poisson, uniform, exponential, and standard normal distributions.
|
Complete the project using given information
: In this project, you will be working with the pet store database from Chapter 3, Fix It 3.6. The store is currently having trouble with some queries.
|
Find the mean and variance of the binomial
: Find the mean and variance of the binomial, Poisson, uniform, exponential, and standard normal distributions.
|
Explain in detail how a risk manager can make optimal use
: Explain in detail how a risk manager can make optimal use of insurance as part of an overall risk management strategy.
|
Lacking a moment generating function
: Check that these distributions have the desired property (that is, of lacking a moment generating function).
|
What is alice adjusted gross income for the current year
: Alice is an attorney and earned $175,000 from her practice in the current year. What is Alice's adjusted gross income for the current year
|