13.10: Chapter Review - Practice Exercises
-
- Last updated
- Save as PDF
Practice Exercises
Build a simple database and create a query that joins information. You are currently working with information about the sales and marketing team. You want to keep track of the team members and the regions they work with. Set up a database with the following tables (remember, you would separate this data into at least two tables to make the database more efficient and easy to work with):
Table:TeamMemberTMID
TMFirstName
TMLastName
TMPhone
TMEmail
Table:SalesRegion
SalesRegionName
SalesRegionNotes
Table:SalesRecord
TMID
SalesRegion
Once you have set up the tables, create a query that returns the team member’s first and last names and the sales region they are assigned to. Add any fields you think are necessary to create a list of team members’ names with their region. You may want to try sorting to improve the query output.
Table: EMPLInfo
EmplID
EmplFirstName
EmplLastName
EmplAddress
EmplCity
EmplState
EmplZip
Table: EMPLLearning
EmplID
TrainingName
TrainingDate
Importing records is an important function when working with a database like Access. Complete the following steps to create a database from scratch:
- Create a blank database using Access and then import the colors.csv file from the LEGO Database found on Kaggle.
-
Then use your navigation buttons to do the following:
-
Add a record with the values:
ID: 2000
Name: Vivid burgundy
RGBN: 990033
is_trans: f - Modify the record to say “dragon-scale burgundy.”
- Delete the record.
- Undo the change.
-
Add a record with the values:
The WorldCorp Human Resources Department has asked you to create reports to support the following inquiries using the Human Resources Data Set from the Kaggle website. Before creating the reports, look at the type of data available and decide what data needs to be included or omitted. Which fields should be considered to answer these inquiries?
- Which employees have high performance scores? Low performance scores?
- Which departments are currently the most diverse?
- How has the company acquired its most diverse employees to date?
- Is pay equitable across all divisions and positions in the company?
- Evaluating employee performance (including attendance and lateness)
- Understanding employee roles (including position, department, location)
- Reviewing employee hiring information (including recruitment and position)