How can we help?

You can also find more resources in our Help Center.

Microsoft Access

STUDY
PLAY
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