Please see attachedIntroduction
In this assignment you will learn about joining tables together to increase the power of the
If two tables have a relationship between them, a join will connect the data in the tables.
For this exercise you will work in a sample car dealership database that tracks customers,
salespeople, vehicles, and sales.
Step 1: Preparing for the assignment.
Your first task is to download the base database file from ANGEL. This file is called MIS 204
HOA11 Base Customer Database for Windows.
Download the file to some location that you will
Once downloaded, open the file.
Step 2: Reviewing the database.
This database is relatively simple in its current form.
There are four tables in the database:
CUSTOMERS, SALES, SALESPEOPLE, and VEHICLES.
The tables contain the following:
first name, last name, and id data for customers.
a sales id, the employee id of the salesperson involved in the transaction, the
customer id of the customer involved in the transaction, and the vehicle id of the vehicle
sold in the transaction.
first name, last name, id, and commission rate data for sales personnel.
id, make, model, and price data for vehicles in the dealership’s inventory.
Open each table and look around to familiarize yourself with the data but do not make any
changes at this time.
Step 3: Creating relationships between the tables.
In order to be able to join data in a database, tables must have relationships between them.
Otherwise, each table represents a discrete entity with no connection to any other entity in the
ACCESS provides tools to create relationships between tables.
Click on the Database Tools tab on the ribbon.
Double Click on Relationships.
A dialog box will open asking you which tables you want to
This question was answered on: May 23, 2022
This attachment is locked
Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)
May 23, 2022EXPERT
We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.
You can also use these solutions: