Descripciones mejoradas de Syndetics:

The Exploring series helps students master theHow and Whyof performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles featurePerfect pageswhere 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 Comprehensive 1/e, covers the following topics: introduction to Access; relational databases and multi-table queries; how to customize, analyze, and summarize query data; create, edit and perform calculations in creating professional and useful reports; using sub-reports, advanced query types, pivot tables and charts; data protection; database maintenance; customizing a database with programming languages.Ideal for students and individuals seeking a comprehensive introduction to Access 2007.    

Tabla de contenidos provista por Syndetics

• 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 and Relationships
• 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
• Chapter 5 Pivot Tables and Charts
• Section 1 Data Mining
• Create a Pivot
• Table view
• Calculate aggregate statistics
• Modify a Pivot
• Table
• Hands-on Exercise 1: Create and Use