Bài giảng Business Driven Technology - Technology plug-in T8 - Decision Making Using Access

TECHNOLOGY PLUG-IN T8Decision Making Using AccessLEARNING OUTCOMESDescribe the steps for creating a form using the Form Wizard in AccessDescribe the steps for creating and saving AutoForms using AccessDescribe the steps to modify the properties of a form using AccessDescribe the steps for creating a report using the Report Wizard in AccessDescribe the steps to modify the properties of a report using AccessINTRODUCTIONA form is nothing more than a graphical representation of a tableYou can add, update, and delete records in your table by using a formA report is an effective way to present your data in a printed formatYou have control over the size and appearance of everything on a report, you can display the information the way you want to see itFORMSAn Access form is a window that contains a set of controls to view, enter, or edit database information, typically one record at a timeIn a form, data are obtained directly from one or more tables or data that have been extracted using a queryCreating A Form Using TheForm WizardTo create a form using the Form Wizard:Open the file T8_SlopesideBikes_Data.mdbClick the Create tabClick the More Forms button, and then click Form WizardClick the Tables/Queries drop-down arrow and select Table: BIKEAdd all BIKE fields by clicking on the double right arrow (>>)Click NextSelect the Columnar form layoutClick NextSelect the Office styleClick NextType in BIKE FORM for a form title.Click Finish to open the form and begin entering dataCreating A Form Using TheForm WizardAccessing Several Tables or Queries in a FormWhen you select the fields for your form in the first Form Wizard dialog box, you can add fields from several tables or queriesTo 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 listCreating And Saving FormsTo use the AutoForm Wizard to create a Columnar Form:In the Navigation Pane, select the CUSTOMER tableClick on the Create tab, and then click on the Form buttonAccess automatically creates a Columnar Form based on the CUSTOMER table you selected.Since the CUSTOMER table has a linked relationship to the RENTAL table, Access displays the RENTAL table contents associated with the CUSTOMER informationClose the form by clicking the Close box in the upper-right cornerSave the form as CUSTOMER.Creating And Saving AutoformsModifying The Properties Of A FormTo modify the properties of a form:Select a form in the Navigation Pane, right-click, and click on Design ViewClick the Arrange tab, click the AutoFormat group, and then click the AutoFormat design you want to applyTo change other form properties, open the Property Sheet dialog box by clicking the Design tab, and then click the Property Sheet buttonModifying The Properties Of A FormModifying The Properties Of A FormMake sure that you are viewing the properties for the correct form by looking at the box at the top of the dialogScroll through the list of propertiesClick the box next to the property that you want to changeSome properties have a drop-down list with specific choicesFor other properties, you enter a specific valueWhen you have made the changes you want, close the Property Sheet dialog box by clicking the Close box in the upper-right corner of the property boxClick on the View toolbar button to switch to Form View to see the changes you have madeModifying The Properties Of A FormModifying Specific Controls On A FormTo modify the properties of a specific control:Open the BIKE FORM in Design ViewSince the BIKE FORM you created using the wizard did not allow you to align the title of the form, you should do thatClick the Property Sheet button on the Design tabUnder the Form Header, select the BIKE FORM title objectNotice that there are handles around the object creating a box that is reddish in colorDrag the right-middle handle so that it is as wide as the rest of the formModifying Specific Controls On A FormIn the Property Sheet dialog box, click the Format tabClick the Font Weight property, and select Bold in the drop-down listClick the Text Align property, and select Center in the drop-down listClose the Property Sheet dialog boxTo view your changes, click on the View button and select Form ViewClose and save the formModifying Specific Controls On A FormREPORTSReports are used primarily for printing selected database informationA report labels, groups, sorts, and summarizes the data it presentsLike a form, a report can display data directly from one or more tables or it can display the results of a queryUsing The Report WizardTo create a report using the Report Wizard:Click the Create tab, and then click the Report Wizard button in the Reports groupClick the Tables/Queries drop-down arrowSelect the CUSTOMER table and select all the fields except the Drivers License, Telephone, and Credit Card NoThen select the RENTAL table and select the Date fieldLastly, select the BIKE table and select the Description fieldClick Next to go to the next stepNote: If you selected fields from more than one table or query in the previous step, the second Report Wizard dialog box asks you to choose one table or query that will be used for grouping the information in the report, if possibleUsing The Report WizardThe next step asks how you want to view the report - double-click BIKEClick NextMake Date the first grouping level (Note: Use a grouping level to organize the data into subgroups by the value of a specific field) Click NextNext, for sort order, specify State as the primary data sortClick NextSelect the Stepped report layout and Landscape orientationClick NextSelect the Office style for the reportClick NextType in Customer Rental by State Report for the title and select Preview the reportClick FinishUsing The Report WizardModifying The Report DesignTo modify the report design:Double-click the Customer Rental by State ReportNotice that the Description name is truncated and the State column needs to be moved to the rightSwitch to Design view by clicking the View buttonClick the Description control under the Bike_Id header section, and then drag the sizing right handle to increase the width of the control box Make sure that you can see the Date column controlSelect the State column heading and resize that control to have fewer spacesSwitch to Report View via the View toolbar button to see your changesModifying The Report DesignChanging Margins And Page Orientation For ReportsTo change the margins for a report:Open the report in Design ViewClick the Page Setup tab, and then click the Page Setup button in the Page Layout groupSelect the Print Options tab in the Page Setup dialog boxChange the values for the top, bottom, left, or right marginClick OKChanging Margins And Page Orientation For ReportsOpen the report in Design ViewClick the Page Setup tab, and then click the Page Setup buttonSelect the Page tab in the Page Setup dialog boxClick the radio button for Portrait or Landscape orientationClick OK