CS 102 Module 4 Set 2 Creating a Single Record Form Based on a Table or Query Creating a Multiple Items Form Creating a Split Form Creating a Form Using the Form Wizard Creating a New Blank Form Adding Fields to a Form on Layout View Creating a Basic Report Based on a Table or Query Creating a Report Using the Report Wizard Creating a New Blank Report Based on a Table or Query Adding Fields to a Report in Layout View Formatting Controls Applying a Theme Resizing Controls Moving and Arranging Controls Modifying the Layout of a Form or Report Adding Design Elements to Form and Report Headers Adding Page Numbers to Reports Grouping Records in a Reports Adding Totals to a Report Previewing and Printing a Report Controlling the Page Setup of a Report for Printing Exporting a Report to Other Formats Using the Simple Query Wizard Creating a Query in Design View Adding Text Criteria to a Query Adding Numeric and Date Criteria to a Query Using AND in a Query Using OR in a Query Combining AND and OR in a Query Adding a Calculated Field to a Query Specifying the Sort Order in a Query Hiding and Showing Fields in a Query Using a Parameter Query Finding Unmatched Data Using a Query Finding Duplicate Data Using a Query Filtering Data Using AutoFilter Filtering Data Using Filter by Selection Exporting Data to Excel Exporting Data to a Text File Importing Data from Excel Importing Data From a Text File Adding Record to a Table by Importing Linking to a Table in another Access Database