Microsoft Access Basics

Download Report

Transcript Microsoft Access Basics

Created by:
Tanya Morgan


Access is the database software of the
Microsoft Office suite.
A database is a collection of objects that work
together to:
◦
◦
◦
◦
Store data
Retrieve data
Display data
Summarize data


DBMS stands for DataBase Management
System
A DBMS allows you to store, retrieve, analyze,
and print information
◦ Example: Filing cabinet

A computerized DBMS is
◦ much faster
◦ more accurate
◦ more flexible
Quick Access
Toolbar
Title
Bar
Ribbon
Shutter Bar
Open/Close
Button
Tab for the displayed
object
Status Bar
Tab for open
object




Table – stored in a format called a datasheet
Query – Use to search for and retrieve data
from tables using conditions
Form – Displays data from tables/queries
similar to a paper form
Report – Displays data in a format that is
customized for on-screen viewing or printing
◦ Used to summarize data and calculate totals


Macro – Automates database operations
Module – Similar to a macro; allows more
complex programming of database
operations

Record – A complete set of data.
◦ Example: All information about 1 movie from your
Music and Movies database

Field – A single characteristic within a record.
◦ Example: The actor/actress of a movie

Field name – Name of a column/field in a
datasheet.

Field value – Data entered into a field.
Datasheet View – Displays data in rows and

Design View- View that allows you to add,

columns.
delete, and rearrange fields
Record
Current
Record
First record button
Previous record
button
Last record
button
Next record
button
New (blank) record
button

Field selector
◦ Appears at the top of each column
◦ Contains the field name
◦ Allows you to select the entire field column

Record selector
◦ Appears to the left of the first field
◦ Allows you to select the entire record

Datasheet selector
◦ Box in the upper-left corner of a datasheet
◦ Allows you to select all records and fields of a
datasheet
Field Selector
Record
Selector
Datasheet Selector



Template – Creates the database and one or
more table, query, form, and report objects
Blank Database Template –Creates a
database with no objects in it
The Access 2007 name extension is…. accdb




Primary key – The field that contains a
unique field value for each record in the
table.
AutoNumber – Automatically adds a unique
number to the primary key field for each
record in the table
Data type – Determines the kind of data that
you can enter in the field
Alphanumeric data – A combination of
numbers and text
#






Text
Memo
Number
Date/Time
Currency
AutoNumber





Yes/No
OLE Object
Hyperlink
Attachment
Lookup Wizard





Design View – Add, delete, and make
changes to the way that fields store data
Design grid – Top half of the Table Window
in Design View
Field Properties pane – Bottom half of the
Table window in Design View
Field Property – Describes a field’s contents
beyond the field’s basic data type
Field Size Property – sets the number of
characters you can store in a text, number, or
AutoNumber field
Current Field
Primary key
symbol
Design
Grid
Field
Properties
Pane