New Perspectives Microsoft Office 365 & Access 2016 Intermediate 1st Edition

• Tongue: English
• Leaves: 532
• Category: Library

✦ Table of Contents

Cover
Table of Contents
Productivity Apps for School and Work
Introduction to OneNote 2016
Creating a OneNote Notebook
Syncing a Notebook to the Cloud
Taking Notes
Converting Handwriting to Text
Recording a Lecture
1: Taking Notes for a Week
2: Using OneNote to Organize a Research Paper
3: Planning Your Career
Introduction to Sway
Creating a Sway Presentation
Adding Content to Build a Story
Designing a Sway
Publishing a Sway
Sharing a Sway
1: Creating a Sway Resume
2: Creating an Online Sway Newsletter
3: Creating and Sharing a Technology Presentation
Introduction to Office Mix
Adding Office Mix to PowerPoint
Capturing Video Clips
Inserting Quizzes, Live Webpages, and Apps
Sharing an Office Mix Presentation
1: Creating an Office Mix Tutorial for OneNote
2: Teaching Augmented Reality with Office Mix
3: Marketing a Travel Destination with Office Mix
Introduction to Microsoft Edge
Browsing the Web with Microsoft Edge
Locating Information with Cortana
Annotating Webpages
1: Using Cortana in Microsoft Edge
2: Viewing Online News with Reading View
3: Inking with Microsoft Edge
Access Modules
Module 1: Creating a Database: Tracking Animal, Visit, and Billing Data
Session 1.1 Visual Overview:
The Access Window
Introduction to Database Concepts
Organizing Data
Databases and Relationships
Relational Database Management Systems
Starting Access and Creating a Database
Working in Touch Mode
Creating a Table in Datasheet View
Renaming the Default Primary Key Field
Changing the Data Type of the Default Primary Key Field
Adding New Fields
Entering Records
Saving a Table
Closing a Table and Exiting Access
Session 1.1 Quick Check
Session 1.2 Visual Overview:
The Create Tab Options
Copying Records from Another Access Database
Navigating a Datasheet
Creating a Simple Query
Creating a Simple Form
Saving Database Objects
Creating a Simple Report
Printing a Report
Viewing Objects in the Navigation Pane
Using Microsoft Access Help
Managing a Database
Compacting and Repairing a Database
Backing Up and Restoring a Database
Session 1.2 Quick Check
Review Assignments
Case Problems
Module 2: Building a Database and Defining Table Relationships: Creating the Billing, Owner, and Animal Tables
Session 2.1 Visual Overview:
Table Window in Design View
Guidelines for Designing Databases
Guidelines for Setting Field Properties
Naming Fields and Objects
Assigning Field Data Types
Setting Field Sizes
Setting the Caption Property for Fields
Creating a Table in Design View
Defining Fields
Specifying the Primary Key
Saving the Table Structure
Modifying the Structure of an Access Table
Moving a Field in Design View
Adding a Field in Design View
Modifying Field Properties
Changing the Format Property in Datasheet View
Changing Properties in Design View
Session 2.1 Quick Check
Session 2.2 Visual Overview:
Modified Visit table in Datasheet view
Adding Records to a New Table
Importing Data from an Excel Worksheet
Creating a Table by Importing an Existing Table or Table Structure
Importing an Existing Table Structure
Importing an Existing Table
Adding Fields to a Table Using the Data Type Gallery
Modifying the Structure of an Imported Table
Deleting Fields from a Table Structure
Renaming Fields in Design View
Changing the Data Type for a Field in Design View
Setting the Default Value Property for a Field
Adding Data to a Table by Importing a Text File
Defining Table Relationships
One-to-Many Relationships
Referential Integrity
Defining a Relationship Between Two Tables
Session 2.2 Quick Check
Review Assignments
Case Problems
Module 3: Maintaining and Querying a Database: Updating Tables and retrieving Care Center Information
Session 3.1 Visual Overview:
Query Window in Design View
Updating a Database
Modifying Records
Hiding and Unhiding Fields
Finding Data in a Table
Deleting Records
Introduction to Queries
Creating and Running a Query
Updating Data Using a Query
Creating a Multitable Query
Sorting Data in a Query
Using an AutoFilter to Sort Data
Sorting on Multiple Fields in Design View
Filtering Data
Session 3.1 Quick Check
Session 3.2 Visual Overview:
Selection Criteria in Queries
Defining Record Selection Criteria for Queries
Specifying an Exact Match
Modifying a Query
Using a Comparison Operator to Match a Range of Values
Defining Multiple Selection Criteria for Queries
The And Logical Operator
The Or Logical Operator
Changing a Datasheet’s Appearance
Modifying the Font Size
Changing the Alternate Row Color in a Datasheet
Creating a Calculated Field
Formatting a Calculated Field
Using Aggregate Functions
Working with Aggregate Functions Using the Total Row
Creating Queries with Aggregate Functions
Using Record Group Calculations
Working with the Navigation Pane
Session 3.2 Quick Check
Review Assignments
Case Problem 1
Module 4: Creating Forms and Reports: Using Forms and Reports to Display Owner, Animal, and Visit Data
Session 4.1 Visual Overview:
Form Displayed in Form View
Creating a Form Using the Form Wizard
Modifying a Form’s Design in Layout View
Applying a Theme to a Database Object
Adding a Picture to a Form
Changing the Color of Text on a Form
Navigating a Form
Finding Data Using a Form
Maintaining Table Data Using a Form
Previewing and Printing Selected Form Records
Creating a Form with a Main Form and a Subform
Session 4.1 Quick Check
Session 4.2 Visual Overview:
Report Displayed in Print Preview
Creating a Report Using the Report Wizard
Modifying a Report’s Design in Layout View
Applying a Theme to a Report
Changing the Alignment of Field Values
Moving and Resizing Fields on a Report
Changing the Font Color and Inserting a Picture in a Report
Using Conditional Formatting in a Report
Session 4.2 Quick Check
Review Assignments
Case Problems
Module 5: Creating Advanced Queries and Enhancing Table Design: Making the CareCenter Database Easier to Use
Session 5.1 Visual Overview:
Calculated Field
Reviewing the CareCenter Database
Using a Pattern Match in a Query
Using a List-of-Values Match in a Query
Using the Not Logical Operator in a Query
Using an AutoFilter to Filter Data
Assigning a Conditional Value to a Calculated Field
Creating a Parameter Query
Creating a More Flexible Parameter Query
Session 5.1 Quick Check
Session 5.2 Visual Overview:
Advanced Query Wizards
Creating a Crosstab Query
Creating a Find Duplicates Query
Creating a Find Unmatched Query
Creating a Top Values Query
Session 5.2 Quick Check
Session 5.3 Visual Overview:
Lookup Fields and Input Masks
Creating a Lookup Field
Using the Input Mask Wizard
Identifying Object Dependencies
Defining Data Validation Rules
Defining Field Validation Rules
Defining Table Validation Rules
Working with Long Text Fields
Designating a Trusted Folder
Session 5.3 Quick Check
Review Assignments
Case Problems
Module 6: Using Form Tools and Creating Custom Forms: Creating Forms for Riverview Veterinary Care Center
Session 6.1 Visual Overview:
Anchoring Controls
Designing Forms
Changing a Lookup Field to a Short Text field
Creating a Relationship Report and Using the Documenter
Creating Forms Using Form Tools
Creating a Form Using the Datasheet Tool
Creating a Form Using the Multiple Items Tool
Creating a Form Using the Split Form Tool
Modifying a Split Form in Layout View
Anchoring Controls in a Form
Session 6.1 Quick Check
Session 6.2 Visual Overview:
Custom Form in Design View
Planning and Designing a Custom Form
Creating a Custom Form in Design View
Working in the Form Window in Design View
Adding Fields to a Form
Selecting, Moving, and Aligning Form Controls
Resizing and Deleting Controls
Adding a Combo Box Control to a Form
Using Form Headers and Form Footers
Adding a Title to a Form
Session 6.2 Quick Check
Session 6.3 Visual Overview:
Custom Form in Form View
Adding a Combo Box to Find Records
Adding a Subform to a Form
Displaying a Subform’s Calculated Controls in the Main Form
Adding Calculated Controls to a Subform’s Form Footer Section
Adding Calculated Controls to a Main Form
Resizing, Moving, and Formatting Calculated Controls
Changing the Tab Order in a Form
Improving a Form’s Appearance
Adding a Line to a Form
Adding a Rectangle to a Form
Modifying the Visual Effects of the Controls in a Form
Session 6.3 Quick Check
Review Assignments
Case Problems
Module 7: Creating Custom Reports: Creating Custom Reports for Riverview Veterinary Care Center
Session 7.1 Visual Overview:
Custom Report in Layout View
Customizing Existing Reports
Viewing a Report in Report View
Copying and Pasting a Report into Word
Modifying a Report in Layout View
Modifying a Report in Design View
Session 7.1 Quick Check
Session 7.2 Visual Overview:
Custom Report in Print Preview
Planning and Designing a Custom Report
Creating a Query for a Custom Report
Creating a Custom Report
Sorting and Grouping Data in a Report
Working with Controls in Design View
Hiding Duplicate Values in a Report
Session 7.2 Quick Check
Session 7.3 Visual Overview:
Headers and Footers in Reports
Understanding Page Header and Page Footer Sections
Adding the Date to a Report
Adding Page Numbers to a Report
Adding a Report Title to a Page Header Section
Creating Mailing Labels
Session 7.3 Quick Check
Review Assignments
Case Problems
Module 8: Sharing, Integrating, and Analyzing Data: Importing, Exporting, Linking, and Analyzing Data in the CareCenter Database
Session 8.1 Visual Overview:
Exporting Data to XML and HTML
Exporting an Access Query to an HTML Document
Viewing an HTML Document in a Web Browser
Importing a CSV File as an Access Table
Analyzing a Table with the Table Analyzer
Working with XML Files
Importing Data from an XML File
Saving and Running Import Specifications
Exporting an Access Table as an XML File
Saving and Running Export Specifications
Session 8.1 Quick Check
Session 8.2 Visual Overview:
Tab Control with a Chart
Using a Tab Control in a Form
Creating a Chart Using the Chart Wizard
Using Templates and Application Parts
Exporting a Report to a PDF File
Integrating Access with Other Applications
Linking Data from an Excel Worksheet
Session 8.2 Quick Check
Review Assignments
Case Problems
Index