U.S Inventors and Inventions

1. U.S Inventors and Inventions none Unit 4 Project 18

2. OUR EXPLORATION ASSIGNMENTCreating a New Database Containing an Empty Table; Adding Table Fields and Setting Table Properties in Datasheet View; and Using the Access Wizards to Create a Form, Query, and Report • OBJECTIVES: • In this project, you will: • add fields to an empty table in Datasheet view • create a form using the Form Wizard • create a query using the Simple Query Wizard • create a report using the Report Wizard Unit 4 Project 18

3. Starting Out! • Start the Access application and then create, name, and save a new database containing an empty table. • Start the Access application. • Create a new blank database containing an empty table. Save the new database as inventors18 solution. Unit 4 Project 18

4. TRAIL MARKER 1Adding Fields to an Empty Table in Datasheet View • Add data to the first row and allow Access to set the Data Type property and assign temporary field names. • Key Sarah (Madame C.J.) in the first field in record 1 and tap the TAB key. Key Walker and tap the TAB key. • Key 1867-1919 and tap the TAB key. Key African-American hair care and cosmetics and tap the TAB key. • Key The Black Inventor Online Museum and tap the Down arrow to save the record. Unit 4 Project 18

5. TRAIL MARKER 1Adding Fields to an Empty Table in Datasheet View • Rename the table fields, then switch to Design view and add captions to two fields. • Double-click the Field1 column header to select the field name; then key FirstName. • Double-click the Field2 column header; then key LastName. • Continue renaming fields. (continued) Unit 4 Project 18

6. TRAIL MARKER 1Adding Fields to an Empty Table in Datasheet View • Rename the table fields, then switch to Design view and add captions to two fields. • Tap the ENTER key after keying the Source field name; then save the table as 19th-century Inventors and switch to Design view. • Add the First Name caption property to the FirstName field and the Last Name caption property to the LastName field. • Save the table and switch back to Datasheet view. Unit 4 Project 18

7. TRAIL MARKER 1Adding Fields to an Empty Table in Datasheet View • CHECKPOINT • Your modified table in Datasheet view should now look similar to this. Unit 4 Project 18

8. TRAIL MARKER 2Creating a Form Using the Form Wizard • KEYWORD • Form Wizard Unit 4 Project 18

9. TRAIL MARKER 2Creating a Form Using the Form Wizard • Use the Form Wizard to create a data entry form. • Click the Form Wizard button in the Forms group on the Create tab. • Double-click the First Name, Last Name, Period, Invention, and Source field names in the Available Fields list to add them to the Selected Fields list. (continued) Unit 4 Project 18

10. TRAIL MARKER 2Creating a Form Using the Form Wizard • Use the Form Wizard to create a data entry form. • Click the Next button. Click the Columnar option button and click the Next button. • Key Inventors Data Entry in the What title do you want for your form? text box. Click Finish. • The new form opens in Form view. Unit 4 Project 18

11. TRAIL MARKER 2Creating a Form Using the Form Wizard • CHECKPOINT • Your new form should look like this. Unit 4 Project 18

12. TRAIL MARKER 2Creating a Form Using the Form Wizard • Use the Form Wizard to create a data entry form. • Click the More Forms button in the Forms group on the Create tab. • Click Form Wizard. • Double-click the First Name, Last Name, Period, Invention, and Source field names in the Available Fields list. (continued) Unit 4 Project 18

13. TRAIL MARKER 2Creating a Form Using the Form Wizard • Use the Form Wizard to create a data entry form. • Click the Next button. Click the Columnar option button and click the Next button. • Click the Access 2007 style. Click Next. • Key Inventors Data Entry as the form name and click the Finish button. Unit 4 Project 18

14. TRAIL MARKER 2Creating a Form Using the Form Wizard • CHECKPOINT • Your new form should look like this. Unit 4 Project 18

15. TRAIL MARKER 2Creating a Form Using the Form Wizard • Use the Inventors Data Entry form to enter the remaining records. • Using the data provided in your text, enter the remaining records. • Close the form when finished and open the table in Datasheet view. • Resize the columns as necessary and save the table’s layout changes. Unit 4 Project 18

16. TRAIL MARKER 3Creating a Query Using the Simple Query Wizard • Use the Simple Query Wizard to quickly create a query. • Click the 19th-century Inventors table name in the Navigation Pane. • Click the Query Wizard button in the Queries group on the Create tab. • Click Simple Query Wizard in the list of wizards and click OK. (continued) Unit 4 Project 18

17. TRAIL MARKER 3Creating a Query Using the Simple Query Wizard • Use the Simple Query Wizard to quickly create a query. • Double-click the FirstName, LastName, and Invention field names. • Click the Next button. • Key Inventors and Their Inventions in the What title do you want for your query? text box. Click Finish.Now close the query datasheet. Unit 4 Project 18

18. TRAIL MARKER 3Creating a Query Using the Simple Query Wizard • CHECKPOINT • Your query datasheet should look like this. Unit 4 Project 18

19. TRAIL MARKER 3Creating a Query Using the Simple Query Wizard • Use the Simple Query Wizard to quickly create a query. • Click the 19th-century Inventors table name in the Navigation Pane. • Click the Query Wizard button in the Other group on the Create tab. • Click Simple Query Wizard in the list of wizards and click OK. (continued) Unit 4 Project 18

20. TRAIL MARKER 3Creating a Query Using the Simple Query Wizard • Use the Simple Query Wizard to quickly create a query. • Double-click the FirstName, LastName, and Invention field names. • Click the Next button. • Key Inventors and Their Inventions as the query name. Click Finish. • Close the query datasheet. Unit 4 Project 18

21. TRAIL MARKER 3Creating a Query Using the Simple Query Wizard • CHECKPOINT • Your query datasheet should look like this. Unit 4 Project 18

22. TRAIL MARKER 4Creating a Report Using the Report Wizard • KEYWORD • Report Wizard Unit 4 Project 18

23. TRAIL MARKER 4Creating a Report Using the Report Wizard • Create a report with the Report Wizard. • Click the Inventors and Their Inventions query name in the Navigation Pane. • Click the Report Wizard button in the Reports group on the Create tab. • Click the double right arrows (>>) to add all three fields to the Selected Fields list. (continued) Unit 4 Project 18

24. TRAIL MARKER 4Creating a Report Using the Report Wizard • Create a report with the Report Wizard. • Click the Next button twice. Click the first arrow and click LastName. Click Next. • Click the Tabular and Portrait option buttons; then click Next. • ( Select the Access 2007 style for your report.) • Click Next. Key List of Inventors as the report name. • Click Finish. Close Print Preview and close Access. Unit 4 Project 18

25. TRAIL MARKER 4Creating a Report Using the Report Wizard • CHECKPOINT • Your report in Print Preview should look like this. Unit 4 Project 18

26. Project Skills Review (continued) Unit 4 Project 18

27. Project Skills Review Unit 4 Project 18