Authors: Nita Rutkosky, Pierce College Puyallup; Denise Seguin, Fanshawe College; Jan Davidson, Lambton College; Audrey Roggenkamp, Pierce College Puyallup; and Ian Rutkosky, Pierce College Puyallup
With this courseware, students build mastery skills in Access 2016. Students receive step-by-step instructions in creating, formatting and maintaining databases to report and analyze information. A three-level instructional approach moves students from initial modeling of skills to guided application in projects-based exercises to independent problem solving in realistic workplaces.
Getting Started in Office 2016.
Unit 1. Creating Tables and Queries
1. Managing and Creating Tables
2. Creating Relationships between Tables
3. Performing Queries
4. Creating and Modifying Tables in Design View
Unit 1 Performance Assessment
Unit 2. Creating Forms and Reports
5. Creating Forms
6. Creating Reports and Mailing Labels
7. Modifying, Filtering, and Viewing Data
8. Importing and Exporting Data
Unit 2 Performance Assessment
Level 2 Unit 1. Advanced Tables, Relationships, Queries, and Forms
1. Designing the Structure of Tables
2. Designing and Building Relationships and Lookup Fields
3. Advanced Query Techniques
4. Creating and Using Custom Forms
Unit 1. Performance Assessment
Unit 2. Advanced Reports, Access Tools, and Customizing Access.
5. Creating and Using Custom Reports
6. Using Access Tools and Managing Objects
7. Automating, Customizing, and Securing Access
8. Integrating Access Data
Unit 2. Performance Assessment
After successfully completing a course using this textbook and digital courseware, students will be able to:
Upon completing the text, students can expect to be proficient in using Access to organize, analyze, and present information.
SNAP is a web-based training and assessment platform that accelerates student success in Microsoft® Office. Students get real-world experience working directly in the Microsoft® software and instructors get a suite of powerful tools at their fingertips. Through real-time analytics, instructors get instant performance insight on their students' work, and students can identify their challenges to define their own individual learning paths to success.
Precheck quizzes test students' knowledge of chapter content before they study the material. Students can use the results to help focus their study on the skills they need to learn.
Tutorials guide students through the steps for the skills and then allow them to practice on their own. These interactive tutorials include simple instructions and optional help.
Preview images show how students' file should look when they have completed each chapter, skill, review exercise, or assessment.
Recheck quizzes at the end of each chapter enable students to recheck their understanding of the chapter content.
The Workbook ebook provides study resources (such as presentations with audio support, study notes, and tips and hints), review exercises, and assessments to help reinforce students' understanding of the concepts, features, and skills covered in the textbook.