Question: Accomplish the following task using Microsoft access. Create a database called ICOSEP2021. Use the database ICOSEP2021 and create the following tables PartsDetails, VehicleDetails, and SupplierDetails.

Accomplish the following task using Microsoft access. Create a database called ICOSEP2021. Use the database ICOSEP2021 and create the following tables PartsDetails, VehicleDetails, and SupplierDetails. Make use of primary keys and enforce referential integrity where relationships may occur. The tables should be populated with a set of 6 records.

Query the tables to display the vehicles supplied by a particular supplier(Dealer)

Design a query that displayed all vehicles that has a tag price of less or equal to BWP 65 000 and the year of manufacture is less than the year 2019.

Design a form using the SupplierDetails table to insert more records and also include the navigation buttons to do the following: To save the record, move to the next record, move to the previous record, and close the form. Save the form as SupplierForm.

Step by Step Solution

★★★★★

3.49 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a reate Database ICO SEP2621 Use this Database and create followmy tables Parts Details Vehicl... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The following figure shows a Microsoft Access query design screen for a employee query. Use information provided on this figure to answer the following questions: 1. How many tables are used in this...

Use Microsoft Access or similar database software to create a DBMS for the imaginary company called Top-Text Publishing, which is described in Case In Point 9.1 on page 410. Add several sample...

Use Microsoft Access or similar database software to create a DBMS for the imaginary company called TopText Publishing, which is described in Case In Point 9.1 on page 365. Add several sample records...

In Chapter 9 you created a database for Kelly's Boutique consisting of a Book table, a Department table, and a Publisher table. You also created an initial form, query, and report. Kelly would now...

This chapter described how to create tables and records in Microsoft Access. What other database management systems are available? Use the Internet to determine their current retail prices.

North Beach College was founded as a small, liberal arts school just three years ago. Since that time, the institution has grown to the point where parking on campus is difcult and parking in illegal...

This case involves creating a database from an integrated REA diagram and then using the REA diagram to guide the writing of queries to prepare financial statements. Required a. Create the tables...

Change the structure of the Coast Jewelers database a. Add the following product to the Product table. Product ID: 11; Name: Pearl Necklace; Description: "A 14K gold 18 inch cable chain holds a...

In Chapter 9 you created a database for the Wine Depot consisting of a Wine Products table, a Winery table, and a Buyer table. You also created an initial query, form, and report. Barbara has now...

Marcia Wilson owns and operates Marcia's Dry Cleaning, which is an upscale dry cleaner in a well-to-do suburban neighborhood. Marcia makes her business stand out from the competition by providing...

Suppose that the demand and supply of liter of petrol are given in table 1 below: Price (RM) Quantity demanded (liter per day) Quantity supplied (liter per day) 0.80 8 24 0.75 10 22 0.70 12 20 0.65...

Morgan's Selling Price 135 Process 1 Process 2 Fixed Cost 110,000 45,000 Variable Cost. 40 100 Labor Hours / unit 4 10 Suppose that Morgan is going to produce at 1300 units and would choose Process...

From the movie Everest, Guide Rob Hall attempts to help his client, Beck Weathers, get across a chasm. Based on "Leading in Times of Uncertainty, analyze the extent to which this scene reflects...

3. The book uses 4 synonyms for the average of the outcome if you played a game over and over. The four synonyms are? 1. Variance 2. Semivariance 3. Systematic distributions 4. Asystematic...

An athlete runs a marathon, after which his muscles feel fatigued and unable to contract. The athlete asks the nurse why this happened. The nurse's response is based on the knowledge that the problem...

The Self - Appraisal Problem Leroy Washington, human resource director at Engel Products was faced with a problem that he had not experienced before and was uncertain how to proceed. The problem was...

How do you assess changes in affordability of housing over the last 20+ years? What factor has contributed most to the change?

Organizations are increasing their use of personality tests to screen job applicants. What are some of the advantages and disadvantages of this approach? What can managers do to avoid some of the...

Your MultiTech interview seemed to go well, but you did not get the job. During the meeting, the interviewer mentioned that MultiTech uses structured analysis and relies heavily on modeling,...

What are forward and reverse engineering tools, and how are they used?

Your supervisor, Jesse Baker, has asked you to begin working on data design tasks for the new information system, which will be implemented as a relational database. You will need to identify the...

A manufacturing company buys a certain part in varying quantities throughout the year. Ordering cost is $ 11 per order, and holding cost is $0.14 per piece per month. Given the following demand (net...

Information concerning the product structure , lead times, end quantities on hand for an electric golf cert is shown in the following table. Use this information to do each of the following: a....

Refer to Problem 12. Assume drat unusually mild weather has caused a change in the quantity and timing of orders for golf carts. The revised plan calls for 100 golf carts at the start of week 6, 100...