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