access lesson 2 vocab

15 terms by 151skl

Create a new folder

Advertisement Upgrade to remove ads

Alphanumeric data-

A combination of numbers and text alphanumeric data

AutoNumber

A field that automatically adds a unique number to the primary key field for each record in the table auto number

Blank Database template-

Creates a database with no objects in it blank database template

Data type

The kind of data that you can enter in the field, such as numbers or text, or a combination of numbers and text data type

Default Value property-

- Enters the same field value in a field every time a new record is added to the table

Description property

An optional field property that you can use to describe what to enter in the field

Design grid

The field names and data types appear in the in the top half of the Table window design grid

Design view

In this view, you can add, delete, and make changes to the way that fields store data design view

Field properties pane-

The bottom half of the Table window that displays field properties field properties pane

Field property

Describes a field's contents beyond the field's basic data type, such as indicating the number of characters the field can store field property

Field Size property

Sets the number of characters you can store in a Text, Number, or AutoNumber field size property

Format property-

Use the Format property to specify how you want Access to display numbers, dates, times, and text format property

Primary key

The field that contains a unique field value for each record in the table primary key

Required property

Specifies whether you must enter a field value in a record required property

Template

Creates the database and one or more table, query, form, and report objects that you use to enter and view data template

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