<div class="c-section-headers-number-list_container"> <h3>MICROSOFT OFFICE</h3> <h4>Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management</h4> <ol> <li>Explore Microsoft Office</li> <li>Create a Folder for File Storage</li> <li>Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program</li> <li>Perform Office Commands and Apply Office Formatting</li> <li>Finalize an Office Document</li> <li>Use the Office Help Features</li> <li>Explore Windows 10</li> <li>Prepare to Work with Folders and Files</li> <li>Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files</li> <li>Start Programs and Open Data Files</li> <li>Create, Rename, and Copy Files and Folders</li> </ol> <h3>ACCESS</h3> <h4>Chapter 1: Getting Started with Microsoft Access 2019</h4> <ol> <li>Identify Good Database Design</li> <li>Create a Table and Define Fields in a Blank Desktop Database</li> <li>Change the Structure of Tables and Add a Second Table</li> <li>Create a Query, Form, and Report</li> <li>Close a Database and Close Access</li> <li>Use a Template to Create a Database</li> <li>Organize Objects in the Navigation Pane</li> <li>Create a New Table in a Database Created with a Template</li> <li>View a Report</li> </ol> <h4>Chapter 2: Sort and Query a Database</h4> <ol> <li>Open and Save an Existing Database</li> <li>Create Table Relationships</li> <li>Sort Records in a Table</li> <li>Create a Query in Design View</li> <li>Create a New Query From an Existing Query</li> <li>Sort Query Results</li> <li>Specify Criteria in a Query</li> <li>Specify Numeric Criteria in a Query</li> <li>Use Compound Criteria in a Query</li> <li>Create a Query Based on More Than One Table</li> <li>Use Wildcards in a Query</li> <li>Create Calculated Fields in a Query</li> <li>Calculate Statistics and Group Data in a Query</li> <li>Create a Crosstab Query</li> <li>Create a Parameter Query</li> </ol> <h4>Chapter 3: Forms, Filters, and Reports</h4> <ol> <li>Create and Use a Form to Add and Delete Records</li> <li>Filter Records</li> <li>Create a Form by Using the Form Wizard</li> <li>Modify a Form in Layout View and in Design View</li> <li>Create a Report by Using the Report Tool and Modify the Report in Layout View</li> <li>Create a Report by Using the Report Wizard</li> <li>Modify the Design of a Report</li> <li>Keep Grouped Data Together in a Printed Report</li> </ol> <h4>Chapter 4: Enhancing Tables</h4> <ol> <li>Manage Existing Tables</li> <li>Modify Existing Tables</li> <li>Change Data Types</li> <li>Attach Files to Records</li> <li>Create a Table in Design View</li> <li>Create a Lookup Field</li> <li>Set Field Properties</li> <li>Create Data Validation Rules and Validation Text</li> </ol> <h4>Chapter 5: Enhancing Queries</h4> <ol> <li>Create Calculated Fields in a Query</li> <li>Use Aggregate Functions in a Query</li> <li>Create a Crosstab Query</li> <li>Find Duplicate and Unmatched Records</li> <li>Create a Parameter Query</li> <li>Create a Make Table Query</li> <li>Create an Append Query</li> <li>Create a Delete Query</li> <li>Create an Update Query</li> <li>Modify the Join Type</li> </ol> <h4>Chapter 6: Customizing Forms and Reports Microsoft Access 2019</h4> <ol> <li>Create a Form in Design View</li> <li>Change and Add Controls</li> <li>Format a Form</li> <li>Make a Form User Friendly</li> <li>Create a Report Based on a Query Using a Wizard</li> <li>Create a Report in Design View</li> <li>Add Controls to a Report</li> <li>Group, Sort, and Total Records in Design View</li> </ol> <h4>Chapter 7: Creating Advanced Forms and Reports</h4> <ol> <li>Create a Split Form</li> <li>Create a Form and a Subform</li> <li>Create a Multi-Page Form</li> <li>Create and Modify a Subreport</li> <li>Create a Report Based on a Parameter Query</li> <li>Create an Alphabetic Index</li> </ol> <h4>Chapter 8: Creating Macros</h4> <ol> <li>Create a Standalone Macro with One Action</li> <li>Add Multiple Actions to a Standalone Macro</li> <li>Create an Embedded Macro</li> <li>Print Macro Details</li> <li>Create a Macro Group</li> <li>Associate a Macro with an Event</li> <li>Create a Data Macro</li> </ol> <h4>Chapter 9: Integrating Access with Other Applications</h4> <ol> <li>Import Data from a Word Table</li> <li>Import Data from an Excel Workbook</li> <li>Insert an Excel Chart into a Report</li> <li>Import from and Link to Another Access Database</li> <li>Export Data to Word</li> <li>Use Mail Merge to Integrate Access and Word</li> <li>Export Data to Excel</li> <li>Export Data to an HTML File and an XML File</li> </ol> <h4>Chapter 10: Administering Databases and Writing SQL Statements</h4> <ol> <li>Create a Navigation Form</li> <li>Use Microsoft Access Analysis Tools</li> <li>Modify Access Views and Behaviors</li> <li>Use the Database Splitter</li> <li>Encrypt and Decrypt Databases</li> <li>Create a Locked Database (ACCDE File)</li> <li>Modify a Query in SQL View</li> <li>Create a Query in SQL View</li> <li>Create a Union Query Using SQL</li> <li>Create Calculated Fields and SQL Aggregate Functions</li> </ol> </div>
