Access Chapter 3 Final Exam

1. What report is also known as a vertical report?
1. tabular 
2. columnar 
3. query

   2.   This type of report shows information in rows and shows only selected information at the same time.

1. tabular 
2. columnar 
3. report wizard   
4. query

3.      The _____, which appears at the top of every page can display all types of information including the date, title, or other headings.

1. page header 
2. report footer  
3. report header  
4. the detail section

4.      The ____ is visible at the start of the group of records to identify the group.

a.       detail section

b.      group footer 

c.       group header 

d.      report header

5.      The ____ is visible in the central body of the report and is printed once for every record in the query.

a.       group footer 

b.      report header 

c.       page footer 

d.      detail section

6.      Which section of the report is placed after the last group record and contains general information about the group?

a.       page header 

b.      page footer 

c.       report header 

d.      report footer

7.      How many parts of a report are there?

1. 5 
2. 6.  
3. 7  
4. 8

  8.  Which control in Report Wizard combines two or more fields to create another field?

a.       Unbound control

b.      Bound control

c.       Calculated control

  9.   An example of an unbound control is a

a.       Text box containing the heading of a report

b.      Text box containing a student’s identification number

c.       Text box containing a student’s GPA

10.  Calculated controls are contained in

a.       Parenthesis

b.      Quotations

c.       Brackets

            11.Report Wizard can be based from information in a

a.       Underlying Table

b.      Selected Field

c.       Available Field

12.   Once a report is made through Report Wizard it cannot be altered

a.       True

b.  False

13.  This type of function calculates the total of all the cells in the group.

a.      Min Function

b.      Max Function

c.      Sum Function

d.      Count Function

14.  This type of function calculates the highest value for all the records in a group.

a.      Min Function

b.      Max Function

c.      Sum Function

d.      Count Function

15.    This type of query allows you to combine all the information from the table and put in rows or columns.

a.      Crosstab Query

b.      Action Query

c.      Make-Table Query

16.    This type of query could be used to add records from one table to the other end of the table.

a.      Update Query

b.      Append Query

c.      Delete Query

d.      Make-Table Query

17.     This type of table allows you to make a new table with the records in an existing table.

                  a.  Update Query

b.      Append Query

c.       Delete Query

d.      Make-Table Query

18.    A ____ is a something that acts like a table but isn’t.  It is an active division of a table that highlights and arranges records as specified in the       query. 

a.      Append Query

b.      Report Wizard

c.      Dynaset

19.  Which one of these is not one of the four types of action queries?

a.      Update Query

b.      Crosstab Query

c.      Make-Table Query

d.      Delete Query

20.   Where is the answer to the question that is developed in the design grid displayed?

a.      query

b.      row

c.      dynaset

d.      a table

21.   >, =, =>, <>, and > are all examples of…

a.      dynasets

b.      relational operators

c.      queries

d.      datasheet views

22.  Which view is not part of the Query Window.

a.      Design View

b.      Query View

c.      Datasheet View

d.      SQL View

23.    A Datasheet View can be defined as a view that…

a.      displays a query in a special position

b.      is displayed by default and is used to design a query

c.      shows the designed dynaset

d.      uses SQL to present a query

24.    This type of row allows you to organize data in a descending and ascending sequence. 

a.      Field Row

b.      Sort Row

c.      Show Row

d.      Criteria Row

25.    This is the most common type of query.

a.      Plain Query

b.      Normal Query

c.      General Query

d.      Select Query

26.  This type of function allows you to choose records that lie within two selected quantities.

a.      Not Function

b.      Between Function

c.      Condition Function

d.      Crosstab Function

      27.  This type of function will calculate the total number of records in a set.

a.      Count Function

b.      Between Function

c.      Max Function

d.      Sum Function

28.                                                    28.  Reports are assembled in the ____ and then personalized or tailored as desired in the ______.

29.                                                                            a.  Report Wizard, Calculated Control

30.                                                                            b.  Action Query, Datasheet View

31.                                                                            c.  Datasheet View, Design View

32.                                                                            d.  Report Wizard, Design View

29.                                                    29.  Every report is designed from either a

30.                                                                            a.  table or a control

31.                                                                            b.  query or a function

32.                                                                            c.  table or a function

33.                                                                            d.  table or a query

30.                                                    30.  A crosstab query can best be designed in a…

31.                                                    a.  Datasheet View

32.                                                    b.  Action Query View

33.                                                    c.  Crosstab Query View

34.                                                    d.  Query Design View