Business Info Systems 1 Help

Microsoft Access Assignment

III. CREATING REPORTS, FORMS, & CONVERTING DATA i Create a Multi-Column Report with Report Wizard. a. Click on REPORTS b. Click on CREATE REPORT BY USING WIZARD. c. The Table is still CUSTOMER. Select the following fields for your report: CusID, Title, Lname, Credit by high-lighting each field and pressing > Click NEXT. d. Grouping Order: Do not select any field for grouping. e. Sort Order: Click on the arrow to see options and select CREDIT for sorting Sort ascending f. Layout: The defaults TABULAR and PORTRAIT are OK so click NEXT. g. Style: Select a style and click NEXT. h. Title: Change the title of the report to CREDIT and click FINISH. i. Your report will be generated. j. CLOSE Reports. 2 Create a Form with Form Wizard. a. Click on FORMS b. Click on CREATE FORM BY USING WIZARD. c. The title CUSTOMER is OK. Select all the fields for the form with >> Click NEXT. d. Layout: The default COLUMNAR is OK so click NEXT. e. Style: Select a style and click NEXT. f. Title: The title CUSTOMER is OK, so click FINISH. g. Use arrows to move up and down among the records (forms). h. CLOSE Forms. 3 Convert the Table to a Spreadsheet. a. Click on Tables b. Click on CUSTOMER to open the Customer Table. c. Click on MS EXCEL icon in the Export section of External Data TAB. d. Your CUSTOMER table will be converted into an EXCEL spreadsheet file and you will see it as a table in an EXCEL spreadsheet. e. Now move the cursor just below the CREDIT column and click the symbol to get the formula for Total CREDIT. ENTER to see the Total CREDIT. f. Close EXCEL and decide whether or not to change the CREDIT total you calculated Keep this file for Lab C 4 Convert the Table to Word Processing. a. Open the CUSTOMER table. b. Click on MS Word under the More icon in the Export section of External Data TAB Your CUSTOMER table will be converted into a WORD file, and you'll see it as a table in a WORD document. c. Add some text to describe the table. d. FILE SAVE to save the WORD file and your changes. Keep this file for Lab C