1 / 14

Access

As an office worker at Rio Rancho Auto Gallery, tasked with analyzing vehicle sales for compacts, sedans, SUVs, and trucks during January, February, and March, you will create an Access database to manage this information. Begin by opening Access and selecting a new blank database, then define and name your fields such as vehicle type and sales figures. Enter the sales data, create additional tables if needed, and use queries to generate reports summarizing sales for each vehicle type over the specified months.

fell
Télécharger la présentation

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access Database for non-IT individuals

  2. 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?

  3. Excel Spreadsheet

  4. 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.

  5. Structure of a database • Table(s) • Fields (columns) • Name • Data type • [Size] • Records (rows) • Queries • Forms • Reports

  6. 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.

  7. Texas Lakes Medical Center • Patients • Doctors

  8. Patient Table

  9. Doctor Table

  10. Start Access and Create a New Blank Database

  11. Define Fields

  12. Enter Data

  13. Define Fields

More Related