tailieunhanh - Lecture Business driven technology (Technology plug-in): Chapter 8 - Paige Baltzan, Amy Phillips

Chapter 8 - Decision making using access. Learning objectives of this chapter include: Describe the steps for creating a form using the form wizard in access, describe the steps for creating and saving autoforms using Access, describe the steps to modify the properties of a form using access, describe the steps for creating a report using the report wizard in access, describe the steps to modify the properties of a report using access. | TECHNOLOGY PLUG-IN T8 Decision Making Using Access LEARNING OUTCOMES Describe the steps for creating a form using the Form Wizard in Access Describe the steps for creating and saving AutoForms using Access Describe the steps to modify the properties of a form using Access Describe the steps for creating a report using the Report Wizard in Access Describe the steps to modify the properties of a report using Access INTRODUCTION A form is nothing more than a graphical representation of a table You can add, update, and delete records in your table by using a form A report is an effective way to present your data in a printed format You have control over the size and appearance of everything on a report, you can display the information the way you want to see it FORMS An Access form is a window that contains a set of controls to view, enter, or edit database information, typically one record at a time In a form, data are obtained directly from one or more tables or data that have been . | TECHNOLOGY PLUG-IN T8 Decision Making Using Access LEARNING OUTCOMES Describe the steps for creating a form using the Form Wizard in Access Describe the steps for creating and saving AutoForms using Access Describe the steps to modify the properties of a form using Access Describe the steps for creating a report using the Report Wizard in Access Describe the steps to modify the properties of a report using Access INTRODUCTION A form is nothing more than a graphical representation of a table You can add, update, and delete records in your table by using a form A report is an effective way to present your data in a printed format You have control over the size and appearance of everything on a report, you can display the information the way you want to see it FORMS An Access form is a window that contains a set of controls to view, enter, or edit database information, typically one record at a time In a form, data are obtained directly from one or more tables or data that have been extracted using a query Creating A Form Using The Form Wizard To create a form using the Form Wizard: Open the file Click the Create tab Click the More Forms button, and then click Form Wizard Click the Tables/Queries drop-down arrow and select Table: BIKE Add all BIKE fields by clicking on the double right arrow (>>) Click Next Select the Columnar form layout Click Next Select the Office style Click Next Type in BIKE FORM for a form title. Click Finish to open the form and begin entering data Creating A Form Using The Form Wizard Accessing Several Tables or Queries in a Form When you select the fields for your form in the first Form Wizard dialog box, you can add fields from several tables or queries To add fields from each table or query, select it in the Tables/Queries drop-down list and then use the buttons to move the fields you want to the Selected Fields list Creating And Saving Forms To use the AutoForm Wizard to create a Columnar Form: In the Navigation