Access
This presentation is the property of its rightful owner.
Sponsored Links
1 / 14

Access PowerPoint PPT Presentation


  • 80 Views
  • Uploaded on
  • Presentation posted in: General

Access. Database for non-IT individuals. Job Task.

Download Presentation

Access

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Access

Access

Database for non-IT individuals


Job task

Job Task

You are an office worker for Rio Rancho Auto Gallery. Your company sells four types of vehicles (compacts, sedans, SUVs, and trucks). Your boss wants you to find out how much sales the company did in January, February, and March for the various types of vehicles sold. How would you go about doing this?


Excel spreadsheet

Excel Spreadsheet


Database

Database

A repository of data that can be accessed in order to produce information for decision making.

Data is the facts about an entity, such inventory, sales, employees, customers.

Information is data organized in order to provide meaningful results for decision making.


Structure of a database

Structure of a database

  • Table(s)

    • Fields (columns)

      • Name

      • Data type

      • [Size]

    • Records (rows)

  • Queries

  • Forms

  • Reports


Creating a database

Creating a database

  • Open Access

  • Select blank database or use a template

  • Name the fields (columns) for the default table

  • Save and name the table

  • Modify any data types (numeric and auto number)

  • Enter the data for each record (row)

  • Create additional table(s) as required

  • Process the data using queries, forms, and/or reports.


Texas lakes medical center

Texas Lakes Medical Center

  • Patients

  • Doctors


Patient table

Patient Table


Doctor table

Doctor Table


Start access and create a new blank database

Start Access and Create a New Blank Database


Define fields

Define Fields


Enter data

Enter Data


Define fields1

Define Fields


  • Login