Exploring Microsoft Office Access 2007 Volume 1 or Introduction to Security

Exploring Microsoft Office Access 2007 Volume 1

Author: Robert Grauer

The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature “Perfect pages” where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired. Exploring Microsoft Office Access 2007 Volume 1, 1/e covers the following topics: introduction to Access and databases; relational databases and multi-table queries; customize, analyze, and summarize query data; creating and editing professional, useful reports Ideal for students and individuals seeking comprehensive instruction for Access 2007.

Table of Contents:

Chapter 1 - Introduction to Access: Finding Your Way through a Database

Section 1: Data and Files Everywhere!
Exploring, Describing, and Navigating Among the Objects in an Access Database
Understanding the Difference Between Working in Storage and Memory
Practicing Good File Management
Backing up, Compacting, and Repairing Access Files
Hands-On Exercises 1 Introduction to Databases

Section 2: Filters, Sorts, and Access Versus Excel
Creating Filters
Sorting Table Data on One or More Fields
Knowing When to Use Access or Excel to Manage Data
Hands-On Exercises 2: Data Manipulation: Filters and Sorts

Section 3: The Relational Database
Using the Relationship Window
Understanding Relational Power
Hands-On Exercises 3: Introduction to Relationships

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and Using

Section 1: Related Data
Table Design, Properties, Views, and Wizards
Designing Data
Creating Tables
Hands-On Exercises 1: Table Design, Properties, Views, and Wizards

Section 2: Multiple Table Database
Understanding Table Relationships
Sharing Data with Excel
Establishing Table Relationships
Hands-on Exercises 2: Imports andRelationships

Section 3: Queries
Creating a Query
Specifying Criteria for Different Data Types
Copying and Running a Query
Using the Query Wizard
Understanding Large Database Differences
Hands-On Exercises 3: Multi-Table Query

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 3 - Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Section 1: Data Summary and Analysis
Understanding the Order of Precedence
Creating a Calculated Field in a Query
Hands-On Exercises 1: Calculated Query Fields

Section 2: Expression Builder
Creating Expressions with the Expression Builder
Creating and Editing Access Functions
Performing Date Arithmetic
Hands-On Exercises 2: Expression Builder, Functions, and Date Arithmetic

Section 3: Data Aggregates
Creating and Working with Data Aggregates
Hands-On Exercises 3: Data Aggregates

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 4 - Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports
Section 1: Appearance Matter
Planning Reports
Using Different Report Views
Creating and Editing a Report
Hands-On Exercises 1: Introduction to Access Reports

Section 2: The Anatomy of a Report
Identifying Report Elements, Sections and Controls
Adding Grouping Levels Using the Layout View
Adding Fields to a Report
Hands-On Exercises 2: Create, Sort, Edit, Nest and Remove Groups from Reports

Section 3: The Report and Label Wizard
Using the Report Wizard
Hands-On Exercises 3: Report Wizard

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Interesting book: Systèmes informatiques D'entreprise :une Approche basée sur le Dessin

Introduction to Security: Operations and Management

Author: P J Ortmeier

Introduction to Security, 3e addresses public and private security operations and management all in a single text. The history, threats to, and legal aspects of security are included, as well as global considerations. This edition features unprecedented coverage of budgeting; planning; homeland security; career opportunities and future trends. New case studies have been added to each chapter and numerous examples tackle issues encountered in the field. With a focus on career preparation, this edition can be used as a prep tool for the ASIS International Certified Protection Professional (CPP) exam and introduces readers to 18 of the most popular security sectors.