1 / 33

Access 2010 Chapter 12 Getting Started with Access Databases

Access 2010 Chapter 12 Getting Started with Access Databases. Objectives. Identify Good Database Design Create a Table and Define Fields in a New Blank Database Change the Structure of Tables and Add a Second Table Create and Use a Query, Form, and Report Save and Close a Database.

chad
Download Presentation

Access 2010 Chapter 12 Getting Started with Access Databases

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 2010 Chapter 12 Getting Started with Access Databases

  2. Objectives • Identify Good Database Design • Create a Table and Define Fields in a New Blank Database • Change the Structure of Tables and Add a Second Table • Create and Use a Query, Form, and Report • Save and Close a Database

  3. Objectives • Create a Database Using a Template • Organize Objects in the Navigation Pane • Create a New Table in a Database Created with a Template • Print a Report and a Table in a Database Created with a Template

  4. Identify Good Database Design • A database is an organized collection of data—facts about people, events, things, or ideas—related to a specific topic or purpose. • Information is data that is organized in a useful manner.

  5. Identify Good Database Design • Use good design techniques when creating a new database. • Determine the information you want to keep track of to create a new database. • Ask yourself, “What questions should this database be able to answer for me?” • The purpose of a database is to store data in a manner that makes it easy for you to get the information you need.

  6. Create a Table and Define Fields in a New Blank Database

  7. Create a Table and Define Fields in a New Blank Database

  8. Create a Table and Define Fields in a New Blank Database

  9. Create a Table and Define Fields in a New Blank Database

  10. Create a Table and Define Fields in a New Blank Database

  11. Create a Table and Define Fields in a New Blank Database • Renaming fields and changing data types

  12. Create a Table and Define Fields in a New Blank Database • Adding a record to a table

  13. Create a Table and Define Fields in a New Blank Database

  14. Create a Table and Define Fields in a New Blank Database • Importing data to an existing Access table

  15. Create a Table and Define Fields in a New Blank Database

  16. Change the Structure of Tables and Add a Second Table • Deleting a table field in Design View

  17. Change the Structure of Tables and Add a Second Table • Viewing a primary key in Design View

  18. Change the Structure of Tables and Add a Second Table • Adding a second table to a database by importing an Excel spreadsheet

  19. Change the Structure of Tables and Add a Second Table • Adjusting column widths

  20. Change the Structure of Tables and Add a Second Table • Printing a table

  21. Create and Use a Query, Form, and Report • A query is a database object that retrieves specific data from one or more database objects—either tables of other queries. • A form is an Access object with which you can enter data, edit data, or display data from a table or a query.

  22. Create and Use a Query, Form, and Report

  23. Create and Use a Query, Form, and Report

  24. Create and Use a Query, Form, and Report • A report is a database object that displays the fields and records from a table or a query in an easy-to-read format suitable for printing.

  25. Create and Use a Query, Form, and Report

  26. Save and Close a Database • When you close an Access table, any changes made to the records are saved automatically. • You will be prompted to save changes to the design of the table or the layout of Datasheet view.

  27. Save and Close a Database

  28. Create a Database Using a Template • A database template contains pre-built tables, queries, forms, and reports to perform a specific task. • You do not have to create the objects. • All you need to do is enter your data and modify the pre-built objects to suit your needs.

  29. Create a Database Using a Template • Creating a new database using a template

  30. Organize Objects in the Navigation Pane

  31. Create a New Table in a Database Created with a Template

  32. Print a Report and a Table in a Database Created with a Template

  33. Print a Report and a Table in a Database Created with a Template

More Related