com si FINAL

You can add multiple levels of grouping to a Totals query.

True

Data entered in a query is actually stored in the underlying table(s).

True

Filters do not delete data or records.

True

If you are not using a totals query, then you must display the Totals row in a query if you want to use aggregate functions.

True

If you see plus signs (+) next to records in Datasheet view then you know that two or more tables are related.

True

If you want to see the results of several aggregate functions for one field, you would add the field in the Totals query several times.

True

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

True

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

True

It is permissible to use the percent (%) sign when entering the interest rate in the PMT function.

True

It is useful, at times, to add the same field to a query several times.

True

Mailing labels are considered reports in Access 2016.

True

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

True

Reports can draw data from tables or queries.

True

Some functions have optional arguments.

True

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

True

The Enforce Referential Integrity box should normally be checked.

True

The Expression Creator tool helps you create complex expressions.

True

The Total row, when using aggregate functions, displays both the total and the individual records.

True

There might be times when you want to add the same field to a query several times.

True

Using Filter by Form enables you to filter on multiple criteria.

True

Using the Compact and Repair Database utility on a regular basis is good practice.

True

If you wanted to add January 16, 1957 as text criteria, how would you enter it?

''January 16,1957"

In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first?

(2-3)

In Office 2016, Access provides how many tools for creating forms?

14

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

15

How many arguments does the IIf function have?

3

If you add a field from a table with 10 records to a query and add a field from an unrelated table with 4 records to the same query, how many records will display when you run the query?

40

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

53

How many characters can be stored in a field with a Long Text data type?

64,000

Which of the following comparative operators cannot be used in a data validation rule?

=<

Which of the following comparison operators is not valid?

=>

Which wildcard character matches a single character in the same position as the wildcard?

?

Which of the following statements about the Round function is false?

A Round function with a precision of 1 rounds to the nearest integer.

An illustration of a one-to-many relationship would be:

A customer may have more than one account in an accounts table.

What is SharePoint?

A host server

What is the most important thing you need if you are going to create a Web app?

A host server

Which of the following statements is true?

A last name is an example of a common field to group by.

When creating a calculation, which of the following would be identified as an error by Access?

A missing colon in the expression (for example: TotalHours [OTHours]+[RegHours]).

Which of the following statements is false?

A null value means that the value is zero for any type of a field.

Which statement about a totals query is true?

A totals query may contain several grouping fields and several aggregate fields.

Which of the following determines how the field names can be made more readable in table and query datasheets?

Caption property

What allows you to summarize data by the values of a field?

Adding grouping to a query

Which of the following cannot be extracted by the DatePart function?

All of the above (i.e., other 3 answers) can be extracted.

Which of the following can be added to a totals query?

All of the above can be added to a totals query.

Which of the following cannot be used in a calculated field?

All of these can be used in a calculated field

What is not a necessary piece of data needed for the Pmt function?

Amount already paid on the loan

Which of the following would be matched if you use a Selection filter's exact match option for the name Ann?

Ann, ANN, and ann

To add a predefined table into an exiting database, you should use which of the following?

Application part

All of the following are suggested guidelines for table design except:

Avoid date arithmetic.

Which of the following utilities is used to recover in the event of loss or damage?

Back Up Database

To create a database from a template you would use which view?

Backstage

The query wizard is best used to create what kind of query?

Basic queries

Which of the following is not a valid condition for an IIf function?

Between 10 and 22

Which of the following would not be done using an aggregate function?

Calculating the payment amount of a loan

"lastName" is an example of .........................

Camel case notation

Which of the following is true regarding table views?

Changes made in Datasheet view are automatically saved when you move the insertion point to a different record.

Which of the following is not one of the three methods for creating a database?

Create a blank cloud database

Which of the following is not data that can have an Input Mask applied without creating a custom mask?

Credit card number

In Datasheet view, what does a pencil symbol to the left of a record indicate?

Data in that record has not been saved yet.

Which of the following is not a good reason for using a form for data entry?

Data you enter in a form must then be transferred to the table

When you run a query, what is the default view?

Datasheet

Which of the following functions require no parameters?

Date

What field property would you use to automatically enter "PA" in a State field?

Default Value

To view or modify a table's structure you would go to what view?

Design

What are the two ways you can view a table?

Design and Datasheet views

Which of the following views provides you with the most flexibility in modifying forms and reports?

Design view

Which of the following conditions is available through a Selection filter?

Equal condition

Which of the following is not true of an Access database?

Every table in a database contains the same number of records as every other table.

What two tabs are unique to Access?

External Data and Database Tools

A function is a predefined computation that is used for simple calculations.

False

All aggregate functions can be used with any field type.

False

Although you can link to external data, it is not recommended.

False

As long as your data is accurate there is no real need to print preview your reports.

False

If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

False

If a sort has been added to a table it takes precedence over a sort applied to a form even if you are in form view.

False

It is best when designing a query to add all the fields from a table in case you need them later.

False

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

False

Just as with forms, you can add, edit, or delete data in a report.

False

Logical operators only work with text and numbers, not dates.

False

Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships windows to make any changes.

False

Text you add to the criteria row in a query is case sensitive, so be careful or you may get unexpected results.

False

The first step in creating a query is selecting the fields you need.

False

The rate argument in the PMT function always uses the annual rate.

False

There is no way to make sure that a record cannot be deleted.

False

Using a template to create a database is not an effective use of time because of all the modifications you need to make so the database will fit your needs.

False

Using the Back Up Database utility only saves the structure of the database, not the content.

False

You can edit data in form layout view.

False

You can enter an expression in the Expression Builder by either typing the expression manually or by right-clicking the expression.

False

You can only sort records by one field.

False

Your birthday would be a good candidate for a primary key.

False

How many reporting tools does Access 2016 provide?

Five

When creating a calculated field in a query, what common error will not give you a direct indication that there is a problem?

Forgetting the order of operations

Which option would this wildcard, ''H[!oe]∗" not display?

House

The string of characters !\(999")"000\-0000;0;_ represents which of the following?

Input mask

What is not true about the hyperlink data type?

It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work

Where does the Total row of an aggregate function display its results?

Last row in Datasheet view

The simplest view you can use to modify control widths in a form is:

Layout view

Which of the following statements is false?

Layouts for forms and reports are the predefined sets of colors, fonts, and graphics

The main reason to set a field size in Access is to:

Limit the length of values in a table.

Which of the following enables users to choose from a list of options while entering data?

Lookup field

What objects will not use the caption instead of the field names?

Macros

Which of the following cannot be adjusted in the Property Sheet?

Mathematical expression

Which of the following is true for the Query Wizard?

No criteria can be added as you step through the Wizard.

Which of the following data types cannot have an input mask applied?

Number

When you purchase from a store several times this would be an example of what kind of table relationship?

One-to-many (one customer - many purchases)

If you need to send a report to a user who does not have Microsoft Office available, which of the following file formats would be the best choice to ensure it can be opened?

Portable Document Format (PDF)

When adding date criteria to the Query Design view, the dates you entered must be delimited by:

Pound signs (#).

When creating a multitable query from scratch only include related tables in your query.

True

Use the ............................ to see exactly what the printed report will look like before printing.

Print Preview

What sheet will allow you to change the formatting of a field in a query?

Property

What produces a subset of your data?

Query

A report can be made from one or more tables or a query. The object(s) that a report is based on is known as the:

Record source

In datasheet view, what do the rows indicate?

Records

You edit several records in an Access table. When should you execute the save command?

Records are saved automatically; the save command is not required

Which of the following statements about reports is false?

Reports are primarily used to modify data.

To select how many decimal places a value will display; you would use which function?

Round

What button do you click to see the results of a query?

Run

If you want to calculate aggregate statistics about graduation rates for students in a collage database, which of the following would provide the least useful information if you were to group by it?

Social Security Number

How would you sort or filter records in a field that begins with both numbers and letters so that the records which begin with numbers appear before the records that begin with letters?

Sort ascending

A parameter query enables you to:

Specify criteria for a field when you run the query.

Which of the following statements is false?

Stacked layouts are more common for reports because they use less paper when printed.

What is not one of the six guidelines for creating fields?

Store data in as large of number of parts as possible

A query's specifications as to which tables to include must be entered on the:

Table row of the query design grid.

When you split a database what object type is put in the back end?

Tables

What does opening a database in exclusive mode assure?

That you are the only person with that database open.

In order to summarize data in a report and override the sort order of the record source you would use:

The Group, Sort, and Total Pane

What interface element shows you the various objects in your database?

The Navigation pane

Which of the following is not a data validation technique?

The Round function

Which of the following about the Total row in Query design is false?

The Total row applies only to non-numeric fields.

You can add aggregate functions to calculated fields.

True

You can add conditions to a Totals query.

True

It is more efficient to make a copy of an existing query rather than to create a new query when which of the following is true?

The existing query and the new query use the same tables and fields.

Which of the following fields is least likely to be set to required?

The name of an emergency contact for a patient in a doctor's database

All of the following statements are true about creating a database except:

The objects provided in a template cannot be modified.

When entering, deleting, or editing input masks:

The table must be in Design view.

When would you use the Date function?

To display the current date.

When using the Lookup Field Wizard, how wide should the columns be?

To display the longest value

Which of the following is a primary reason for manually setting up data validation?

To reduce user entry errors.

<<Rate>> is an example of an argument.

True

A good practice is to make backups of your databases on different storage devices.

True

A multiple items form shows more than one record at one time instead of the one record which is normally display in a form.

True

A primary key can be a combination of several fields.

True

A totals query allows you to see only the results of aggregate functions, not the detail.

True

Access provides a wizard for easily importing Excel data into Access.

True

All database objects should be tested before the database is deployed.

True

Creating a database from a template can help you get started more quickly.

True

Which of the following is not recommended as a professional way of styling a form?

Use several fonts to indicate different types of data

Which method of creating a database demands the least amount of expertise in Access?

Using a template

Which of the following is not a common mistake when creating calculated fields?

Using the wrong fields

What is not critical when you are first designing a database?

What the field names will be

When is validation text displayed?

When a validation rule violation occurs.

When you want to add a condition to a Totals query, which option do you select from the Totals row list?

Where

With respect to importing data into Access, which of the following statements is true?

You can assign a primary key while you are importing Excel data.

Which of the following statements is true?

You can group records to show a list of properties by state

What symbols does Access use to indicate a field name?

[ ]

Checking the Cascade Delete Related Records checkbox assures that ...................

all records will be deleted in related tables if you delete the primary key in the primary table

You can restrict the data type that will be accepted in a parameter query by ...........................

choosing a data type for each parameter

One reason to begin with a template is that you do not have to .................

create as many objects

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

form

To move a field you ................

left-click the column heading, then drag the field to where you want it

the..... aggregate function returns the value with the highest value.

max

Where is data in a database stored?

table

When you click the Enable Content warning, the database is now ...

trusted on this computer

The first step to resizing a column in datasheet view is to move the pointer until it looks like a ..................

two-headed arrow and then click

When you are prompted to enter a value when you run a query which includes a calculated field, you probably ........................

typed a field name incorrectly

Enforcing referential integrity assures that ...................................

you cannot enter a value in the foreign key if there is no corresponding value in the primary key