Accomplish the following task using Microsoft access. Create a database called ICOSEP2021. Use the database ICOSEP2021 and
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. 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.
Systems Analysis and Design
ISBN: 978-1133274636
9th Edition
Authors: Shelly Cashman, Gary B. Shelly and Harry J. Rosenblatt