Advertisement Upgrade to remove ads

All the following statements are true regarding functions arguments EXCEPT:

An argument can be the value of a label

In Access, a query criterion use to locate a blank field is

Null

A(n) ________ field is used to produce a value from an expression or function

calculated

Jose is working on a database that stores stock information. He needs to design a field that will allow a user to connect to a graph created in Excel. The data type he should apply to this field is

OLE

Marla is working in a database that stores customer purchases. She needs to find customers in the New York area that have purchased over $5000 worth of goods. Which query operator would Marla use in a query to find this information?

AND

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

Default value

Which of the following statements offers the best method for ensuring that a database is recoverable in case of corruption?

Make a copy of the database before attempting to make changes to the database.

The built-in IIf Function evaluates a condition and displays ________.

one value when the condition is true and another value when the condition is false

Which of the following statements is true about how Access and Excel share data

Access can import data from Excel, and export data to Excel

Expression Builder inserts ________ that tell you where each argument belongs.

placeholders

You are reviewing a table you created in an Access database. As you review the table, you notice a column of cells that are supposed to contain sales figures have pound signs through them (#######). What is the cause of these pound signs?

The pound signs are present because the column is not wide enough to display the data.

Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow?

Irene should include the primary key in the customer information table as a foreign key in the order information table.

The maximum size of the Text data type is ________ characters.

255

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.

foreign key

Two or more tables which contain duplicate data is an example of ________.

data redundancy

Which of the following would be the best choice for a primary key?

Social Security Number

The ________ tab contains all the tools necessary for producing tables, forms, and queries in Access.

Create

The ________ view in Access looks similar to an Excel Spreadsheet

Datasheet

Craig is working in a database that stores homes for sale for a Realtor. The database contains a table called HomeListings which contains a field called ListingDate that holds the date that a home was listed. Craig is designing a query that will identify houses on the market for less than 30 days as new listings, and houses on the market 30 days or more as old listings. This information will be included in a query column called ListingAge. Which of the following expressions will achieve these results:

ListingAge: IIf(Date-[HomeListings]![ListingDate]<30,"New Listing","Old Listing")

A relational database is a collection of:

related tables

A field, or a combination of fields, that has a unique value is a:

primary key/

Which of the following statements is true in reference to calculated fields:

Calculated fields can be used as input for other calculated fields

When defining a field, the field ________ property determines how much physical storage space the field requires.

size

In addition to verifying the accuracy of a calculated field using a calculator, you can also use a(n) ________ to verify results

Excel spreadsheet

Which statement accurately describes the function of a query?

Queries manipulate data stored in tables, displaying only those records which match the query's criteria

The ________ tab holds some of the more advanced features in Access.

Database Tools

David is working in a database that organizes student exam grade information. He needs to find all students who have scored 100 on an exam. David can apply a(n) ________ to the data in order to show only records that meet the criteria.

Filter

Which of the following statements best describes a one-to-many relationship between two tables?

A primary key in the first table matches several foreign keys in the second table.

Steve is working in a database that stores student exam grades. He needs to create a query that will show the numerical mean of exam grades. He should use the ________ function on the column containing the grades.

Sum

You can click the ________ button on the table toolbar to sort records in alphabetical order, from A to Z.

ascending

The ________ tab holds all of the operations necessary to carry out data import and export.

External Data

Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company more than ten years?

>10

Which of the following statements is true about date formatting?

Date formatting changes the way a date is displayed without changing the value of the date

Katie is working in a customer table and needs to know if any customers are located in Texas. In order to locate this information, she would:

create a query

Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is:

Autonumber

Consider the following equation: 3 * (6 + 5) - 4 /2. Which operation would be calculated FIRST according the order of operations:

6 + 5

You can make a(n) ________ copy of a database file to protect your database against loss or damage.

backup

When designing a calculated field, complex formulas can be created with the ________.

Expression Builder

When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT:

you need to create complex charts or graphs

You can use the ________ function in an expression requiring the current date.

Date

The ________ determines what field values are allowed and what other properties the field will have.

Data type

A(n) ________ operator, such as the greater than or less than symbol, can can be used in a query ciriterion to limits the results produced by the query.

comparison

Access contains ________ that perform routine calculations.

Built-in functions

Sarah is working in a database that stores resort vacation information. She needs to design a field that will allow a user to link to an external website. The data type she should apply to this field is:

Hyperlink

Which of the following is the correct mathematical sequence for the order of operations:

Exponentiation, Multiplication, Division, Addition, Subtraction

Ryan needs to organize the data in a table so that it displays in a summarized format. He should use the ________ view for this purpose.

PivotTable

The ________ data type is used to hold sentences or paragraphs of descriptive data.

Memo

Dianna wants to compact an Access database. She can find the tool to compact the database by clicking on the ________ tab.

File

Sum, Avg, and Max are examples of ________ functions that are used to evaluate entire columns of data.

Aggregate

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

AutoNumber

When designing an expression for a calculated field, the name of the calculated field followed by a(n):

Colon

You create a calculated field that finds the average of a column of numbers. Access automatically names the field Expr1. Which of the following statements is true regarding the automatic naming of the calculated field?

Access assigns Expr1 to a calculated field without a name, and this name can be edited

All of the following are true in reference to Expression Builder EXCEPT:

Expression Builder can only be used with functions designed by the user and not with built-in functions

Rich is working on a database that stores a list of vendors and price quotes for a remodeling project. If Rich wanted to create a query to find the least expensive price quote, he should use the ________ function on the column containing the price quotes.

Min

Steven is working on a database that stores student data. He needs to find students majoring in either one of two majors. He is looking for students majoring in Economics. He also is looking for students majoring in History. Which operator would Steven use to find this information?

OR

The ________ field property changes how a field will appear when displayed or printed, but does not change the values stored in the field.

Format

Which of the following statements is true about data types and delimiters?

Different data types require different delimiters

Which of the following statements is true regarding multi-table queries?

Skill is required in choosing the right tables and managing table relationships

A field name can begin with a(n) ________.

number

A total row, which can be displayed as the last row in the Datasheet view of a table, provides a number of ________ functions that can be applied to columns of data.

Aggregate

A(n) ________ is a variable or constant that is needed to produce output for a function in a calculated field.

Argument

A primary key:

must contain a unique value for each record within the table.

The navigation buttons allow you to:

browse records

Which of the following is true about the NOT operator?

The NOT operator returns all records except those that meet the specified criteria

All of the following are acceptable field names EXCEPT:

clientnumber

A ________ displays a subset of records based on specified criteria.

filter

Syntax can most accurately be defined as the ________.

set of language rules that Access follows when evaluating expressions.

The ________ tab is the default Access tab and contains basic editing functions.

Home

Jenna is working on a database that stores a company's invoices. The database includes a Table called Invoices, which has a column called outBalances that shows all outstanding balances. Jenna's boss has asked her to design a query that calculates the numerical mean of all outstanding balances. Which function should Jenna use on the outBalances column to help her complete this task?

Avg

When choosing between Access and Excel, it is best to use Excel in all of the following circumstances EXCEPT:

you need to group, sort, and total data based on various parameters.

Following the rules for the order of operations, what is the result of the following expression:
(9 5) + 5 + 10 - 10 6

0

An expression used in queries to filter records in a table is called a(n):

criterion

Expression Builder can be opened by selecting Builder located in the Query:

setup group

It is more efficient to copy and use an existing query for a new query when

the query criteria needed will be similar to the original query

All of the following are true in reference to built-in functions EXCEPT:

Built-in functions can only perform calculations on numeric data.

A ________ is a question you ask about data stored in a database.

query

Which of the following statements is INCORRECT regarding aggregate functions?

Aggregate functions can return multiple values

Access differs from other Microsoft software because it:

works primarily from storage.

All of the following are valid statements in reference to the IIf function EXCEPT:

IIf functions work only with numeric values and not with text

The PMT function is BEST suited to determine:

The monthly payment on a car loan

The ________ group on the External Data Tab has options that you can use to send a portion of a database to other application

export

Which of the following is NOT an example of an Access object?

sort

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers in that offer services in the Washington area and that service rare flowers. The best way for her to search for this data is to perform a:

Filter by Form

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in two cities. The vendors must have offices in both cities in order to meet Ryan's requirements. Ryan should use the Filter by Form ________ condition.

AND

________ a database rearranges data and objects in a database to make its size smaller.

Compacting

Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed?

The birthday should be a stored field and the age should be a calculated field

Irene is working in a database that organizes city court case information. Irene must find court cases in either one of two cities. Irene should use the Filter by Form ________ condition.

OR

The first two arguments of the DatePart function are ________ which describes the part of the date that will be returned; and ________ which tells Access where to locate the date/time information.

<<interval>>, <<date>>

The ________ organizes and lists the database objects in an Access database.

navigation pane

The result of a query, which appears similar to a table, is called a ________.

recordset

Aggregate functions are most commonly used in all of the following Access objects EXCEPT:

Macros

All of the following are arguments of the built-in PMT function EXCEPT:

Loan Payment

The ________ function isolates a specific portion of a date, such as the day, month, or year, in a date field.

DatePart

You can create or modify a table's field names and data types in ________ view.

Design

The ________ function measures the amount of time that has elapsed between two dates.

DateDiff

Data from two or more tables can be connected by specifying a:

Common Field

Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12th, 2010?

#12/12/2010#

When defining a field, the field ________ property determines how much physical storage space the field requires.

size

A form can best be described as a(n):

object

You can use ________ to create a relationship between two tables using a common field.

join lines

The ________ data type can store text, numerals, and symbols.

text

The ________ is a special character that is used to represent one or more characters in the criterion of a query.

wildcard

Referential integrity should be enforced in a database with related tables because it

helps ensure invalid data is not entered into a table.

Jenny is working on a database that stores invoices. She needs to include the current day, month, and year, which will be derived from the computer system, on each new invoice. She should use the ________ function for this purpose.

Date

By selecting the ________ option, you can make sure that data entered into a related table first exists in the primary table.

referential integrity

A ________ produces professional appearing formatted information derived from the information contained in tables or queries.

report

In a query, which of the following statements is true regarding delimiters in the criterion of a field?

Number data types require no delimiters

Which of the following is true regarding the running of queries and the size of a database?

The queries in larger databases may take longer to run than queries in smaller databases

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

num_periods

What function in a Totals Row would calculate the least valued data item in a group?

Minimum

Constants that are used as arguments in expressions can be defined as ___

values that do not change

Selecting data by means of a query

displays only the data that matches the query selection criteria

When designing a database all of the following statements are true EXCEPT:

you need not be concerned with the future requirements of the database

Database design begins with

grouping data into the correct tables

A form can be used to

enter, edit, and view records in a database

Which field property type should be applied to the fields that should not remain empty?

required

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set