Access 2010 Chapter 12 Getting Started with Access Databases

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