Open access and create a new

/in /by

  

Open Access and create a new database named “5-5 Applicants.”
Create a table named “Applicants” with the following fields: Date, Position, First Name, Last Name, and Phone. Select “Date” as the field type for the Date field. Select “Text” or “Short Text” as the field type for the other fields. Select the Phone field as the primary key.
Enter the following information into the table. Enter the current year in the dates (instead of 20–).
Date Position First Name Last Name Phone
1/3/20– Cashier ***** *****(###) ###-####1/4/20– Stocker Forrest Bayly(###) ###-####1/4/20– Cashier Susan Mcintyre(###) ###-####1/5/20– Manager Barry Gamble(###) ###-####1/5/20– Cashier Joshua Neslund(###) ###-####1/6/20– Stocker Erin Gonzales(###) ###-####1/6/20– Manager Laura Reynolds(###) ###-####1/7/20– Cashier Amy Pederson(###) ###-####1/7/20– Cashier Serena Worcester(###) ###-####1/7/20– Stocker Philip Raymond(###) ###-####1/8/20– Cashier Bryan Crider(###) ###-####1/8/20– Manager Sara Reyes(###) ###-####1/8/20– Stocker Lauren Hurst(###) ###-####1/9/20– Manager ***** *****(###) ###-####1/9/20– Stocker Tom Reitz(###) ###-####1/9/20– Cashier Kelly Tumpane(###) ###-####The owner has asked you to create a list of applicants sorted in ascending order first by the position and then by the last name. Create a query based on the Applicants table. In the query results, display all fields, and sort the data as requested. Save the query as “Position Sort Query.” Run the query and save the results table.