GO! with Microsoft Access 2016 1st Edition

Description

Cover......Page 1 Title Page......Page 2 Copyright Page......Page 3 Brief Contents......Page 4 Table of Contents......Page 6 About the Authors......Page 16 GO! Walkthrough......Page 22 Reviewers Of The GO! Series......Page 29 Chapter 1 Introduction to Microsoft Office 2016 Features......Page 30 Project 1A Note Form......Page 31 Objective 1 Explore Microsoft Office 2016......Page 32 Activity 1.01 Exploring Microsoft Office 2016 and Creating a Blank Word Document......Page 33 Activity 1.02 Entering and Editing Text in an Office 2016 Program......Page 35 Activity 1.03 Checking Spelling......Page 37 Activity 1.04 Performing Commands from a Dialog Box......Page 38 Activity 1.05 Using Undo and Applying a Built-In Style to Text......Page 40 Objective 4 Create a Folder and Name and Save a File......Page 41 Activity 1.06 Creating a Folder and Naming and Saving a File......Page 42 Activity 1.07 Inserting a Footer, Inserting Document Info, and Adding Document Properties......Page 46 Activity 1.08 Printing a File and Closing a Desktop App......Page 47 Project 1B Memo......Page 50 Activity 1.09 Opening an Existing File and Saving It with a New Name......Page 51 Activity 1.10 Signing In to Office and Viewing Application Options......Page 53 Objective 8 Perform Commands from the Ribbon and Quick Access Toolbar......Page 54 Activity 1.11 Performing Commands from and Customizing the Quick Access Toolbar......Page 55 Activity 1.12 Performing Commands from the Ribbon......Page 56 Activity 1.13 Minimizing the Ribbon and Using the Keyboard to Control the Ribbon......Page 60 Activity 1.14 Changing Page Orientation and Zoom Level......Page 61 Activity 1.15 Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles......Page 62 Activity 1.16 Using Format Painter......Page 64 Activity 1.17 Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste......Page 66 Activity 1.18 Changing Text to WordArt and Adding Alternative Text for Accessibility......Page 70 Activity 1.20 Inserting a Bookmark......Page 72 Activity 1.21 Compressing Files......Page 73 Activity 1.22 Using Microsoft Office Tell Me and Tell Me More to Get Help......Page 74 Objective 11 Install Apps for Office and Create a Microsoft Account......Page 75 Activity 1.24 Creating a Microsoft Account......Page 76 GO! To Work......Page 78 Summary GO! Learn It Online......Page 79 Glossary......Page 80 Introduction to Microsoft Access 2016......Page 84 Chapter 1 Getting Started with Microsoft Access 2016......Page 86 Project 1A Student Advising Database with Two Tables......Page 87 Activity 1.01 Using Good Design Techniques to Plan a Database......Page 88 Activity 1.02 Starting with a Blank Desktop Database......Page 90 Activity 1.03 Assigning the Data Type and Name to Fields......Page 92 Activity 1.04 Renaming Fields and Changing Data Types in a Table......Page 95 Activity 1.05 Adding a Record to a Table......Page 96 Activity 1.06 Adding Additional Records to a Table......Page 97 Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table......Page 98 Activity 1.08 Deleting a Table Field in Design View......Page 101 Activity 1.09 Changing a Field Size and Adding a Description......Page 103 Activity 1.10 Viewing the Primary Key in Design View......Page 104 Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet......Page 105 Activity 1.12 Adjusting Column Widths......Page 108 Activity 1.13 Printing a Table......Page 109 Activity 1.14 Creating a Query by Using the Simple Query Wizard......Page 114 Activity 1.15 Creating and Printing a Form......Page 116 Activity 1.16 Creating, Modifying, and Printing a Report......Page 119 Activity 1.17 Closing a Database and Closing Access......Page 122 Activity Exporting an Access Table to an Excel Spreadsheet, Saving the Spreadsheet to Google Drive, Editing a Record in Google Drive, and Saving to Your Computer......Page 123 Project 1B Student Workshops Database......Page 125 Activity 1.18 Using a Template to Create a Database......Page 126 Activity 1.19 Building a Table by Entering Records in a Multiple-Items Form and a Single-Record Form......Page 128 Activity 1.20 Appending Records by Importing from an Excel Spreadsheet......Page 131 Activity 1.21 Grouping Database Objects in the Navigation Pane......Page 132 Activity 1.22 Using the Table Tool to Create a New Table......Page 133 Activity 1.23 Entering Records Into a New Table......Page 134 Activity 1.25 Printing a Table......Page 136 Activity Exporting an Access Table to a Word Document, Saving the Document to Google Drive, Adding a Record in Google Drive, and Saving to Your Computer......Page 138 GO! To Work......Page 140 Summary GO! Learn It Online GO! Collaborative Team Project......Page 141 Project Guide for Access Chapter 1......Page 142 Glossary......Page 143 Skills Review......Page 145 Mastering Access......Page 153 Rubric......Page 163 GO! Think......Page 164 Chapter 2 Sort and Query a Database......Page 166 Project 2A Instructors and Courses Database......Page 167 Activity 2.01 Opening and Saving an Existing Database......Page 168 Objective 2 Create Table Relationships......Page 169 Activity 2.03 Selecting the Tables and Common Field to Establish the Table Relationship......Page 170 Activity 2.04 Setting Relationship Options......Page 173 Activity 2.05 Printing and Saving a Relationship Report......Page 175 Activity 2.07 Testing Cascade Options......Page 176 Activity 2.08 Sorting Records in a Table in Ascending or Descending Order......Page 178 Activity 2.09 Sorting Records in a Table on Multiple Fields......Page 179 Activity 2.10 Creating a New Select Query in Design View......Page 181 Activity 2.11 Running, Saving, Printing, and Closing a Query......Page 183 Activity 2.13 Modifying the Design of a Query......Page 184 Activity 2.14 Sorting Query Results......Page 186 Activity 2.15 Specifying Text Criteria in a Query......Page 188 Activity 2.16 Specifying Criteria and Hiding the Field in the Query Results......Page 190 Activity 2.17 Using Is Null Criteria to Find Empty Fields......Page 191 Activity Exporting a Relationship Report to a PDF File, Saving the PDF file to Google Drive, and Sharing the File......Page 193 Project 2B Athletic Scholarships Database......Page 195 Activity 2.18 Opening, Renaming, and Saving an Existing Database and Importing a Spreadsheet as a New Table......Page 196 Activity 2.19 Creating a One-to-Many Table Relationship......Page 198 Activity 2.21 Using Comparison Operators in Criteria......Page 200 Activity 2.22 Using the Between … And Comparison Operator......Page 201 Activity 2.23 Using AND Criteria in a Query......Page 203 Activity 2.24 Using OR Criteria in a Query......Page 204 Activity 2.25 Creating a Query Based on More Than One Table......Page 205 Activity 2.26 Using a Wildcard in a Query......Page 207 Objective 12 Create Calculated Fields in a Query......Page 208 Activity 2.27 Creating a Calculated Field in a Query......Page 209 Activity 2.28 Creating a Second Calculated Field in a Query......Page 210 Activity 2.29 Formatting Calculated Fields......Page 211 Activity 2.30 Using the Min, Max, Avg, and Sum Functions in a Query......Page 212 Activity 2.31 Grouping Records in a Query......Page 214 Activity 2.32 Creating a Crosstab Query Using the Query Wizard......Page 215 Activity 2.33 Creating a Parameter Query with One Criteria......Page 217 More Knowledge Parameter Query Prompts......Page 219 Activity Exporting an Access Query to an Excel Spreadsheet, Saving the Spreadsheet to Google Drive, Editing a Record in Google Drive, and Saving to Your Computer......Page 220 GO! To Work......Page 222 Summary GO! Learn It Online......Page 223 Project Guide for Access Chapter 2......Page 224 Glossary......Page 225 Skills Review......Page 226 Mastering Access......Page 236 Rubric......Page 247 GO! Think......Page 248 Chapter 3 Forms, Filters, and Reports......Page 250 Project 3A Students and Majors Database......Page 251 Activity 3.01 Opening and Saving an Existing......Page 252 Activity 3.02 Creating a Form and Viewing Records......Page 254 Activity 3.03 Creating a Second Form......Page 255 Activity 3.04 Adding Records to a Table by Using a Form......Page 256 Activity 3.05 Deleting Records from a Table by Using a Form......Page 257 Activity 3.06 Printing a Form......Page 258 Activity 3.07 Filtering Data by Selection of One Field......Page 260 Activity 3.08 Using Filter By Form......Page 262 Activity 3.09 Using Advanced Filter/Sort......Page 264 Objective 3 Create a Form by Using the Form Wizard......Page 265 Activity 3.10 Creating a Form by Using the Form Wizard......Page 266 Activity 3.11 Grouping Controls in Layout View......Page 267 Activity 3.13 Adding, Resizing, and Moving Controls in Layout View......Page 269 Activity 3.14 Formatting Controls in Layout View......Page 272 Activity 3.15 Modifying a Form in Design View......Page 273 Activity Exporting an Access Form to an Excel Spreadsheet, Saving the Spreadsheet to Google Drive, Editing a Record in Google Sheets, and Saving to Your Computer......Page 277 Project 3B Job Openings Database......Page 279 Activity 3.16 Opening and Saving an Existing Database, Renaming Objects, and Viewing a Table Relationship......Page 280 Activity 3.18 Modifying a Report in Layout View......Page 282 Activity 3.20 Creating a Report by Using the Report Wizard......Page 285 Activity 3.21 Formatting and Deleting Controls in Layout View......Page 288 Activity 3.22 Modifying Controls in Layout View......Page 289 Activity 3.23 Aligning Controls in Design View......Page 292 Activity 3.24 Keeping Grouped Data Together in a Printed Report......Page 294 Activity Exporting an Access Report to a Word File, Uploading the Word File to OneDrive, and Editing the Report in Google Docs......Page 297 GO! To Work......Page 300 Summary GO! Learn It Online GO! Collaborative Team Project......Page 301 Project Guide for Access Chapter 3......Page 302 Glossary......Page 303 Skills Review......Page 304 Mastering Access......Page 313 Rubric......Page 324 GO! Think......Page 325 Chapter 4 Enhancing Tables......Page 326 Project 4A City Directory......Page 327 Activity 4.01 Backing Up a Database......Page 328 Activity 4.02 Adding File Locations to Trusted Locations......Page 329 Activity 4.03 Duplicating a Table and Modifying the Structure......Page 331 Activity 4.04 Copying and Appending Records to a Table......Page 332 More Knowledge Add a Table Description......Page 333 Activity 4.05 Splitting a Table into Two Tables......Page 334 Activity 4.06 Appending Records from Another Database......Page 336 Activity 4.07 Finding and Deleting Records......Page 337 Activity 4.08 Finding and Modifying Records......Page 339 Activity 4.09 Adding and Moving Fields in Design View and Datasheet View......Page 341 Activity 4.10 Checking Spelling......Page 343 Activity 4.11 Changing Data Types......Page 344 Activity 4.12 Attaching a Word Document to a Record......Page 345 Project 4B IT Tasks......Page 347 Activity 4.13 Creating a Table in Design View......Page 348 More Knowledge The Caption Property......Page 351 Activity 4.14 Adding Fields to a Table in Design View......Page 352 Activity 4.15 Creating a Lookup Field Based on a List of Values......Page 353 Activity 4.16 Creating a Lookup Field Based on Data in Another Table......Page 355 Activity 4.17 Creating an Input Mask Using the Input Mask Wizard......Page 356 Activity 4.18 Creating an Input Mask Using the Input Mask Properties Box......Page 359 More Knowledge The Differences Between Input Masks and Display Formats......Page 360 Activity 4.19 Specifying a Required Field......Page 361 More Knowledge Using the Current Date as a Default Value......Page 363 Activity 4.21 Indexing Fields in a Table......Page 364 Activity 4.22 Creating Data Validation Rules and Validation Text......Page 365 Activity 4.23 Testing Table Design and Field Properties......Page 367 GO! To Work......Page 370 Summary GO! Learn It Online......Page 371 Project Guide for Access Chapter 4......Page 372 Glossary......Page 373 Skills Review......Page 374 Mastering Access......Page 381 Rubric......Page 390 GO! Think......Page 391 Chapter 5 Enhancing Queries......Page 392 Project 5A Store Inventory......Page 393 Activity 5.01 Creating a Calculated Field Based on Two Existing Fields......Page 394 Activity 5.02 Creating a Calculated Field Based on One Existing Field and a Number......Page 398 Activity 5.03 Adding a Total Row to a Query......Page 400 Activity 5.04 Creating a Totals Query......Page 403 More Knowledge Changing the Name of the Totals Query Result......Page 404 Activity 5.05 Creating a Select Query as the Source for a Crosstab Query......Page 405 Activity 5.06 Creating a Crosstab Query......Page 407 Activity 5.07 Finding Duplicate Records......Page 409 Activity 5.08 Finding Unmatched Records......Page 410 Objective 5 Create a Parameter Query......Page 411 Activity 5.09 Creating a Parameter Query Using One Criterion......Page 412 Activity 5.10 Creating a Parameter Query Using Multiple Criteria......Page 413 More Knowledge Creating a Parameter Query Using Multiple Criteria......Page 414 Project 5B Customer Orders......Page 415 Activity 5.11 Creating a Select Query......Page 416 Activity 5.12 Converting a Select Query to a Make Table Query......Page 418 Activity 5.13 Creating an Append Query for a Table in the Current Database......Page 419 Activity 5.14 Creating an Append Query for a Table in Another Database......Page 421 Activity 5.15 Creating a Delete Query......Page 424 Activity 5.16 Creating an Update Query......Page 427 Activity 5.17 Creating an Update Query with an Expression......Page 428 More Knowledge Restrictions for Update Queries......Page 429 Activity 5.18 Viewing the Results of a Query Using an Inner Join......Page 430 Activity 5.19 Changing the Join Type to an Outer Join......Page 432 More Knowledge Other Types of Joins......Page 434 GO! To Work......Page 436 Summary GO! Learn It Online......Page 437 Project Guide for Access Chapter 5......Page 438 Glossary......Page 439 Skills Review......Page 440 Mastering Access......Page 447 Rubric......Page 456 GO! Think......Page 457 Chapter 6 Customizing Forms and Reports......Page 458 Project 6A Locations......Page 459 Activity 6.01 Creating a Form in Design View......Page 460 Activity 6.02 Adding Sections to a Form......Page 462 Activity 6.03 Changing Controls on a Form......Page 464 Activity 6.04 Adding Controls to a Form......Page 465 More Knowledge Changing the Theme Colors......Page 469 Activity 6.06 Adding a Background Picture to a Form......Page 470 Activity 6.07 Modifying the Borders of Controls......Page 472 Activity 6.08 Adding a Message to the Status Bar......Page 473 Activity 6.09 Creating Custom ControlTips......Page 475 Activity 6.10 Changing the Tab Order......Page 476 More Knowledge Changing the Margins in the Print Dialog Box......Page 479 Project 6B Rosebud Cafe......Page 480 Activity 6.11 Creating a Report Using a Wizard......Page 481 Activity 6.12 Modifying a Report Created Using a Wizard......Page 483 Activity 6.13 Creating a Report in Design View......Page 484 Activity 6.14 Modifying the Sections of a Report......Page 485 More Knowledge Formatting a Report......Page 486 Activity 6.15 Adding Label and Text Box Controls to a Report......Page 487 Activity 6.16 Adding an Image Control to a Report......Page 489 Activity 6.17 Adding a Grouping and Sort Level to a Report......Page 491 Activity 6.18 Adding Calculated Controls to a Report......Page 493 More Knowledge Changing the Margins in Print Preview......Page 497 GO! To Work......Page 498 Summary GO! Learn It Online......Page 499 Project Guide for Access Chapter 6......Page 500 Glossary......Page 501 Skills Review......Page 502 Mastering Access......Page 510 Rubric......Page 519 GO! Think......Page 520 Chapter 7 Creating Advanced Forms and Reports......Page 522 Project 7A MWB Schedule......Page 523 Activity 7.01 Creating a Split Form Using the Split Form Tool......Page 524 Activity 7.02 Formatting a Split Form......Page 526 Activity 7.03 Converting an Existing Form into a Split Form......Page 530 Activity 7.04 Creating a Form and a Subform Using the Form Tool......Page 532 More Knowledge Sort Records in a Form......Page 534 Activity 7.05 Creating a Form and a Subform Using the Form Wizard......Page 536 Activity 7.06 Modifying a Form and a Subform......Page 537 Activity 7.07 Creating a Subform by Dragging a Related Table onto an Existing Form......Page 541 Activity 7.08 Creating a Multi-Page Form Using the Tab Control......Page 544 Project 7B Online Orders......Page 548 Activity 7.09 Using the SubReport Wizard to Create a Subreport......Page 549 Activity 7.10 Modifying a Subreport......Page 551 Activity 7.11 Creating a Subreport by Adding an Object to an Existing Report......Page 553 Activity 7.12 Displaying a Total from a Subreport on the Main Report......Page 555 Objective 5 Create a Report Based on a Parameter Query......Page 558 Activity 7.13 Creating a Report Based on a Parameter Query......Page 559 Activity 7.14 Printing the Parameters in the Report......Page 560 Activity 7.15 Creating an Alphabetic Index......Page 561 GO! To Work......Page 566 Summary GO! Learn It Online......Page 567 Project Guide for Access Chapter 7......Page 568 Glossary......Page 569 Skills Review......Page 570 Mastering Access......Page 578 Rubric......Page 588 GO! Think......Page 589 Chapter 8 Creating Macros......Page 590 Project 8A Employee Records......Page 591 Activity 8.01 Creating a Standalone Macro......Page 592 Activity 8.02 Opening a Form in Its Own Window......Page 596 Activity 8.03 Creating a Standalone Macro That Executes Automatically......Page 598 Objective 2 Add Multiple Actions to a Standalone Macro......Page 599 Activity 8.04 Adding Multiple Actions to an Existing Standalone Macro......Page 600 Activity 8.05 Creating an Embedded Macro on a Form......Page 605 Activity 8.06 Creating an Embedded Macro on a Report......Page 608 Activity 8.07 Printing Macro Details......Page 609 Project 8B Employee Benefits......Page 613 Activity 8.08 Creating the First Macro in a Macro Group......Page 614 Activity 8.09 Creating a Second Macro in a Macro Group......Page 616 Activity 8.10 Creating a Third Macro in a Macro Group......Page 620 Activity 8.11 Associating a Command Button with a Macro......Page 621 Activity 8.12 Creating an Event-Driven Macro......Page 624 GO! To Work......Page 626 Summary GO! Learn It Online......Page 627 Project Guide for Access Chapter 8......Page 628 Glossary......Page 629 Skills Review......Page 630 Mastering Access......Page 637 Rubric......Page 646 GO! Think......Page 647 Chapter 9 Integrating Access with Other Applications......Page 648 Project 9A Liberty Motors......Page 649 Activity 9.01 Preparing a Word Table for Importing......Page 650 Activity 9.02 Importing Data from a Word Table......Page 652 Objective 2 Import Data from an Excel
Workbook......Page 657 Activity 9.03 Importing Data from an Excel Worksheet......Page 658 Activity 9.04 Appending Data from Excel to an Access Table......Page 659 Activity 9.05 Creating a Query and a Report......Page 660 Activity 9.06 Inserting an Excel Chart into a Report......Page 662 Activity 9.07 Importing Data from Another Access Database......Page 664 Activity 9.08 Linking to a Table in Another Access Database......Page 666 Project 9B Used Inventory......Page 668 Activity 9.09 Exporting an Access Query to Word......Page 669 Activity 9.10 Exporting an Access Report to Word......Page 672 Activity 9.11 Merging an Access Table with a Word Document......Page 673 Activity 9.12 Exporting Selected Records to Excel......Page 677 Activity 9.13 Copying Selected Records to an Existing Excel Workbook......Page 679 Activity 9.14 Exporting a Report to an HTML File......Page 681 Activity 9.15 Exporting a Report to an XML File......Page 682 More Knowledge Exporting Data to Alternate Formats......Page 684 GO! To Work......Page 686 Summary GO! Learn It Online......Page 687 Project Guide for Access Chapter 9......Page 688 Glossary......Page 689 Skills Review......Page 690 Mastering Access......Page 698 Rubric......Page 707 GO! Think......Page 708 Chapter 10 Administering Databases and Writing SQL Statements......Page 710 Project 10A Lawyers......Page 711 Activity 10.01 Creating a Navigation Form Using the Navigation Form Tool......Page 712 Activity 10.02 Using the Table Analyzer......Page 714 Activity 10.03 Using the Performance Analyzer......Page 717 Activity 10.04 Viewing Object Dependencies......Page 718 Objective 3 Modify Access Views and Behaviors......Page 719 Activity 10.05 Modifying Access Options......Page 720 Activity 10.06 Customizing the Quick Access Toolbar......Page 721 Activity 10.07 Setting Current Database Options......Page 723 Activity 10.08 Set Navigation Options......Page 724 Activity 10.09 Splitting a Database......Page 727 Objective 5 Encrypt and Decrypt Databases......Page 729 Activity 10.10 Encrypting a Database with a Password......Page 730 Activity 10.11 Decrypting a Database with a Password......Page 731 Activity 10.12 Creating a Secure ACCDE File......Page 732 Project 10B Overdue Accounts......Page 735 Activity 10.13 Modifying a Query in SQL View......Page 736 Objective 8 Create a Query in SQL View......Page 738 Activity 10.14 Creating an SQL Statement......Page 739 Activity 10.15 Specifying the Join Type in SQL......Page 740 Activity 10.16 Creating a Union Query in SQL View......Page 741 Activity 10.17 Creating Calculated Fields in SQL......Page 743 Activity 10.18 Writing SQL Aggregate Functions......Page 744 GO! To Work......Page 746 Summary GO! Learn It Online......Page 747 Project Guide for Access Chapter 10......Page 748 Glossary......Page 749 Skills Review......Page 750 Mastering Access......Page 757 Rubric......Page 766 GO! Think......Page 767 Appendix......Page 768 Glossary......Page 774 C......Page 782 D......Page 783 F......Page 784 G......Page 785 M......Page 786 P......Page 787 R......Page 788 S......Page 789 W......Page 790 Z......Page 791