SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 3 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 04 Jan 2018 My Price 10.00

query will allow you to see statistics by category

I need help with my lesson 11 CIS this week. I over computer terms. I am hoping I can get some help.

troy

1  of 25

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

Update query

Statistical query

Delete query

Totals query

Question

2  of 25

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

True

False

Question

3  of 25

You can use the SubForm Wizard to add a subform to an existing form.

True

False

Question

4  of 25

Which element will you never find in a calculated field?

Arithmetic operator

Function

Constant

Macro

Question

5  of 25

What is not a common format for a number control?

Accounting

Percent

Comma

Currency

Question

6  of 25

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

Easy Labels

Okidata

MakeIt Labels

Avery

Question

7  of 25

Which form view enables you to make changes to how the form looks at the same time you view actual data?

Form view

Design view

Layout view

SQL view

Question

8  of 25

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

Design

Form

Datasheet

Layout

Question

9  of 25

The Expression Creator tool helps you create complex expressions.

True

False

Question

10  of 25

What is the advantage of saving a report as a PDF file?

It opens more quickly for other Microsoft Office users.

It is smaller.

It compresses more tightly.

More people can open the file.

Question

11  of 25

What error will you get if something is wrong with the formula in a calculated field?

#NAME!

Invalid syntax

#FORMULA!

Invalid expression

Question

12  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

Question

13  of 25

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

True

False

Question

14  of 25

The only people who really need to test new forms are the end users.

True

False

Question

15  of 25

When modifying a report, on which tab would you find the commands for adding a background image on the report?

Arrange

Design

Page Setup

Format

Question

16  of 25

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

True

False

Question

17  of 25

The default sort order for a table is by its primary key.

True

False

Question

18  of 25

You cannot change data in Report view.

True

False

Question

19  of 25

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

;

:

,

.

Question

20  of 25

When running a query, if it prompts you to enter a value that includes a calculated field, you probably ________.

forgot to name the new calculated field

used the wrong arithmetic operator in your formula

typed a field name incorrectly

entered too many arguments in the formula

Question

21  of 25

What can you not do with an Access report?

Edit data

Save it as a Word document

View it onscreen

Print it

Question

22  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

Question

23  of 25

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

True

False

Question

24  of 25

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

True

False

Question

25  of 25

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

True

False

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 04 Jan 2018 01:01 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)