6.00 Database Software

Created by mooreemily 

Upgrade to
remove ads

Ascending

sorting from smallest to largest Example: A-Z or 0-9

Connectors

words like OR and AND used in searching databases which indicate whether records satisfy one rule (OR) or if both rules must be satisfies (AND)

Counter Field

used in many databases to identify each record uniquely, like creating a unique invoice number in an invoice database. Also known as a Primary Key in some programs.

Data

the information that is entered into the computer for processing

Database

an electronic filling system that stores and retrieves information

Database Report

allows one to organize, summarize, and print selected portions of a database

Datasheet View

displays the table in a row-and-column format

Data Type (Format)

the different types of data entered in a database, i.e., number, text, date/time, etc.

Date and Time Field

used for storing dates and times in specific format to allow you to do such things as age an account or time event

Descending

sorting from largest to smallest Example: Z-A or 9-0

Design View

displays the field names and what kind of values you can enter in each field. In this view you can define or modify the field formats and create field names and data types for a database.

Editing

to make changes to the information in a database

Enter/Entering

to type information into a field in a database

Entry

the information that is entered in the fields in a database

Field

a category of information in a database

Field Name

a label at the top of a database column that describes the kind of information to be stored in the column

File

a group of records Also known as a Table in some programs

Filter/Query/Search

a feature that displays records that meet one or more specific criteria.

Form View

displaying one record at a time

List View

displaying more than one record at a time

Logical View

can be one of two entries, basically YES or NO (or ON or OFF or TRUE or FALSE)

Memo Field

used for information that does not fit easily into a category such as notes or comments

Numeric Field

used to store purely numeric information

Object Field

used for other media types that might include a picture of an employee or product, a sound file, a clip-art image, or any other type of non-text entry

Operators

words or symbols such as less than(<), greater than(>), or equal to(=)

Record

a complete set of field entries

Record Number

the number that identifies the sequence of a record in a database

Report

a display of records or parts of records that satisfy a particular search or sort

Sorting

arranging information in alphabetical or numerical order

Text Field

used to store alphanumeric information You may also hear this type of field called a character field

Wildcards

The symbol * or asterisk is considered a wildcard character If you don't know the spelling of a word or you want to search plurals or variations of a word, use the wildcard character

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