Access Exam 2.13, Access Exam 2.01, Access Exam 2.02, Access Exam 2.03, Access Exam 2.04, Access Exam 2.05, Access Exam 2.06, Access Exam 2.07, Access Exam 2.08, Access Exam 2.09, Access Exam 2.10, Access Exam 2.12, Access Exam 2.11, Access Exam 2.15

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?

Blank Report

Individual entries in the FBLA address book would be entered into a:

Cells

Michelle used the property sheet to customize her form in Access. Which task can she complete?

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?

Close

Where is the command for creating a new table from Table Design view?

Create Ribbon

What are three valid methods for saving a database in Microsoft Access?

Ctrl + S, File Tab Save Command, Quick Access Save command

Dennis needs to format his sales account column to show dollar signs. Which format would he use?

Currency

Juan is creating a chart graphing 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?

Data Labels

Nick wants to design a database and wants to automatically assign an ID number to each record. What is auto numbering an example of?

Data Type

An address book containing all FBLA members would be an example of a:

Database

Chad needs to remove a student from the FBLA database. Which option should he choose?

Delete Record

Nick wants to make notes for future users of his database so they will properly use the field names and types. Where would he make these notes?

Description

Which view displays the area used to create a table or to modify the structure of a table?

Design

Riley is using 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 Tool contextual tabs should he select for the theme group?

Design Tab

Riley is using 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

Riley is using Access to collect data for a science project. He is creating a report and wants to apply predefined color and font scheme formats. Which report layout tool contextual tab should she select for the theme group?

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?

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?

Design View

Juan is creating a new database. He wants to assign field names. Which view is BEST to create the new database?

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?

Design View

You are employed as an assistant at Doggie Daycare. Your boss has asked you to update the new pet patient information. If you opened the form in design view, which view should you switch to in order to enter patient information?

Form View

Linda wants to ensure birthdates are entered as MM/DD/YYYY. Which field property will be used?

Format

Jenny is entering data to the medication fields in the patient database and needs to constantly view patient ID numbers to input medication information. What should she do?

Freeze Fields

Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?

Gather the information

Nick wants to immediately open an employees' email from his database. What data type should be used for the email address?

Hyperlink

Dillano wants to ensure social security numbers are entered in a proper format. Which field property will be used?

Input Mask

Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Ashton to add a footer?

Layout View

Juan is creating a chart graphing 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?

Legend

Amanda wants to ensure there are only two characters for 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

Which type of fields enables a user to select from a list of values when updating the contents of a field?

Lookup

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?

Microsoft Access

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

Juan needs to view and access all parts of his database. Where can these objects be located most efficiently?

Navigation Pane

Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database?

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?

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?

Open from Existing

In a table, which is a way of exclusively identifying each record in the database?

Primary Key

Wendy wants to be able to see what her database report will look like without producing a hard copy. Which option would she choose?

Print Preview

Nick needs to specify two characters for the student ID field. What area of design view would he access to specify this?

Properties

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

Curt wants to search his CD collection database for the names of the albums form his favorite artist that were released after 2010. What object should Curt create and save to obtain this information most efficiently?

Query

Curt wants to search his CD collection database 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?

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?

Query

Joe wants to modify the query he created to incorporate carious colors, fonts and styles to create a custom look. Which query would he use?

Query Design View

Which term refers to storing the same field in more than one location in a database?

Redundancy

What type of database contains multiple collections of data that are related to one another?

Relational

Which type of database consists of a collection of tables, each of which contains information on a specific subject?

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?

Report

Keisha wants to print her completed database. Which tool would she use?

Report

Tyler is using Access for a class assignment. Which database object would she use to organize and display data pulled from tables and queries?

Report

Which ribbon displays report printing options?

Report Design Tools Page Setup Ribbon

You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to place your logo at the top of the first page on a report. Where would you place the logo in the Report Design View?

Report Header Section

Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report?

Report Layout tool Arrange

Curt needs to create a backup to his existing database on an external hard drive. What action should he take?

Save As

In Datasheet view, how does a user delete a record?

Select the record and choose Delete from the Home Ribbon

Jane wants to determine how many FBLA students have registered for the state conference from the Coastal region. Which query view would she use?

Simple Query View

Mr Brown's report needs to be arranged by last name and first name. What tool can he use to ensure that students appear in alphabetical order on his report?

Sort

Eddie works for ABC Finance. He needs to view which employee(s) has the lowest sales for the month. Which command should he use?

Sort Ascending

Eddie works for ABC Finance. He needs to view which employee(s) has the highest sales for the month. Which command should he use?

Sort Descending

What ensres that a query result appears in a specific order?

Sorting

When a database is created, what is defined when names and data types are assigned to all data fields in a table?

Structure

Isabel wants to design a database for her FBLA club to include all the members' 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

Michelle wants to change the color of her form to make it more attractive. Which should she use?

Theme

Susie wants to locate the file name of her current document. Where should she look?

Title Bar

Juan is creating a chart graphing his inventory database. He needs to name the chart August Inventory Report. Which tab in Chart Options would he select?

Titles

What are the rules that a user should follow when entering data into a table?

Validation

Sam completed a query on the UNC School System and wants to narrow his search to find which schools have maximum tuition of $15,000 for in-state students. Which operator would he use?

<=

The athletic director is looking for swim team purchase orders that are more than $200. What criteria would giver her this information?

>200 AND Swimming

Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records?

Aggregate

Marci is searching a Planet Database. She wants to fins out how many moons Saturn has and the names. Which comparison operator would she use?

And

Matt needs to add his contacts to the Drivers Education database. To do this quickly, what predefined object can he create?

Application Parts

Nick wants to design a database and wants Access to automatically assign an ID number to each record. What data type should he use?

Auto Number

Juan is creating a chart graphing attendance at FBLA State 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?

Axis

Chad needs to change a member's telephone number in the FBLA database. What step should he take?

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. She should save the form in which file format to ensure everyone can read the information?

Either PDF or XPS

You have been asked to develop an address book for the FBLA members. Last name and first name would be examples of:

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 know as the backstage?

File Tab

Hank wants to add color to the header section of his form. Which formatting option would he use?

Fill Color

Eddie needs to know which employee(s) work in the Southeast District. Which command would he use?

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 information without saving?

Filter

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

Mrs. Smith needs to know Jenny's address. Which command would she use?

Find

Curt needs to format the number in his database to two decimal places. Which numbers format would he use>

Fixed

Dennis needs to format the numbers in his database to three decimal places. Which number format would he use?

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?

Font Color

Michelle needs each National Technical Honor Society member to complete an information sheet. Which tool would be best?

Form

Mr. Johnson, the FBLA adviser, is updating the membership database table for the new school year. He wants to define the field to display and simplify the interface by adding labels and instructions. He would use:

Form

Tyler is using Access for a class assignment. Which database object would she use to enter one record at a time

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 tool Kevin will need to modify the form?

Form Design

You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to quickly create a new blank object, one which includes one record and a more detailed view of the structure. Which would you use?

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

Juan wants to view one record at a time in his database. Which view should he use?

Form View