GO! with Microsoft Office 365, Access 2019 Comprehensive

About our authors Shelley Gaskin (series editor) is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor's degree in Business Administration from Robert Morris College (Pennsylvania), a master's degree in Business from Northern Illinois University, and a doctorate in Adult and Community Education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of Customer Education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sector and has also written and edited numerous computer application textbooks.Nancy  Graviett (Access author) is a professor and department chair in Business Technology at St. Charles Community College in Cottleville, Missouri. She holds a bachelor's degree in marketing and a master's degree in business education from the University of Missouri and has completed a certificate in online education. Nancy has authored textbooks on WordPerfect, Google, Microsoft Outlook, and Microsoft Access.

• MICROSOFT OFFICE Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management Explore Microsoft OfficeCreate a Folder for File StorageDownload and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office ProgramPerform Office Commands and Apply Office FormattingFinalize an Office DocumentUse the Office Help FeaturesExplore Windows 10Prepare to Work with Folders and FilesUse File Explorer to Extract Zipped Files and to Display Locations, Folders, and FilesStart Programs and Open Data FilesCreate, Rename, and Copy Files and FoldersACCESS Chapter 1: Getting Started with Microsoft Access 2019 Identify Good Database DesignCreate a Table and Define Fields in a Blank Desktop DatabaseChange the Structure of Tables and Add a Second TableCreate a Query, Form, and ReportClose a Database and Close AccessUse a Template to Create a DatabaseOrganize Objects in the Navigation PaneCreate a New Table in a Database Created with a TemplateView a ReportChapter 2: Sort and Query a Database Open and Save an Existing DatabaseCreate Table RelationshipsSort Records in a TableCreate a Query in Design ViewCreate a New Query From an Existing QuerySort Query ResultsSpecify Criteria in a QuerySpecify Numeric Criteria in a QueryUse Compound Criteria in a QueryCreate a Query Based on More Than One TableUse Wildcards in a QueryCreate Calculated Fields in a QueryCalculate Statistics and Group Data in a QueryCreate a Crosstab QueryCreate a Parameter QueryChapter 3: Forms, Filters, and Reports Create and Use a Form to Add and Delete RecordsFilter RecordsCreate a Form by Using the Form WizardModify a Form in Layout View and in Design ViewCreate a Report by Using the Report Tool and Modify the Report in Layout ViewCreate a Report by Using the Report WizardModify the Design of a ReportKeep Grouped Data Together in a Printed ReportChapter 4: Enhancing Tables Manage Existing TablesModify Existing TablesChange Data TypesAttach Files to RecordsCreate a Table in Design ViewCreate a Lookup FieldSet Field PropertiesCreate Data Validation Rules and Validation TextChapter 5: Enhancing Queries Create Calculated Fields in a QueryUse Aggregate Functions in a QueryCreate a Crosstab QueryFind Duplicate and Unmatched RecordsCreate a Parameter QueryCreate a Make Table QueryCreate an Append QueryCreate a Delete QueryCreate an Update QueryModify the Join TypeChapter 6: Customizing Forms and Reports Microsoft Access 2019 Create a Form in Design ViewChange and Add ControlsFormat a FormMake a Form User FriendlyCreate a Report Based on a Query Using a WizardCreate a Report in Design ViewAdd Controls to a ReportGroup, Sort, and Total Records in Design ViewChapter 7: Creating Advanced Forms and Reports Create a Split FormCreate a Form and a SubformCreate a Multi-Page FormCreate and Modify a SubreportCreate a Report Based on a Parameter QueryCreate an Alphabetic IndexChapter 8: Creating Macros Create a Standalone Macro with One ActionAdd Multiple Actions to a Standalone MacroCreate an Embedded MacroPrint Macro DetailsCreate a Macro GroupAssociate a Macro with an EventCreate a Data MacroChapter 9: Integrating Access with Other Applications Import Data from a Word TableImport Data from an Excel WorkbookInsert an Excel Chart into a ReportImport from and Link to Another Access DatabaseExport Data to WordUse Mail Merge to Integrate Access and WordExport Data to ExcelExport Data to an HTML File and an XML FileChapter 10: Administering Databases and Writing SQL Statements Create a Navigation FormUse Microsoft Access Analysis ToolsModify Access Views and BehaviorsUse the Database SplitterEncrypt and Decrypt DatabasesCreate a Locked Database (ACCDE File)Modify a Query in SQL ViewCreate a Query in SQL ViewCreate a Union Query Using SQLCreate Calculated Fields and SQL Aggregate Functions