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

PDF

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

print

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