Microsoft Access skills questions:

1. Which of the following is not one of the three elements you specify for each field in Design view?

   a.	description
   b.	sort order
   c.	data type
   d.	field name

1 points   

1. When you create a new table in Design view, Access automatically assigns the first field the name _____ and assigns the _____ data type.

   a.	ID; AutoNumber
   b.	Notes; Memo
   c.	UniqueID; Number
   d.	KeyField; Text

1 points   

1. When typing a description, you should consider identifying the field’s purpose or contents or

   a.	providing instruction on how to merge the information with a query.
   b.	inserting code to enhance the design of the table.
   c.	providing instructional information for data entry.
   d.	typing the name and position of the person creating the table.

1 points   

1. Which of the following data types is automatically filled when a new record is added?

   a.	AutoNumber
   b.	Attachment
   c.	Lookup Wizard
   d.	Hyperlink

1 points   

1. When you set a default value for a field in a table that already contains data, what happens to the existing entries?

   a.	Individual records are filled with the default value the next time you edit them.
   b.	If they are blank, they are immediately filled with the default value.
   c.	They are filled with the default value the next time you open the table.
   d.	Nothing happens.

1 points   

1. An input mask is a _____ that controls what you can and cannot enter in a field.

   a.	default override setting
   b.	second language
   c.	set pattern
   d.	copy of your database

1 points   

1. If you want to limit the data entered into a field to a list of specific items, use the

   a.	Default Value property.
   b.	Validation Rule property.
   c.	Input Mask Wizard.
   d.	Lookup Wizard.

1 points   

1. The _____ property box allows you to enter a conditional test that is checked each time data is entered into a field.

   a.	Caption
   b.	Default Value
   c.	Validation Rule
   d.	Format

1 points   

1. When you delete a field in a table, what happens to the data stored in that field?

   a.	It is stored in a temporary field.
   b.	It is deleted but can be restored from the Recycle Bin.
   c.	It is permanently deleted.
   d.	It is stored as a separate table.

1 points   

1. When using the Find and Replace dialog box, by default Access will search in

   a.	the first column in the table.
   b.	all tables in the database.
   c.	the entire active table.
   d.	the column where the insertion point is positioned.

1 points   

1. Forms are useful for focusing on

   a.	an entire table at a time.
   b.	records that have been previously deleted.
   c.	a single record at a time.
   d.	a group of related records on a single screen.

1 points   

1. A _____ is an object you can use to enter and edit data in a table or query.

   a.	file
   b.	field
   c.	form
   d.	database

1 points   

1. If you delete a form from your computer’s hard drive, can the form be retrieved? If so, how?

   a.	Yes; the form can be retrieved by clicking the Undo button on the Quick Access toolbar.
   b.	Yes; the form can be retrieved from the Recycle Bin.
   c.	No; the form cannot be retrieved because it will be permanently deleted.
   d.	Yes; the form can be retrieved by right-clicking in the Navigation pane, and then clicking Retrieve Form at the shortcut menu.

1 points   

1. What happens when you create a form from a table that has a one-to-many relationship with another table?

   a.	Access adds a datasheet to the form that is based on the related table.
   b.	Access adds the fields from the related table side-by-side with fields from the primary table.
   c.	Access will not be able to create the form.
   d.	Access creates a second, separate form for the related table.

1 points   

1. If you create a form based on a table that has multiple one-to-many relationships, Access will

   a.	display a datasheet for each related table.
   b.	combine data from all related tables into a single datasheet.
   c.	create a separate form for each related table.
   d.	not display any datasheets based on the related tables.

1 points   

1. A form is made up of a series of

   a.	datasheets.
   b.	control objects.
   c.	queries.
   d.	tables.

1 points   

1. When Access creates a form from a table, the first column in the form contains

   a.	roman numerals.
   b.	sequential numbers.
   c.	the field values.
   d.	the label control objects.

1 points   

1. When Access creates a form from a table, what is displayed in the second column?

   a.	check box control objects
   b.	field values in text box control objects
   c.	field names in label control objects
   d.	field descriptions in label control objects

1 points   

1. To add an existing field to a form, display the form in _____ view and then click the Add Existing Fields button.

   a.	Form
   b.	Print Preview
   c.	Layout
   d.	Datasheet

1 points   

1. In a split form, the top half of the form displays the data in _____ view while the bottom half displays the data in _____ view.

   a.	Form; Layout
   b.	Design; Datasheet
   c.	Layout; Design
   d.	Layout; Datasheet