MS Access Tutorial - PowerPoint PPT Presentation

Loading...

PPT – MS Access Tutorial PowerPoint presentation | free to download - id: 4a450d-YjUzO



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

MS Access Tutorial

Description:

MS Access Tutorial MGMT 683 J. Rees Introduction MS Access is a relational database management system (RDBMS) Other PC-based RDMBS include: MS FoxPro Borland dBase ... – PowerPoint PPT presentation

Number of Views:235
Avg rating:3.0/5.0
Slides: 25
Provided by: KrannertC
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: MS Access Tutorial


1
MS Access Tutorial
  • MGMT 683
  • J. Rees

2
Introduction
  • MS Access is a relational database management
    system (RDBMS)
  • Other PC-based RDMBS include
  • MS FoxPro
  • Borland dBase
  • Industrial-strength RDBMS include
  • Oracle
  • MS SQL Server
  • IBM DB2
  • Informix

3
Getting Started
  • Open MS Access (Under Microsoft Office 2003
    heading)
  • Open a New Database

4
Select Blank Database
5
Name your database MyShop.mdb
Now click Create. Everything you create for
this database will be saved as an .mdb file.
6
MS Access Functionality
  • Tables
  • Store Data
  • Queries
  • Manipulate Data
  • Forms
  • Make data entry and display easier
  • Reports
  • Provides information from database to users in
    easy-to-understand format

7
Business Example
  • Your sister has started her own home-décor shop.
    She sells items such as candles, pictures and
    knick-knacks. She wishes to track the items in
    her inventory, sales and customer information.
    You agree to assist her in setting up a simple MS
    Access database that will track the appropriate
    information.

8
Business Example, Continued
  • You identify that three tables should be created
  • Product Table containing the product number,
    product name, product description, product price,
    and product on hand.
  • Sale Table containing the sale number, sale
    date, the product sold and the customer.
  • Customer Table containing the customer number,
    customer last name, customer first name, phone
    number, address and notes about customer
    preferences (notify if a Yankee Candle Company
    candle comes in, etc.)

9
Creating Tables
Double click Create table in Design view
10
Creating the Product Table
11
Enter the table information
Next Create the primary key and save your table
12
Creating Tables
  • Create the Sales and Customer Tables
  • Use AutoNumber for the Sales Number and Customer
    Number
  • Remember to set the primary key and save your
    tables

13
Entering Data
  • Enter the following data into each of your tables

14
Entering Data, Continued
15
Relationships
16
Select Tables to be Linked
17
Link the three tables together
18
Queries
  • Queries allow data to be manipulated
  • What were the total sales today?
  • How many of my customers come from out of town?

19
  • Run this query
  • Create query to determine customers who do not
    live in Lafayette

20
Forms
  • Provide a user-friendly interface to the data.
  • Control over users additions and modifications
    to the data.
  • Forms (like queries reports) do not contain
    data. Data is always saved in tables.

21
Create a new form using wizard
22
Create the Product Form
23
Select fields to appear on your form
24
Reports
  • Reports display the output of tables, forms,
    and/or queries in a formatted manner.
  • Create reports for each query using the Report
    Wizard
About PowerShow.com