access
Keton created a customer information form from his customer table. He realizes he left the e-mail address off the form. What tool would he use to add the e-mail address to the existing form? A. Tab Order B. Add Existing Fields C. View Code D. Property Sheet
Add Existing Fields
Which is not a file type that may be imported into Microsoft Access? A. Text files (TXT) B. HTML files (HTM or HTML) C. Microsoft Publisher files (PUB) D. Microsoft Excel files (XSLX)
Microsoft Publisher files (PUB)
Mary needs to export the tables of FBLA members from the Southeast Region database to a document that does not allow editing. Which format should she use? A. DOC B. PDF C. RTF D. TXT
Aaron needs to duplicate a field that is used in his customer table in the business database for a new form he is creating for entering customer orders. Which item from the tools group would enable him to perform this operation? A. Tab Order B. Add Existing Fields C. View Code D. Property Sheet
add existing fields
Donna's Bakery lost a customer named Dingin' Donuts. What action should be taken to remobe all records fromher databse for Dingin' Donuts? A. Delete query B. Update query C. Append query D. Make table query
delete query
Chad needs to remove a student from the FBLA database. Which option should he choose? A. Add New Record B. Delete Record C. Move Field D. Edit Record
delete record
Which file type places each record on a separate line and uses a special character to separate fields? A. Bound B. Defined C. Delimited D. Isolated
delimited
Nick wants to make notes for future users of his database so they will properly use the field names and types. Wher would he make these notes? A. Data Type B. Description C. Field Name D. Properties
description
Which view displays the area used to create a table or to modify the structure of a table? A. Design B. Datasheet C. File D. Backstage
design
Mr. Brown's report needs to be arranged by last name and first name. What tool can he use to ensure that students appeart in alphaberical order on his report? A. Sort B. Filter C. Conditional Formatting D. Grouping
sort
Eddie works for ABC Finance. He needs to view which employee has the lowest sales for the month. Which command should he use? A. Filter B. Find C. Sort Ascending D. Sort Descending
sort ascending
Eddie works for ABC Finance. He needs to view which employee has the highest sales for the month. Which command should he use? A. Filter B. Find C. Sort Ascending D. Sort Descending
sort descending
What ensures that a query result appears in a specific order? A. Filtering B. Sorting C. Ordering D. Placing
sorting
When a database is created, what is defined when names and data types are assigned to all data fields in a table? A. Structure B. Definition C. Design D. Theme
structure
Sam enters a numeric criterion in a query to find out which UNC schools habe an enrollemtn that equals 5000 or greater. What would he enter? A. ='5000' B. 5000 C. '<5000' D. =>'5000'
=>'5000'
The athletic director is looking for swim team purchase orders that are more than $200. What criteria would give her this information? A. >=200 AND Swimming B. >200 OR Swimming C. >=200 OR Swimming D. >200 AND Swimming
>200 AND Swimming
What are three valid methods for saving a database in Microsoft Access? A. Alt + S, File tab Save Command, Quick Access Toolbar Save Command B. Alt + S, Home Ribbon Save command, Quick Access Save command C. Alt + S, File tab Save command, Shortcut Save command D. Ctrl + S, File tab Save command, Quick Access Save command
Ctrl + S, File tab Save command, Quick Access Save command
In Datasheet view, how does a user delete a record? A. Double-click the record B. Select the record and choose Delete from the Create Ribbon C. Double-Click the record and choose Delete from the Database Tools Ribbon D. Select the record and choose Delete from the Home RIbbon
Select the record and choose Delete from the Home Ribbon
Asiah has created a senior information form fro her student table. She wants the parent's home phone text box to ave the exact same width as the cell phone text box. What tool would she use to ensure they are exactly the same? A. Tab Order B. View Code C. Add Existing Fields D. Property Sheet
View Code
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? A. Tab Order B. Add Existing Fields C. View Code D. Property Sheet
add existing fields
Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records? A. Statistical B. Geometric C. Aggregate D. Algebraic
aggregate
Marci is searching a Planet Database. She wants to find out how many moons Saturn has and the names. Which comparison operator would she use? A. and B. equal C. not D. or
and
What type of query enables a user to add the results of a query to an existing table in a database? A. Update B. Append C. Action D. Make table
append
Matt needs to add his contact to the Driver Education database. To do this quickly, what predefined object can he create? A. Application Parts B. Quick Start C. Sharepoint List D. Database Object
application parts
Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. hat data type should he use? A. Auto Number B. Currency C. Yes/No D. Hyperlink
auto number
Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know the mean number of active members in the region. Which aggregate functions should she use? A. Count B. Max C. Min D. Average
average
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? A. Average B. Count C. Max D. Sum
average
Juan is creating a chart that graphs attendance of FBLA Leadership conferences from the past five years, which he has in a database. He wants to remove the y-axis value. Which tab in Chart Options would he select? A. Titles B. Axes C. Data labels D. Legend
axes
Amy would like to quickly create a form in layout view so that she can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the form's appearance while displaying the data? A. Blank Form B. Form Design C. Form Wizard D. Form Tool
blank form
Barney would like to create a report in layout view so that he can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the report's appearance while displaying the data? A. Report B. Report Design C. Blank Report D. Report Wizard
blank report
Preston's form needs to display the tax on an order. Which type of control would allow Preston to display information that would change every day? A. Bound B. Unbound C. Button D. Calculated
calculated
Terry's form needs to display the FBLA member's exact age based on today's date and member date of birth. Which type of control would allow Terry to display information that would change every day? A. Bound B. Unbound C. Button D. Calculated
calculated
Individual entries in the FBLA address book would be entered into a: A. cell B. database C. field D. record
cell
Michelle used the property sheet to customize her form in Microsoft Access. Ehich task can she complete? A. Change the background and add captions. B. Enter a new record. C. Move data. D. Switch from Design View to Print Preview.
change the background and add captions
Curt needs to exit his database in order to work on another database. What action should he take after saving his work? A. Close B. Create New C. Open from Exisiting D. Save As
close
What term describes the process of repairing and removing wasted space from a database? A. Recovery B. Backing up C. Installation D. Compacting
compacting
Which type of operator enables a user to compare two vales in a query criterion? A. Assessment B. Evaluation C. Comparison D. Appraisal
comparison
Ashawn has created a table from his databse to know the number of products currently available for sale in his spring catalog. Which aggregate function should he use? A. Count B. Max C. Min D. Average
count
Frank needs to know the number of service calls he has received from 123 Walnut Street in one week. Using a calculated field, which total function would he use to answer this question? A. Average B. Count C. Max D. Sum
count
Where is the command for creating a new table from Table Design view? A. File Tab B. Home Ribbon C. Create Ribbon D. Database Tools Ribbon
create ribbon
The manager of Doggie Donuts needs to group inventory by types of dog food in stock. He needs a subtotal for each group. Which query action will display this information? A. Select query B. Delete query C. Crosstab query D. Append query
crosstab query
Dennis needs to format his sales amount column to show dollar signs. Which format would he use? A. Currency B. Fixed C. General Number D. Text
currency
Juan is creating a chart which graphs attendance at FBLA State Leadership conferences from the past five years which he has in a database. He wants to show individual data values. Which tab in Chart Options would he select? A. Titles B. Axes C. Data labels D. Legend
data labels
Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What is auto numbering an example of? A. Data Type B. Description C. Field Name D. Properties
data type
An address book containing all FBLA members would be an example of a: A. cell B. database C. field D. record
database
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? A. Design tab B. Format tab C. Arrange tab D. Page Setup tab
design tab
Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Ashton to add a footer? A. Form View B. Layout View C. Design VIew D. Navigation Pane
design view
Erin needs to prepare a custom table for her recipe collection. She has to include the ingredient portions. Which is the correct tool to use? A. Design View B. Template C. Sharepoint List D. Application Parts
design view
Juan is creating a new database. He wants to assign field names. Which view is best to create the new database? A. Design View B. Form View C. Layout View D. Navigation Pane
design view
Tanya created a report to show people signed up for a 5K race. She needs to increase the size of the report header so she can add the race logo control. Which view will allow her to resize the header? A. Report View B. Print Preview C. Design View D. Layout View
design view
Chad needs to change a members telephone number in the FBLA database. What step should he take? A. Add New Record B. Delete Record C. Move Field D. Edit Record
edit record
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? A. PDF B. XPS C. Either PDF or XPS D. DOC
either PDF or XPS
What is the process of transferring data from an Microsoft Access database for use in another application called? A. Exporting B. Importing C. Pasting D. Distributing
exporting
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? A. Crosstab Query B. Expression Builder C. Simple Query D. Totals
expression builder
You have been asked to develop an address book for the FBLA members. Last name and first name would be examples of: A. cells B. databases C. fields D. records
fields
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? A. Home ribbon B. File tab C. External Data ribbon D. Database Tools ribbon
file tab
Hank wants to add color to the header section of his form. Which formatting option would he use? A. Fill Color B. Font Size C. Font Color D. Format Painter
fill color
Eddie needs to know which employee(s) work(s) in the Southeast District. Which command would he use? A. Filter B. Find C. Sort Ascending D. Sort Descending
filter
Kori wants to know how many students in FBLA are seniors, but does not want o save the information. Which operation would she perform? A. Filter B. Find C. Query D. Sort
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? A. Form B. Filter C. Controls D. Theme
filter
Keisha created a database of her music. She wants to locate only the songs by Beyonce. What tool should she use in order to view this information without saving? A. Filters B. Form C. Query D. Report
filters
Eddie needs to search for the specific employee that lives on 225 Mayberry Lane. What command would he use? A. Filter B. Find C. Sort Ascending D. Sort Descending
find
Mr. Smith needs to know Jenny's address. Which command would he use? A. Find B. Select C. Sort Ascending D. Sort Descending
find
Dennis needs to format the numbers in his database to three decimal places. Which number format would he use? A. Currency B. Fixed C. General Number D. Text
fixed
The report Jamie created has a dark background and the page number is not displaying correctly. Which formatting option would he apply to the page number to add contrast between the background and the page number? A. Fill Color B. Font Size C. Font Color D. Format Painter
font color
Michelle needs each Nation Technical Honors Society member to complete an information sheet. Which tool would be best? A. Form B. Filter C. Controls D. Theme
form
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: A. form. B. table. C. report. D. query.
form
Tyler is using Microsoft Access for a class assignment. Which database object would she use to enter one record at a time? A. Table B. Form C. Macro D. Report
form
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? A. Blank Form B. Form Design C. Form Wizard D. Form Tool
form design
The owner of Ima Graphic Animator, Inc., a grphic desing company, wants to quickly create a new blank databse object, onw hcih includes one record at a time and a more detailed view of the structure. Which design should be used? A. Table Design B. Report Design C. Query Design D. Form Design
form design
Jeremy needs to create a quick form based on a signle table in his basebal card databse. Which option will automatically include all the fields from a single table? A. Blank Form B. Form Design C. Form Wizard D. Form Tool
form tool
An assistnat at Doggie Daycare was asked to update the patient information for all new pets. What view is best to enter the new patient information? A. Layout View B. Form View C. Design View D. Report View
form view
Juan wants to view one record at a time in his database. Which view shoudl he use? A. Design View B. Form View C. Layout View D. Navigation Pane
form view
Linda wants to ensure birth dates are entered as MM/DD/YYYY. Which field property will be used? A. Lookup B. Format C. Default Value D. Field Size
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? A. Format B. Freeze Fields C. Hide Fields D. Sort
freeze fields
Johnny has planned his baseball card database and determined a logical arrangement. What is his next step? A. Determine what information to include B. Discuss the database with users C. Gather the information D. Input data
gather the information
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? A. Sort B. Filter C. Conditional Formatting D. Grouping
grouping
Nick wants to immediately open an employee email from his database. What data type should be used for the email address? A. AutoNumber B. Currency C. Yes/No D. Hyperlink
hyperlink
Dillan wants to ensure socal security numbers are entered in a proper format. Which filed property will be used? A. Input Mask B. Format C. Default Value D. Field Size
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? A. Insert a Totals Row B. Sort by Selection C. Insert a Chart D. Create a Relationship
insert a totals row
Juan is creating a chart which graphs attendance at FBLA State Leadership conferences from the past five years from his database. He wants to display a list of colors, shapes, or patterns used as categories in a chart on the right side. Which tab in Chart Options would he select? A. Titles B. Axes C. Data labels D. Legend
legend
Amanda wants to ensure there are only two characters for the state abbreviation. What should she do? A. Unique Identifier B. Limit field size C. Provide a description D. Provide database security
limit field size
Which type of field enables a user to select from a list of values when updating the contents of a field? A. Calculated B. Attachment C. Lookup D. Hyperlink
lookup
Susie has a relational databse for her catering business. She wants to create a form which shows the data in a customer table one record at a rime. This type of form is a: A. main form. B. subform C. hierarchical form. D. datasheet.
main form
What action would Donna perform to create a new table named Customer Appreciation from the existing Customer Information table and Order History table? A. Delete query B. Update query C. Append query D. Make table query
make table query
Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know which chapter has the most active members in the region. Which aggregate function should she use? A. Count B. Max C. Min D. Average
max
Which software program is used to create a database on a computer, add, change, and delete data in the database and create queries, forms, and reports using the data in the database? A. Microsoft Access B. Microsoft Excel C. Microsoft OneNote D. Microsoft Outlook
microsoft access
Ashawn has created a table from his database to know which product has the lowest quantity in inventory from his spring catalog. Which aggregate function should he use? A. Count B. Max C. Min D. Average
min
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? A. moons and rings B. moons equal rings C. moons not rings D. moons or rings
moons or rings
Jackson is starting a new company database to manage his fall line of products. What form tool could he use to quickly create a set of tabs a user could click to access forms and reports in the database? A. Form View B. Layout View C. Design View D. Navigation Form
navigation form
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? A. Form View B. Layout View C. Design View D. Navigation Form
navigation form
Juan needs to view and access all parts of his database. Where can these objects be located most efficiently? A. Design View B. Form View C. Layout View D. Navigation Pane
navigation pane
Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database? A. Objects Pane B. Database Pane C. Navigation Pane D. List Pane
navigation pane
Which type of relationship means that a record in the first table is related or matches more than one record in the second table? A. One to one B. Many to many C. One to many D. One to any
one to many
Curt needs to finish a database project from yesterday. What action should he take in order to start working on the database? A. Close B. Create New C. Open D. Save As
open
Curt needs to create a backup to his existing database on an external hard drive. What action should he take? A. Close B. Create New C. Open from Existing D. Save As
open from existing
In a table, which is a way of exclusively identifying each record in the database? A. Unique marker B. Primary Key C. Primary marker D. Primary category
primary key
Wendy needs to print to the color printer instead of the default printer on her computer. Which option would give her the choice to change the printer? A. Print Preview B. Quick Print C. Print D. Selected Records
Wendy wants to be able to see what her database report will look like without producing a hard copy. Which option would she choose? A. Print Preview B. Quick Print C. Print D. Selected Records
print preview
William has created a report. Which view could he use to see exactly how the report will look on paper? A. Report View B. Print Preview C. Design View D. Layout View
print preview
Nick needs to specify two characters for the student ID field. What area of Design View would he access to specify this? A. Data Type B. Description C. Field Name D. Properties
properties
Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields? A. Unique Identifier B. Limit field size C. Provide a caption D. Provide database security
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? A. Form B. Table C. Query D. Report
query
Curt wants to search his CD collection data base for the names of the albums from his favorite artist that were released after 2010. What object should Curt create and save to obtain this information most efficiently? A. Filter B. Table C. Query D. Report
query
Keisha created a database of her music. She wants to locate only the songs by Beyonce. What tool should she use in order to view this information and save it for later use? A. Filter B. Form C. Query D. Report
query
Joe wants to modify the query he created to incorporate various colors, fonts, and styles to create a custom look. Which query would he use? A. Design View B. Simple Query Wizard C. Query Design View D. Query Wizard
query design view
Ali has worked for years cataloging his comic book collection into a database. Recently his computer crashed, but fortunately he has a backup in his OneDrive cloud storage. Which method should he use to restore his database on his new computer? A. Backup B. Recover from Backup C. Save to External Locations D. Previous Version
recover from backup
Kurt has worked for years cataloging his music collection into a database. During a recent storm, Kurt's computer was damaged, but fortunately he has a backup on his flash drive. Which method should he use to restore his database on his new computer? A. Backup B. Previous Version C. Save to External Locations D. Recover from Backup
recover from backup
Which term refers to storing the same field in more than one location in a database? A. Redundancy B. Repetition C. Replication D. Recurrence
redundancy
What type of database contains multiple collections of data that are related to one another? A. Joined B. Relational C. Flat D. Managed
relational
Which type of database consists of a collection of tables, each of which contains information on a specific subject? A. Relational B. Interactive C. Collaborative D. Independent
relational
Avery is the president of her FBLA chapter. FBLA keeps all member information in a database. She is often asked by members to pull a detailed summary of all competition participation for scholarship applications. Which report creation tool will automatically pull all the fields from the competition table? A. Report B. Report Design C. Blank Report D. Report Wizard
report
Keisha wants to print her completed music databases. Which tool would she use? A. Filter B. Form C. Query D. Report
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? A. Form B. Report C. Table D. Query
report
Tyler is using Mcrosoft Access for a class assignmnet. Which databse object would she use to organize and display data pulled from tables and queries? A. Table B. Form C. Macro D. Report
report
Which ribbon displays report printing options? A. Report Design Tools Design Ribbon B. Report Design Tools Arrange Ribbon C. Report Design Tools Format Ribbon D. Report Design Tools Page Setup Ribbon
report design tools page setup ribbon
The owner of Ima Graphic Animator, Inc., a graphic design company, wants to place the company's logo at the top of the first page of a report. Where should the lofo be placed in the Report Design View? A. Report header section B. Page header section C. Report footer section D. Page footer section
report header section
Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report? A. Report Layout Tools Design B. Report Layout Tools Arrange C. Report Layout Tools Format D. Report Layout Tools Page Layout
report layout tools arrange
After a query is created, which action must take place to display the results of the query? A. Go B. Run C. Get D. Retrieve
run
Marty has spend a lot of time creating a database to track her sales contacts. She has been asked by management to share the database with her colleagues as an example to follow. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms? A. Save As B. Save as Database Template C. Create a Backup D. Save as PDF
save as database template
Rachel has spent a lot of rime crating 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? A. Save As B. Save as Database Template C. Create a Backup D. Save as PDF
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? A. Crosstab Query B. Multiple Query C. Simple Query D. Find
simple query
Which group on the Form Design Tools/Arrange Ribbon allows the user to align to grid? A. Merge/Split B. Move C. Position D. Sizing & Ordering
sizing & ordering
Susie has a relational database for her catering business. She wants to create a form which shows the customer information at the top and any orders for that customer at the bottom. The orders section of the form is a: A. main form. B. subform. C. hierarchical form. D. datasheet.
subform
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? A. View Code B. Add Existing Fields C. Tab Order D. Property Sheet
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? A. Text B. Long Text C. Number D. Date/Time
text
Jenny is setting the addresses for each patient. Which data type should she use? A. AutoNumber B. Currency C. Number D. Text
text
Michelle wats to change the color of her form to make it more attractive. Which would she use? A. Form B. Filter C. Controls D. Theme
theme
Susie wants to locate the file name of her current document. Where should she look? A. Rename B. Navigation Pane C. Title Bar D. Status Bar
title bar
Juan is crating a chart graphing his inventory database. He needs to name the chart "August Inventory Report". Which tab in Chart Options would he select? A. Titles B. Axes C. Data labels D. Legend
titles
Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use? A. Bound B. Unbound C. Button D. Calculated
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? A. Bound B. Unbound C. Button D. Calculated
unbound
Tammy wants to add instructions by one of the fields on her form to ensure that the data is entered correctly. Which type of control will she add to the form? A. Bound B. Unbound C. Button D. Calculated
unbound
What is the purpose of a primary key in a database? A. Unique Idenifier B. Limits field size C. Provides a description D. Provides database security
unique idenifier
What type of query enables a user to make the same change to all records satisfying a certain criterion? A. Update B. Append C. Action D. Make table
update
What are the rules that a user should follow when entering data into a table? A. Text B. Validation C. Criterion D. Properties
validation