Create a relationship between the aCCap Guides table and the aCCap Customers table using the Guide...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a relationship between the aCCap Guides table and the aCCap Customers table using the Guide ID field as the common field. Enforce Referential Integrity, and Cascade Update Related Records. Close the relationship window, saving changes Design a query to display the customer's First Name, Last Name, Guide ID, and the Availability for all records with a Hobby of Fishing or Hunting. Add the Guide ID field from the aCCap Customers table. Do not display the Hobby field in the results. Run the query, save the query as aCCap OR Query. Close the query. Design a query to display the average Retail Price of the inventory by category. Run the query. Caption the Average column Average Price. Run the query. Apply Best Fit to both columns. Save the query as aCCap Average Query. Close the query. Design a query to update the Retail Price for all Jackets to reflect a 10% discount The new retail price will be 90% of the original price. Save the query as aCCap Update Query. Run the query only once. Close the query. Create a crosstab query using the Query Wizard; select the aCCap Inventory table for the basis. of the crosstab query. Display Sport as the row heading, Category as the column heading, and a count of Item ID. Do not display row sums. Save the query as aCCap Crosstab Query. Close the query. Create a form in Design view based on the aCCap Guides table. In the Detail section, add a tab control at the 0.25-inch mark on the vertical and horizontal rulers. Extend the right edge of the tab control to the 5-inch mark on the horizontal ruler. To the first page of the tab control, add the caption Contact Information. From the Field List, add the First Name, Last Name, Department, Phone, and Email Address fields at the 1.5- inch mark on the horizontal ruler and .75-inch mark on the vertical ruler. Apply a Stacked Layout, and then resize the text boxes so the right edge aligns with the 3.5-inch mark on the horizontal ruler. To the second page of the tab control, add a caption of Availability. Add the Availability and Overnight fields at the 1.5-inch mark on the horizontal ruler and .75-inch mark on the vertical ruler. Apply a Stacked Layout. Start Access, Download and open the file named Student Access aCCap Adventure, Club.accdb Open the aCCap Guides table in Design view. Add a new field between the Last Name and Availability fields, name it Department. Use the Lookup Wizard to create a list that includes four options: Biking, Fishing, Hiking, and Hunting. 4:16 Instructions In the Availability field, set the Validation Rule to WD or WE or ALL and the Validation Text to Entry must be WD for weekdays, WE for weekends, or ALL for both (no period). Add a new field at the bottom of the field list. Name the field Overnight and select a data type that will allow for a yes or no entry. Save the table. Switch to Datasheet view, and update the two new fields for each guide, apply Best Fit to all columns, and then close the table, saving changes. Guide Department Overnight ID GD122 Hunting GD136 Fishing GD148 Biking GD155 Fishing GD167 Hiking GD170 Hunting Yes Yes No No No Yes -2-04 Create a relationship between the aCCap Guides table and the aCCap Customers table using the Guide ID field as the common field. Enforce Referential Integrity, and Cascade Update Related Records. Close the relationship window, saving changes Design a query to display the customer's First Name, Last Name, Guide ID, and the Availability for all records with a Hobby of Fishing or Hunting. Add the Guide ID field from the aCCap Customers table. Do not display the Hobby field in the results. Run the query, save the query as aCCap OR Query. Close the query. Design a query to display the average Retail Price of the inventory by category. Run the query. Caption the Average column Average Price. Run the query. Apply Best Fit to both columns. Save the query as aCCap Average Query. Close the query. Design a query to update the Retail Price for all Jackets to reflect a 10% discount The new retail price will be 90% of the original price. Save the query as aCCap Update Query. Run the query only once. Close the query. Create a crosstab query using the Query Wizard; select the aCCap Inventory table for the basis. of the crosstab query. Display Sport as the row heading, Category as the column heading, and a count of Item ID. Do not display row sums. Save the query as aCCap Crosstab Query. Close the query. Create a form in Design view based on the aCCap Guides table. In the Detail section, add a tab control at the 0.25-inch mark on the vertical and horizontal rulers. Extend the right edge of the tab control to the 5-inch mark on the horizontal ruler. To the first page of the tab control, add the caption Contact Information. From the Field List, add the First Name, Last Name, Department, Phone, and Email Address fields at the 1.5- inch mark on the horizontal ruler and .75-inch mark on the vertical ruler. Apply a Stacked Layout, and then resize the text boxes so the right edge aligns with the 3.5-inch mark on the horizontal ruler. To the second page of the tab control, add a caption of Availability. Add the Availability and Overnight fields at the 1.5-inch mark on the horizontal ruler and .75-inch mark on the vertical ruler. Apply a Stacked Layout. Start Access, Download and open the file named Student Access aCCap Adventure, Club.accdb Open the aCCap Guides table in Design view. Add a new field between the Last Name and Availability fields, name it Department. Use the Lookup Wizard to create a list that includes four options: Biking, Fishing, Hiking, and Hunting. 4:16 Instructions In the Availability field, set the Validation Rule to WD or WE or ALL and the Validation Text to Entry must be WD for weekdays, WE for weekends, or ALL for both (no period). Add a new field at the bottom of the field list. Name the field Overnight and select a data type that will allow for a yes or no entry. Save the table. Switch to Datasheet view, and update the two new fields for each guide, apply Best Fit to all columns, and then close the table, saving changes. Guide Department Overnight ID GD122 Hunting GD136 Fishing GD148 Biking GD155 Fishing GD167 Hiking GD170 Hunting Yes Yes No No No Yes -2-04
Expert Answer:
Related Book For
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen
Posted Date:
Students also viewed these databases questions
-
If Sharon's parents wanted to accumulate an account balance of $17,500 by her 18th birthday, then how much should they have placed on deposit on her first birthday? $6,499 $6,131 $1,750 $10,980 Now...
-
In the last chapter, you modified some tables for Roseys Roses. Now the company would like you to help it create some queries to extract information from the database. Make the following changes...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Suppose a CAP policy was adopted that set allowances for a fixed number of miles driven by each car owner per year. Describe a plan for implementation and trading options.
-
The current in a circuit is tripled by connecting a 500- resistor in parallel with the resistance of the circuit. Determine the resistance of the circuit in the absence of the 500- resistor.
-
The St. Charles streetcar in New Orleans starts from rest and has a constant acceleration of 1.20 m/s2 for 12.0 s. (a) Draw a graph of vx versus t. (b) How far has the train traveled at the end of...
-
With reference to the preceding exercise, find the marginal densities of the two random variables. Data From Preceding Exercise Determining a joint cumulative distribution function Find the joint...
-
Imagen Arquitectonica of Tijuana, Mexico, is contemplating a major change in its cost structure. Currently, all of its drafting work is performed by skilled draftsmen. Alfredo Ayala, Imagens owner,...
-
1. Frank was director of research-development (R&D) for a large pharmaceutical company. The following memorable incident is related to his name: During a research project the mebers of the team...
-
The XYZ Manufacturing Company produces two products, S-101 and C-110. You have obtained the following information regarding the annual manufacturing support (i.e., factory overhead) costs associated...
-
According to the latest survey published last December 2021 by Social Weather Station or SWS, 69% of Filipinos believe that the problem of fake news in media is serious. Through an article with your...
-
In government financial reporting, operating statements are crucial components that provide insights into an entity s financial health and performance. Conduct research into the role and significance...
-
Problem 1 (30 minutes) You are examining the financial statements of Salazar Company for the year ended December 31, 2022. Your audit of the accounts receivable and other related accounts disclosed...
-
AT & T company was depreciating its antennas over 2 0 years. The total cost of the antennas accounted for 2 0 million dollars. It was recently discovered that the antennas useful life is only seven...
-
1 . James Co . was paid $ 4 , 5 0 0 in advance on the first day of the month for 6 months of accounting services to be performed regularly throughout the 6 - month period. At the end of the month,...
-
ABC decided to form a limited liability company ( taxed as a partnership ) . Bob and Rob will each own 5 0 % of the outstanding units, and both will provide services to the LLC as managing members....
-
A boy buys 18 sharpners, (Brown/white) for Rs.100. For every white sharpener, he pays one rupee more than the brown sharpener. What is the cost of white sharpener and how much did he buy? a) 5, 13 b)...
-
An annual report of The Campbell Soup Company reported on its income statement $2.4 million as equity in earnings of affiliates. Journalize the entry that Campbell would have made to record this...
-
Are headers and footers also a part of the record source?
-
Create additional select queries for What SUP using computed fields. (Use the Ch11-02 student file, or use the file you used in answering the previous question.) a. Create and print a select query...
-
What do the [ ] (brackets) signify in an Access formula?
-
Kinney A.. had the following assets and liabilities on the dates indicated. Kinney began business on January 1, 2024, with an investment of 100,000. Instructions From an analysis of the change in...
-
Two items are omitted from each of the following summaries of statement of financial position and income statement data for two proprietorships for the year 2025, Greenes Goods and Solar Enterprises....
-
Listed below are some items found in the financial statements of Min-Seo Promotions. Indicate in which financial statement(s) the following items would appear. a. Service revenue. b. Equipment. c....
Study smarter with the SolutionInn App