Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
5 Cards in this Set
- Front
- Back
|
Which of the following Cannot be adjusted in the property sheet? A) number of decimal Places B) mathematical expression C) Caption D) number format ( for example, Currency) |
B) mathematical expression |
|
|
which of the following is not an aggregate function? A) PMT B) AVG C)Count D)min |
A) PMT |
|
|
Which of the following Can be added to a totals query? A) Conditions B) Grouping fields C) Aggregate functions D) all of the above can be added to a totals query |
D) all of the above can be added to a totals query |
|
|
Which statement about a totals query is true? A) a totals query is created in a datasheet view B) a totals query may contain several Grouping Fields but only one aggregate field C) a totals query is limited to only two fields, one grouping field and one aggregate field D) a totals query may contain several grouping fields and several aggregate fields |
D) a totals query may contain several grouping fields and several aggregate fields |
|
|
A query contains students names. you run the query and while in datasheet view you notice a spelling error on one of the students names. you correct the error in data sheet view. which statement is true? A) the name is correctly spelled in the query but will be misspelled in the table and all other queries based on the table. B) the name is correctly spelled in this query and any other queries, but will remain misspelled in the table C) you cannot edit data in a query D) the name is correctly spelled in the table and in all queries based on the table. |
D) the name is correctly spelled in the table and in all queries based on the table. |
