Car Sales R Usin Access Create Two Tables With The Following Informa Car Sales R' Us In Access, create two tables with the following information. The first table is going to store information about types of cars, so name it something like "CarType". In that table, add the following: Field Name, Field Type, Model (key), Short Text; Make, Short Text (Look up Wizard would be better); HorsePower, Number; MPG, Number; Driver Type, Look up Wizard that includes FWD, RWD, and 4WD. The second table will be used for individual inventory, so you can call it "Inventory". This table should include the following: Field Name, Field Type, ID (key), Autonumber; Model, Lookup Wizard using the model column from the CarType table; Color, Lookup Wizard; Mileage, Number; Price, Currency; Automatic Trans, Yes/No; Sold, Yes/No; Extras, Long Text. Once you have set up your two tables, add at least five records to the CarType table. Then add at least 20 records to the Inventory table.
Paper For Above instruction Database Design for Car Dealership Management Introduction Creating an efficient database system for a car dealership involves careful planning and design of tables that capture all relevant data about car types and inventory. Using Microsoft Access, two primary tables are typically designed: one to store static information about car models and their specifications, and another to record individual car units available for sale. This paper explores the conceptualization, design, and implementation of such tables, illustrating how they interrelate and support dealership operations. Design of the CarType Table The CarType table serves as the foundational repository for information pertaining to different categories of vehicles offered by the dealership. It encapsulates attributes that define each car model. The key field in this table is the Model , which uniquely identifies each car type. Other fields encompass essential specifications such as Make