Access
Download
1 / 14

Access - PowerPoint PPT Presentation


  • 102 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Access' - fell


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?



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








ad