Access Exam

Which of the following wildcard characters matches any number of characters? A. * B. # C. " D. $

A. *

Which of the following field validation rules requires the user to enter a value that is less than 5? A. <5 B. <> 0 C. 'M' or 'F' D. Not Null

A. <5

Which of the following logical operators requires that a record meet all of the individual conditions specified in order to be included in the results? A. AND B. OR C. NOT D. NULL

A. AND

Which of the following allows you to build or modify the basic structure or functionality of an object? A. Design view B. Datasheet view C. External data D. Ctrl+N

A. Design view

Which of the following properties indicates the way a field displays in a table? A. Format property B. Lookup property C. Required property D. Caption property

A. Format property

Which of the following is true about the Simple Query Wizard? A. It doesn't allow you to take advantage of all of the options available when creating a query. B. It lets you take full advantage of all of the options available when creating a query. C. It provides great flexibility when creating queries. D. Most people create queries using the Simple Query Wizard.

A. It doesn't allow you to take advantage of all of the options available when creating a query.

Where can you view each object in your database? A. Navigation Pane B. File tab C. datasheet D. Navigation menu

A. Navigation Pane

What is a text box that gets its value from a field in a table? A. bound control B. unbound control C. calculated control D. stacked control

A. bound control

What does Access call a form that is directly connected to a table or query, the source of the data? A. bound form B. connected form C. unbound form D. split form

A. bound form

Which of the following report layouts displays fields in one column? A. columnar B. tabular C. justified D. stepped

A. columnar

In a table, which of the following must be identified as the primary key? A. field B. record C. object D. query

A. field

What is another name for a single unit of data? A. field B. record C. table D. database

A. field

Which of the following relationships describes one row of data in Table A being associated with only one row of data in Table B? A. one-to-one B. one-to-many C. many-to-many D. none of the above

A. one-to-one

Which of the following is a field that contains a unique value for each record? A. primary key B. secondary key C. index D. record selector

A. primary key

Which of the following data types is used to attach pictures, images, and Office files? A. Hyperlink B. Attachment C. Calculated D. Lookup Wizard

B. Attachment

Which of the following data types is used to instruct Access to insert a unique, sequential number each time a new record is added? A. Currency B. AutoNumber C. OLE Object D. Hyperlink

B. AutoNumber

Which of the following allows you to enter, modify, delete, or view data records? A. Design view B. Datasheet view C. External data D. Ctrl+N

B. Datasheet view

When working with forms, which of the following views would you use if you want to view the completed structure of the form so you can modify any aspect of the form? A. Form view B. Design view C. Layout view D. Datasheet view

B. Design view

Which of the following should you use to create a table from scratch? A. Datasheet view B. Design view C. Lookup view D. Validation view

B. Design view

Which of the following data types is used for storing text longer than 255 characters? A. Short Text B. Long Text C. Number D. Currency

B. Long Text

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results? A. AND B. OR C. NOT D. NULL

B. OR

Which of the following symbols must you use when defining a parameter query? A. ( ) B. [ ] C. { } D. / /

B. [ ]

In Access, what are the fields, labels, and buttons called? A. objects B. controls C. commands D. layouts

B. controls

Which of the following is used to create an interface to view, add, update, and delete data in a table? A. report B. form C. query D. module

B. form

Which of the following relationships describes one row of data in Table A associated with many rows of data in Table B? A. one-to-one B. one-to-many C. many-to-many D. none of the above

B. one-to-many

What is a collection of related fields called? A. field B. record C. table D. database

B. record

To initiate the automatic saving of data, what must be done to your table at least once? A. opened B. saved C. backed up D. deleted

B. saved

Which of the following is a collection of related records? A. field B. table C. database D. hierarchy

B. table

Which of the following report layouts displays fields in a row and column format? A. columnar B. tabular C. justified D. stepped

B. tabular

Which of the following data types is used to store the results of a calculation? A. Hyperlink B. Attachment C. Calculated D. Lookup Wizard

C. Calculated

Which of the following tabs do you use to create a query? A. File B. Home C. Create D. Database Tools

C. Create

When working with forms, which of the following views would you use if you want to alter the design of a form and see the effects of the changes in real time? A. Form view B. Design view C. Layout view D. Datasheet view

C. Layout view

Which of the following print options should you use to check that the formatting of a table is appropriate and to make changes to any settings before printing? A. Quick Print B. Print C. Print Preview D. none of the above

C. Print Preview

In Access, what are the different parts of a database application called? A. fields B. data C. objects D. tables

C. objects

Which of the following requires you to enter the specific criteria value when you run the query? A. simple query B. summary query C. parameter query D. Expression Builder

C. parameter query

Which of the following finds data in your database by allowing you to ask a question? A. calculated field B. compound criteria C. query D. parameter

C. query

Which of the following is used to find data in a database? A. report B. form C. query D. table

C. query

What does Access call a form that doesn't have a connection to a data source? A. bound form B. connected form C. unbound form D. disconnected form

C. unbound form

Which of the following properties contains the text that displays in the column header to identify a field in Datasheet view? A. Format property B. Lookup property C. Default Value property D. Caption property

D. Caption property

Which of the following might be necessary in order to override the constraints imposed by enforcing referential integrity? A. control changes B. create new table relationships C. combine tables D. cascade updates and deletes

D. cascade updates and deletes

Which of the following must be assigned to each field in a database? A. primary key B. gridlines C. filter D. data type

D. data type

What is a collection of integrated and related tables? A. field B. record C. table D. database

D. database

What does Access do when data is entered that violates a validation rule? A. displays the Lookup tab B. zooms in on the error C. switches to datasheet view D. displays a message box

D. displays a message box

After you create a query, what must you do in order to see the results? A. select the table to include in the query B. select the fields to include in the query C. enter criterion into the query D. run the query

D. run the query

Which of the following is used to store data records? A. report B. form C. query D. table

D. table

Which of the following describes a pre-designed database? A. object B. blank desktop database C. hierarchy D. template

D. template