Microsoft Access Chapter 3 worksheet/study guide

25 terms by bbbeeelllllleee 

Create a new folder

Advertisement Upgrade to remove ads

Microsoft Access

A _____ field is a field that contains more than one value.

multivalued

A _____ value is a value that Access will display on the screen in a particular field before the user begins adding a record.

default

Changing a column width changes the _____, or design, of a table.

layout

A _____ key is a field in one table whose values are required to match the primary ke of another table.

foreign

To create a simple form, select the table in the Navigation Pane, click Create on the Ribbon and then click the _____ button on the Create tab.

form

To delete a field from the table, open the table in _____ view, click the row selector for the field to be deleted and then press the DELETE key.

design

A ____ field allows the user to select from a list of values.

lookup

To create a multivalued field, create a _____ field being sure to check the Allow Multiple Values check box.

lookup

To create an update query, create a new query and then click the ____ button on the Design tab.

update

To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then click the _____ button to update the records.

run

To specify that entries in the Amount Paid field must be between $0.00 and $100,000.00, enter _____ in the Validation Rule property box.

>=0 and <=100000

To indicate that the only allowable values for the Client Type field are MED, DNT, and LAB, enter _____ in the Validation Rule property box.

=MED or =DNT or =LAB

If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is _____.

>

To create a Lookup field, select _____ from the menu of available data types.

lookup wizard

A(n) _____ query adds, deletes, or changes data in a table.

action

When an update query is created, a(n) _____ row displays in the design grid.

update to

The property that the value in a foreign key must match another table's primary key is called _____.

referential integrity

When specifying referential integrity, one way to handle deletions is to _____; that is, have Access allow the deletion but then automatically delete any related records in other tables.

cascade the delete

When specifying referential integrity, one way to handle the update of a primary key is to _____; that is, have Access allow the update but then automatically make the corresponding change in any related records in other tables.

cascade the update

To open the Relationships window, click the _____ button on the Database Tools tab.

relationships

The infinity symbol indicates that one recruiter is related to _____ clients.

many

Relationships are created by clicking the _____ check box in the Edit Relationships dialog box.

enforce Referential Integrity

To print a copy of a relationship, click the _____ button.

relationship report

JSP would like to make sure that if an employee enters the letters co in the State field that it displays in the database as CO. What property do you need to change and what would you enter in the property box?

format, >

Because most clients that JSP services are located in Colorado, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?

default value, CO

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set