NC Computer Apps I, 5.01 Course Notes

32 terms by dperks

Create a new folder

Advertisement Upgrade to remove ads

Database

is a tool used to organize, store, retrieve, and communicate groups of related information.

table

is an arrangement of columns and rows. It is the fundamental building block of all databases. They are used to group and organize the information within a database.

Entry

is a single piece of data in a database table.

Field

is a grouping or category of similar information contained in a table; a unique identifier for a category of information

record

is a complete description of all of the fields related to one item in a table.

Data types

used to control how data in a particular field will be searched, sorted, or used in calculations. The default format is text.

Text

used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations.

Memo

a data type used for lengthy entries that allows combinations of text and numbers

Number

used for data that may be calculated, sorted, or filtered.

Date/time

data type used to arrange and sort data chronologically, often used with the input mask field property

Currency

data type used to format numbers as decimal values with a dollar sign. The default format for currency is two decimal places.

Auto Number

used to automatically assign a number to each record and to assist in preventing duplication of data.

Yes/No

a data type in toggle format that allows a user to select a yes or no value in a database cell. The default setting is No.

Lookup Wizard

a data type used to define preset values for database entries. This feature increases productivity and accuracy by reducing the amount of data entry required.

Field properties

used to control how data is entered in a field

Field size

used to control the size of the field, measured in characters

Format

used to control the layout of the field, such as one or two decimal places

Input Mask

a template-like field property that regulates how data is entered in a cell. For example, if the phone number input mask is used, the user will be prompted to input data in a specific format, such as (919) 555-5555.

Caption

a field property used for column naming that allows a more user-friendly and properly formatted field name than the field name stored in the database design

Filters

allow for the retrieval of information that meets specific criteria.

Filter by Selection

filters for information related to an active cell

Advanced Filter Sort

used to define specific search criteria

Sorts

allow for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending.

Database Relationship

a link between two or more tables in a database

One-to-Many

a type of relationship that occurs when a record in one table is linked to more than one record in another table.

Many-to-Many

relationships are formed by connecting two or more tables that have a one-to-many relationship. The connection is made by a Junction Table.

Primary Key

used to format each record in a database as a unique entity. Primary keys allow database tables to communicate.

Foreign key

when tables are linked by the primary key, the related field in the second table is known as the foreign key

Junction table

a table used to join primary key fields from multiple tables

Join line

a graphical representation of the link between two or more tables

Referential integrity

protects related data that is stored in multiple tables.

Raw Data Import

A useful and practical method for obtaining information from other sources and creating database tables. Eliminates the need for repetitive data entry and assists in the protection of the data's integrity.

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