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

Access PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

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

Download Presentation


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



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



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