Access Exam

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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