PowerPoint Presentation to Accompany GO! with Microsoft ® Access 2010 Chapter 1

1. PowerPoint Presentation to Accompany GO! with Microsoft® Access 2010 Chapter 1 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. 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.

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

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

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 • Renaming fields and changing data types

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

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

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

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

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

16. Change the Structure of Tables and Add a Second Table • Viewing a primary key in design view

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

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

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

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

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

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

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

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

25. 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 design of the table or the layout of Datasheet view.

26. Save and Close a Database

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

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