CIS 105 – Access will always give you step-by-step

1 of 25

Access will always give you step-by-step instructions to help you fix errors in formulas.

True

False

Question2 of 25

Which of the following is not an argument used in the PMT function?

Rate

Total_due

Type

Future_value

Question3 of 25

Which of the following cannot be included on a form?

Drop-down list

Check box

Button

Sub report

Question4 of 25

What type of query will allow you to see statistics by category?

Update query

Statistical query

Delete query

Totals query

Question5 of 25

On a form the text box and its label would be considered two different controls.

True

False

Question6 of 25

The Expression Creator tool helps you create complex expressions.

True

False

Question7 of 25

The easiest way to find information is to search the table directly.

True

False

Question8 of 25

Which of the following is a popular label-producing company?

Easy Labels

Okidata

MakeIt Labels

Avery

Question9 of 25

What punctuation do you use to separate the arguments in a function?

;

:

,

.

Question10 of 25

You cannot prevent a record from being deleted in Access.

True

False

Question11 of 25

What type of form control do you normally use to display data?

Button

Label

Text box

Data

Question12 of 25

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

When

Where

Group

Condition

Question13 of 25

Which of the following tasks is not easily accomplished using a form?

Move data

Enter data

Edit data

Delete data

Question14 of 25

Which of the following is not a report view?

Design view

Layout view

SQL view

Report view

Question15 of 25

Which form (that includes the existing fields from the data source) can you create with just one click?

Stacked Layout

Form Wizard

Tabular Layout

Blank Form

Question16 of 25

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

True

False

Question17 of 25

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

Adding a summarizing field

Adding an update field

Adding the proper calculated field

Adding grouping to a query

Question18 of 25

Access refers to aggregate functions as which of the following?

Whole column functions

Totals

Complex functions

Sums

Question19 of 25

Which view do you normally use for data entry?

Design view

SQL view

Form view

Layout view

Question20 of 25

Most forms allow you to enter data into more than one record at a time.

True

False

Question21 of 25

Normally, when you Print Preview a report, the program will generate a report with how many pages?

Only the first page

All the pages only if they will all fit on the screen at one time

Only the first two pages

All the pages

Question22 of 25

Which of the following is not true when designing a report or form?

You should provide a visual separation between the primary key and the rest of the form.

All text boxes should be the same length for consistency of look.

Adding a bright color draws attention to a field.

Changing the color of a border adds contrast.

Question23 of 25

The sort order in a report’s source overrides any sort order applied to the report.

True

False

Question24 of 25

What can the phrase “Please Excuse my Dear Aunt Sally” help you remember?

Naming convention for cell ranges

The various printing options available in Excel

The order of operations

How to do date calculations

Question25 of 25

Access will identify logical errors in calculated fields.

True

False

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.