Question 4 15 Marks 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 relationship may occur The tables should be populated with a set of 6 records 5 Marks Query the tables to display the vehicles supplied by a particular supplier(Dealer) 2 Marks 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 2 Marks Design a form using 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

The Answer is in the image, click to view ...

Question: Question 4 [15 Marks] Accomplish the following task using Microsoft access. Create a database called ICOSEP2021. Use the database ICOSEP2021 and create the following tables

Question 4 [15 Marks]

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 relationship may occur. The tables should be populated with a set of 6 records. [5 Marks]
Query the tables to display the vehicles supplied by a particular supplier(Dealer) [2 Marks]
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 [2 Marks]

Design a form using 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

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

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

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Under our current conditions, your company now requires that all employees have their vaccination status documented. Although most people would just put together an Excel spreadsheet, you know...

About the Database You have just been contacted by a small business called EasyRentals, which leases customers handheld tools and small machinery for small and medium - sized projects such as home...

4 . Add data to the tables with at least: ( 4 marks ) 1 0 products 3 suppliers 6 Sales Reps ( including your instructor and each member of your team ) 1 0 customers 5 . Create forms and sub - forms...

You are just contacted by a small business called EasyRentals which leases handheld tools and small machinery to customers for small and medium-sized projects such as home renovation, basement...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

1. Casel Ivana's Ice Cream just finished its first six months of manufacturing and selling ice cream. The company has two main product lines, Ice cream cups and ice cream bars, both of which are...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Determine the theoretical and actual material required to produce the part, shown in figure. Raw stock is supplied in 0.875 in. diameter. A lathe cutoff tool width is 0 125 in. A 0.015 in. stock...

What is the essence of human nature ?

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Explain the aims of the selection process and the importance of talent selection.

Explain what is meant by the terms unitarism and pluralism.

Assess the value of references and understand the circumstances where they may be successful.