Deck 5: Templates, Advanced Relationships, and Macros

Question 1

It is a good practice to make a backup copy of your database before you run any action query.

Answer 1

True

Question 2

A parameter report asks the user to enter the specific criteria value for a field when the report is run.

Answer 2

True

Question 3

The Now()function retrieves the current date,including the time,from your computer.

Answer 3

True

Question 4

To change the size of a control on a report,simply select the control and use the sizing handles to adjust the size.

Question 5

If duplicate records are present,two or more records in a table share the same values.

Question 6

A delete query deletes the entire record.

Question 7

After you create a crosstab query with the Crosstab Query Wizard,you can edit it in Design view and make changes to any of the selections made during the wizard.

Question 8

The Top Values query property limits the number of records that display in a query answer.

Question 9

In an update query,unlike the Criteria row,the Update To row is not case sensitive.

Question 10

Action queries do not display confirmation messages after the action is complete.

Question 11

Creating a report in Layout view provides you with the most flexibility.

Question 12

When you are viewing a report in Layout or Print Preview view,the sections are not as obvious as they are in Design view.

Question 13

An embedded query updates as you add and remove fields from the report.

Question 14

Unlike the resulting datasheet from a regular select query,you can edit the results from a crosstab query.

Question 15

An action query makes a temporary change to the data in the database and the Undo button is available to reverse the action.

Question 16

A calculated control contains an expression in the Control Source property.

Question 17

The serial number is designated by the number of days the date is from January 1,2000.

Question 18

While you could modify each record individually in a table,an update query allows you to make the change to all records using one command.

Question 19

Unmatched records are records in one table that do not contain any matching records in a related table.

Question 20

If you want to perform the same modification on several controls,select them all before performing the change.

Question 21

The report from the "one" side of the relationship is the main report,while the report from the "many" side of the relationship is the subreport.

Question 22

Which of the following deletes records from a table in a database?

A) update query
B) append query
C) delete query
D) make table query

Question 23

When the report is in Design view,the expression is visible inside of the control.

Question 24

Which of the following would you use to create a history table,which you could then use to store old records?

A) update query
B) append query
C) delete query
D) make table query

Question 25

In a crosstab query,what is the maximum number of fields that you can include as row headings?

A) two
B) three
C) four
D) five

Question 26

You can place calculated controls in any section of a report.

Question 27

Which of the following displays query results in a row/ column format,which makes the data easier to read and understand?

A) Query Wizard
B) crosstab query
C) find duplicates query
D) unmatched records query

Question 28

In a subreport,it is common to use a tabular layout for the fields.

Question 29

Which of the following would you use to give all employees a 2% pay raise?

A) update query
B) append query
C) delete query
D) make table query

Question 30

Which of the following is a tool that makes it easier to build four different types of queries?

A) Query Wizard
B) crosstab query
C) find duplicates query
D) unmatched records query

Question 31

When you open the main report,the subreport opens automatically because the objects are now attached.

Question 32

Which of the following adds records into an existing table in a database?

A) update query
B) append query
C) delete query
D) make table query

Question 33

Which of the following makes changes to the data in a database?

A) update query
B) append query
C) delete query
D) make table query

Question 34

You can build the main report and the subreport in any order,but the most common approach is to build the main report first.

Question 35

A running total is not the same as an aggregate function.

Question 36

Access evaluates expressions with the standard order of operations.

Question 37

On how many dimensions does a crosstab query summarize data?

A) two
B) three
C) four
D) five

Question 38

Use the Subform/ Subreport button to launch the SubReport Wizard to add the subreport.

Question 39

Concatenation combines different parts of an expression using the $ operator.

Question 40

How many types of action queries are there in Access?

A) two
B) three
C) four
D) five

Question 41

Which of the following can the data fields for a report come from?

A) reports
B) queries
C) tables
D) both B and C

Question 42

In a Top Values query,which of the following is necessary to return the bottom values?

A) sorting the results in ascending order
B) sorting the results in descending order
C) sorting on the primary key
D) the top values will be returned automatically

Question 43

Which of the following report sections prints page numbers or dates at the bottom of each page?

A) Report Footer
B) Page Header
C) Page Footer
D) Group Header

Question 44

Which of the following can you use to compare records in two tables and determine which ones are not matched?

A) Query Wizard
B) crosstab query
C) find duplicates query
D) unmatched records query

Question 45

Which of the following report sections prints column headings,page numbers,or dates at the top of every page?

A) Report Footer
B) Page Header
C) Page Footer
D) Group Header

Question 46

Which of the following is not a percentage value choice provided by the Top Values query?

A) 5%
B) 25%
C) 75%
D) all

Question 47

Which of the following Access date functions determines a specific piece,or interval,of a date?

A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()

Question 48

Which of the following is not a fixed number choice provided by the Top Values query?

A) 5
B) 25
C) 75
D) 100

Question 49

In a Top Values query,which of the following is necessary to return the top values?

A) sorting the results in ascending order
B) sorting the results in descending order
C) sorting on the primary key
D) the top values will be returned automatically

Question 50

Which of the following regulates which database fields are available in a report?

A) Top Values query
B) Record Source property
C) Structured Query Language
D) Query Wizard

Question 51

Which of the following Access date functions adds to a date?

A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()

Question 52

Which of the following report sections prints report totals or other information at the end of the report?

A) Report Footer
B) Page Header
C) Page Footer
D) Group Header

Question 53

Which of the following Access date functions determines the difference between two dates?

A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()

Question 54

Which of the following can you use in your criteria to look for partial matches?

A) parameter reports
B) subqueries
C) wildcards
D) controls

Question 55

Which of the following report sections prints the group title/ value at the top of each group?

A) Report Footer
B) Page Header
C) Page Footer
D) Group Header

Question 56

Which of the following Access date functions converts values into a date value?

A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()

Question 57

The serial number Access assigns to a date is designated by the number of days the date is from _______________.

A) January 1,1900
B) January 1,2000
C) December 31,1900
D) December 31,2000

Question 58

Which of the following statements is true about duplicate records?

A) All duplicated data is not bad.
B) Even when you practice good database design,you still may end up with duplicated data.
C) If duplicate records are present,two or more records in a table share the same values.
D) all of the above

Question 59

Which of the following might you use when you have a common starting point (the original query)but want to customize it for additional purposes (the additional query)?

A) parameter report
B) subquery
C) wildcard
D) control

Question 60

Which of the following does Access automatically include when you create a report in Design view?

A) Page Header section
B) Detail section
C) Page Footer section
D) all of the above

Question 61

Which of the following must you use to view the expression inside a calculated control?

A) Layout view
B) Design view
C) Print Preview view
D) Page Layout view

Question 62

In a concatenation formula,how would you insert a comma and a blank space between two fields?

A) &" "&
B) &","&
C) =","&
D) [","]

Question 63

Which of the following operators is used to concatenate data?

A) [
B) +
C) &
D) (

Question 64

Which of the following would you use to hide repeated values in a report?

A) concatenation formulas
B) calculated controls
C) Hide Duplicates property
D) Delete query

Question 65

While displaying a report in Design view,which of the following opens the Property Sheet?

A) F2
B) F4
C) F6
D) F8

Question 66

To number rows using a running total,which of the following should you type in the Control Source property?

A) =1
B) =2
C) =3
D) =4

Question 67

Which of the following formatting properties of a control determines whether a control shows in Report view or Print Preview view?

A) Decimal Places
B) Visible
C) Back Color
D) Fore Color

Question 68

Which of the following must fields be enclosed with in a calculated expression?

A) square brackets
B) plus signs
C) parentheses
D) dollar signs

Question 69

Which of the following would you use to combine the first and last name fields to produce a more readable report?

A) concatenation
B) running total
C) one-to-many relationship
D) SQL

Question 70

Which of the following can you use calculated controls for?

A) mathematical equations
B) aggregate functions
C) text-based equations
D) all of the above

Question 71

Which of the following formatting properties of a control sets a fixed number of decimal places to display?

A) Decimal Places
B) Visible
C) Back Color
D) Fore Color

Question 72

Which of the following are controls that you can add to a report?

A) text boxes
B) labels
C) lines
D) all of the above

Question 73

Which of the following must go at the beginning of calculated expressions in Access?

A) =
B) +
C) (
D) [

Question 74

Which of the following lets you select more than one control at once?

A) Ctrl
B) Alt
C) Shift
D) Esc

Question 75

Which of the following can a running total field show?

A) running balance
B) cumulative total
C) counting
D) all of the above

Question 76

Which of the following is always used to surround parameter text in a parameter report?

A) square brackets
B) plus signs
C) parentheses
D) dollar signs

Question 77

Which of the following font characteristics of a control can you change in the Property Sheet of that control?

A) Font Name
B) Font Size
C) Font Underline
D) all of the above

Question 78

Which of the following formatting properties of a control sets the font color?

A) Decimal Places
B) Visible
C) Back Color
D) Fore Color

Question 79

Which of the following formatting properties of a control sets the fill color of a control?

A) Decimal Places
B) Visible
C) Back Color
D) Fore Color

Question 80

What is the default value of the Running Sum property?

A) No
B) Over Group
C) Over All
D) none of the above