Access Unit Test Answers
Mr. Johnson, the FBLA adviser, is updating the membership database table for the new school year. He wants to define the fields to display and simplify the interface by adding labels and instructions. He would use a:
form.
Susie has a relational database for her catering business. She wants to create a form which shows the data in a customer table one record at a time. This type of form is a:
main form.
Marci has a database of all the planets. She needs to know what planets have moons or rings. Which comparison operator would she use to perform the query?
moons or rings
Where is the command for creating a new table from Table Design view?
Create Ribbon
Dennis needs to format his sales amount column to show dollar signs. Which format would he use?
Currency
Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Ashton to add a footer?
Design View
Riley is using Microsoft Access to collect data for a science project. He is creating a form and wants to apply predefined color and font scheme formats. Which Form Layout Tools contextual tabs should he select for the theme group?
Design tab
Maria needs to share a form from her database to other members of her work team, but she is not sure everyone has Microsoft Access. In which file format should she save the form to ensure everyone can read the information?
Either PDF or XPS
John wants to create a query that will display the total number of hamburger patties in stock at two different locations. The results should display the sum of the values from each location. Which solution should John use for his query?
Expression Builder
When saving a Microsoft Access database as another file type, which ribbon contains an area of centralized tasks that are related to file management known as the backstage?
File tab
Kori wants to know how many students in FBLA are seniors, but does not want to save the information. Which operation would she perform?
Filter
Michelle needs a list of senior National Technical Honor Society members so she can order their tassels for graduation. Which tool would be best to identify only the seniors?
Filter
Eddie needs to search for the specific employee that lives on 225 Mayberry Lane. What command would he use?
Find
Mr. Smith needs to know Jenny's address. Which command would he use?
Find
Dennis needs to format the numbers in his database to three decimal places. Which number format would he use?
Fixed
Kevin created a form to input FBLA membership data. He needs to change the background color of the form so that it displays correctly on mobile devices. Which option provides the tools Kevin will need to modify the form?
Form Design
Jeremy needs to create a quick form based on a single table in his baseball card database. Which option will automatically include all the fields from a single table?
Form Tool
Linda wants to ensure birth dates are entered as MM/DD/YYYY. Which field property will be used?
Format
Jenny is entering data to the medication field in the patient database and needs to constantly view patient ID numbers to input this information. What should she do?
Freeze Fields
Mrs. Wilson needs to create a report that lists students by their homeroom teacher. Each teacher needs a separate list for attendance. Which option would allow Mrs. Wilson to put students together by homeroom on separate sections of the report?
Grouping
Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database?
Navigation Pane
Curt needs to finish a database project from yesterday. What action should he take in order to start working on the database?
Open
Mary needs to export the table of FBLA members from the Southeast Region database to a document that does not allow editing. Which format should she use?
Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields?
Provide a caption
Beth needs to determine the seniors with a GPA of 4.0 or higher. Which object would allow her to create a saved search to find this information in the database?
Query
Which type of database consists of a collection of tables, each of which contains information on a specific subject?
Relational
Keisha wants to print her completed music databases. Which tool would she use?
Report
Margaret wants to send an address change to all the customers in her current database. She wants to create address labels to accomplish this. Which would she use?
Report
Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report?
Report Layout Tools Arrange
Rachel has spent a lot of time creating a membership database for her FBLA chapter, which she has been asked to share with other chapters in her region as an example. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms?
Save as Database Template
Taylor wants to query the airline database to find out how many seats are open on Flight 33. What type of query would she use?
Simple Query
Eddie works for ABC Finance. He needs to view which employee has the lowest sales for the month. Which command should he use?
Sort Ascending
Helen is creating a form to gather important information about graduation requirements from her senior homeroom students. What tool would she use to ensure that the sequence in navigating the form fields so data is entered in the order she wants?
Tab Order
Isabel wants to design a database for her FBLA club to include all of the member information. What data type should she use for Last Name?
Text
Jenny is setting the addresses for each patient. Which data type should she use?
Text
Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use?
Unbound
Keton wants to add a graphic by one of the fields on his form. Which type of control will he add to the form?
Unbound
Asiah has created a senior information form from her student table. She wants the parent's home phone text box to have the exact same width as the cell phone text box. What tool would she use to ensure they are exactly the same?
View Code Add
Juan needs to view and access all parts of his database. Where can these objects be located most efficiently?
Navigation Pane
Delores is doing a search of the bed and breakfasts in Southport, NC. She wants to know which bed and breakfast is less than one mile from the waterfront and allows pets. Which comparison operator would she use?
<>
Cathy needs to duplicate a column that is used in her spring sports table in the athletic database for a new form she is creating for fall sports. Which item from the tools group would enable her to perform this operation?
Add Existing Fields
What type of query enables a user to add the results of a query to an existing table in a database?
Append
Frank needs an estimated number of services his company performs each month. Using a calculated field, which total function would he use to answer his question?
Average
What term describes the process of repairing and removing wasted space from a database?
Compacting
Which type of operator enables a user to compare two values in a query criterion?
Comparison
Dillan wants to ensure social security numbers are entered in a proper format. Which field property will be used?
Input Mask
Ashawn has created a table from his database to see his company's income and expenses for the year and now would like to see the totals for each category. Which table feature should he use?
Insert a Totals Row
Amanda wants to ensure there are only two characters for the state abbreviation. What should she do?
Limit field size
Which type of field enables a user to select from a list of values when updating the contents of a field?
Lookup
Sally is the National Technical Honor Society president. She is creating a database to manage her membership information. What form tool could she use to quickly create a set of tabs a user could click to access forms and reports in the database?
Navigation Form
