Data Management Access

1
Data Management - Access
Presented by
Kimberly Crowe
October 30, 2003
2
Data Management - Access

• About Access Databases

• About Designing a Database

• About Sharing a Database on a Network

• Examples

• Access 2002 Tips

3
Access Various Versions
4
About Access Databases

• Table to store your data

• Queries to find and retrieve just the data you
  want

• Forms to view, add, and update data in tables

• Reports to analyze or print data in a specific
  layout

• Data Access Pages to view, update, or analyze the
  databases data from the Internet or intranet

5
Access - Table

• Create a Table

• Create the Table by Design View

• Create the Table by Using Wizard

• Create the Table by Entering Data

• Subdatsheets

• Define relationships between tables

Table.mdb
6
(No Transcript)
7
Access - Queries

• Select Queries

• Parameter Queries

• Crosstab Queries

• Action Queries

• Delete Queries

• Update Queries

• Append Queries

• Make-Table Queries

Query.mdb

• SQL Queries

8
(No Transcript)
9
Access - Forms

• Data-Entry Form

• Subform

• Switchboard Form

Form.mdb
10
Access - Reports

• Create Mailing Labels

• Show Totals in a Chart

• Group Records into Categories

• Calculate Totals

Report.mdb
11
Designing a Database

• Determine the purpose of your database

• Determine the fields you need in your database

• Determine the tables you need in the database

• Determine which table each filed belongs to

• Determine the relationship between tables

Design.mdb
12
Sharing an Database on a Network

• Share the entire Access database

• Share only the tables in the Access database

• Replicate the Access database

• Create a client/server application

• Edit data in a shared database

Share.mdb
13
Access 2002 Tips

• Recycle Access Tables

• Set Up Your Access Database to Automatically
• Compact and Repair

• Shortcut to Insert Time/Date in Access

• Changes the Default Style for Controls in Access

• Print a Map of Table Relationships in Access 2002

Tips.mdb
14
Data Management - Access
?