Microsoft Office 365. Access 2016. Comprehensive / Philip J. Pratt, Mary Z. Last
Book | Cengage Learning | 2016
Available at Gateway-Racine Campus General Collection (QA 76.9 D3 P7.285 2017)

Additional actions:

close
see all

Items

Location Call No. Status
Gateway-Racine Campus General Collection QA 76.9 D3 P7.285 2017 Available
Show fewer items

More Details

Description
viii, PA1-16, 1 unnumbered page, OFF2-OFF55, 2 unnumbered pages, AC2-AC639, 1 unnumbered page, IND1-IND13 : color illustrations ; 28 cm.
Series
Note
NO INTERLIBRARY LOAN
"For Microsoft' Office updates, go to sam.cengage.com"--Cover.
"Print number: 01. Print year: 2016"--Title page verso.
Includes index.
Contents
Ch.1 Productivity Apps for School and Work
Introduction to OneNote 2016 -- Introduction to Sway -- Introduction to Office Mix -- Introduction to Microsoft Edge
Pt.1: Office 2016 and Windows 10
Ch.2 Office 2016 and Windows 10: Essential Concepts and Skills
Objectives -- Introduction to the Windows 10 Operating System -- Introduction to Microsoft Office 2016 -- Running and Using an App -- Saving and Organizing Files -- The Access Window -- Screen Resolution -- Renaming, Moving, and Deleting Files -- Microsoft Office and Windows Help -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
Pt.2: Access 2016
MODULE ONE
Ch.3 Databases and Database Objects: An Introduction
Objectives -- Introduction -- Project - Database Creation -- Creating a Database -- The Access Window -- Determining Tables and Fields -- Creating a Table -- Previewing and Printing the Contents of a Table -- Importing or Linking Data From Other Applications to Access -- Additional Database Objects -- Database Properties -- Special Database Operations -- Database Design -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE TWO
Ch.4 Querying a Database
Objectives -- Introduction -- Project - Querying a Database -- Creating Queries -- Sorting -- Joining Tables -- Creating a Form for a Query -- Exporting Data From Access to Other Applications -- Addng Criteria to a Join Query -- Calculations -- Crosstab Queries -- Customizing the Navigation Pane -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE THREE
Ch.5 Maintaining a Database
Objectives -- Introduction -- Project - Maintaining a Database -- Updating Records -- Filtering Records -- Changing the Database Structure -- Mass Changes -- Validation Rules -- Making Additional Changes to the Database -- Changing the Appearance of a Datasheet -- Multivalued Fields in Queries -- Referential Integrity -- Ordering Records -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE FOUR
Ch.6 Creating Reports and Forms
Objectives -- Introduction -- Project - Reports and Forms -- Report Creation -- Multiple-Table Reports -- Form Creation -- Mailing Labels -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE FIVE
Ch.7 Multiple-Table Forms
Objectives -- Introduction -- Project - Multiple-Table Forms -- Adding Special Fields -- Updating the New Fields -- Multiple-Table Form Techniques -- Object Dependencies -- Date/Time, Long Text, and Yes/No Fields in Queries -- Datasheets in Forms -- Creating a Multiple-Table Form Based on the Many Table -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE SIX
Objectives -- Introduction -- Project - Creating Detailed Reports -- Additional Tables -- Creating Reports in Design View -- Creating a Second Report -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
Ch. 8 Advanced Report Techniques
MODULE SEVEN
Ch. 9 Advanced Form Techniques
Objectives -- Introduction -- Project - Advanced Form Techniques -- Creating a Form with Combo Boxes and Command Buttons -- Creating a Multipage Form -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In tne Labs
MODULE EIGHT
Ch.10 Macros, Navigation Forms, and Control Layouts
Objectives -- Introduction -- Project - Macros, Navigation Forms, and Control Layouts -- Creating and Using Macros -- Creating and Using a Navigation Form -- Data Macros -- Using Control Layouts on Forms and Reports -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE NINE
Ch.11 Administering a Database System
Objectives -- Introduction -- Project - Administering a Database System -- Converting Databases -- Microsoft Access Analysis Tools -- Navigation Pane Customization -- Table and Database Properties -- Special Field Properties -- Creating and Using Indexes -- Automatic Error Checking -- Data Type Parts -- Templates -- Encrypting a Database -- The Trust Center -- Locking a Database -- Database Splitting -- Web Apps -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE TEN
Ch.12 Using SQL
Objectives -- Introduction -- Project - Using SQL -- SQL Background -- SQL Queries -- Sorting -- Grouping -- Joining Tables -- Comparison with Access-Generated SQL -- Updating Data Using SQL -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE ELEVEN
Ch.13 Database Design
Objectives -- Introduction -- Project - Design a Database -- Entities, Attributes, and Relationships -- Relational Databases -- Database Design -- TDK Distributors -- Normalization -- Special Topics -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
Summary
116.00 OFFA (31-106-1) OFFT (10-106-6)
Subject
Added Author
Last, Mary Z., author.
Added Title
Access 2016
Browse Results
Other Sources:
View in classic catalog View MARC display
Recently Added:
Loading Suggestions...
Back to top