Transcript Creating Tables

Microsoft Access
What is Access?


Access is a database software that
tracks information for businesses or
individuals.
Access is a relational database
management system (RDBMS).
What Makes Up a Database


Objects are elements in a database.
Objects can be stored, displayed,
selected, or perform an action.

Objects include: tables, queries, forms,
reports, pages, macros, and modules.
Object Descriptions



There are several objects in a Database:
Tables – store information about a person,
place, or thing.
Information within a table appears in records
(rows) and fields (columns).


Records – contain data about one entity.
Fields – data elements within a record.
Queries




Queries are used to answer questions
about data.
They can show fields from one or more
tables.
Conditions for queries can be specific
Queries can be used to calculate totals
or averages from information in the
table.
Forms



Forms allow you to view, edit, or add
records.
Reports
Reports are used to print data.
They can be grouped, calculated,
formatted differently, and enhanced by
the use of graphics.
Database Title bar
Object bar
Database Window
Creating Tables
Microsoft Access
Table Wizard




Select File new, blank database from
the Task Pane.
Assign a Name to the Database, click
create
Click new for a new object and click
open to open an existing object
Click Table Wizard



Select Business or Personal
Select Sample Tables and Sample
Fields to complete the creation of
Rows and columns for a Table.
Name your Table.
Datasheet View

Allows you to view and edit or
add data to a Table.




Delete fields and records
Add fields and records
Rename fields and records
Shift F2 allows you to add a
comment to a record
Design View


Allows you to add fields or make
changes to the overall formatting and
properties of a table.
The Design View is made up of
Elements:

Field Name, Data Type, Description and
Field Properties.
The Field Name Element

Purpose




Identifies the data.
Can contain up to 64 characters
Alphabetic and numeric characters can
be used
., [], ! Or accent marks cannot be used
The Data Type Element

Purpose:


Specifies the type of information to be
entered into the field.
There are 9 data type that can be used
The Description Element

Purpose:

It is an optional field and provides
clarification of a fields purpose.
The Field Properties Element

Purpose:

Provides the characteristics or attributes
of a field that control how the data is
stored and displayed.