Transcript MS Access Tour

MS Access Tour
Sesión # 6
MS Access Tour
Database Management System
(DBMS):
An application software that allows
users to create, manipulate, and
change a database for a particular
data model.
MS Access is a Relational DBMS,
for one user at a time.
MS Access Tour
MS Access provides diverse features
to create and manipulate database
objects:
Tables
Forms
Reports
Queries
MS Access Tour
To find MS Access in a PC:
Click on “Start”
Click on “Programs”
Click on “Applications”
Click on “MS Office 2003”
Click on “MS Access 2003”
MS Access Tour
To create a database:
Click on “File”
Click on “Blank database”
Save in “Desktop”
Choose a name “name.mdb”
Click on “Create”
Now you have a new database !
MS Access Tour
You could create a table by:
Design view
Using a wizard
Entering data
Let’s use the wizard !
MS Access Tour
To create a table with the wizard:
Select a type of table (“customers”)
Select sample fields (“ID”, “name”)
Save your work !
See the fields in your table:
By design view
By datasheet view
MS Access Tour
The design view shows:
Field name
Data type
Key
The design view allows you to:
Revise your data model
Add new fields
Rename the fields
MS Access Tour
The datasheet view shows:
Field name
Actual field values
Pre-defined row number
The datasheet view allows you to:
Enter data
MS Access Tour
To create a form with the wizard:
Select “Form” under “Objects Menu”
Select “Create a form using the wizard”
Select a table in the wizard
Select the fields you need in your form
Select “Finish”
See the window that shows up in the
screen
Save your work !
MS Access Tour
A form allows you to:
Enter data
See already existing data
Use a navigation menu at the
bottom of the screen
MS Access Tour
To create a report with the wizard:
Select “Report” under “Objects Menu”
Select “Create a report using the wizard”
Select a table in the wizard
Select the fields you need in your report
Select “Finish”
A report shows up in a new window
Save your work !
MS Access Tour
Other features of interest:
Queries
Pages
Macros
E-R Diagrams