Advertisement Upgrade to remove ads

Microsoft Access

is a powerful database management system (DBMS) that functions in the Windows Environment and allows you to create and process data in database

Data Entry and Update (KEY FEATURE)

access provides easy mechanisms manipulating mass data in a single operation

Queries (KEY FEATURE)

Using access, it is easy to ask complex questions concerning the data in the data in the data base and recieve instatnt answetrs

Forms (KEY FEATURE)

You can produce attractive and useful forms for viewing and updating data

Reports (KEY FEATURE)

a feature to create sophisticated reports for presenting you data

Web Support(KEY FEATURE)

allows you to save objects, reports, and tables in HTML format

Database

a collection of data organized in a manner that allows access, retrival and use of that data

Records

rows in a table that contain info about a given person, product or event

Field

contains a specific piece of info within a record

Field Name

Each field in the table must have a uique name

Rules

names can be up to 64 characters in legnth, names can contain letters, digits, and most punctuation symbols, names cannot contain periods, exclamation points, accent graves, or brackets, same name can't be used twice

Data type

Indicated to access the type of data the field will contain

data types used

text, number, currency

Description

access allows ou to enter a detailed description of the field

DBMS

DataBase Management System

Unique Identifier

a number assigned to something or someone that can be used more than once

Primary key

another name for a unique identifier

task Pane

a seperate window that enables users to carry outsome Access tasks mre efficiently

create a form using auto form

Autoform button

creating a report

Autorport tab

creating a simple query

Simple Query Wizard

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