Microsoft Office Access 2007 In Business, Comprehensive
Published on 25. September 2007
Book
Paperback/Softback
592 pages
978-0-13-236887-2 (ISBN)
Description
The content associated with the traditional text has moved to Pearson Custom Library (PCL). PCL allows customers to create customized textbooks, giving students a more engaging and affordable education. If you would like to purchase the full test without customization, please use ISBN: 0558895905. For more information about customization opportunities, refer to www.pearsoncustomlibrary.com.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Dimensions
Height: 226 mm
Width: 279 mm
Thickness: 27 mm
Weight
1180 gr
ISBN-13
978-0-13-236887-2 (9780132368872)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Joseph J. Manzo
Microsoft Office Access 2007 in Business Core Comprehensive and Student Resource DVD
Book
11/2007
Pearson/Education
€62.50
Article is exhausted; no reprint
Content
Chapter 1 - Introduction
What is Access?
Databases
Business Decisions and Databases
Creating a New Access Database
Navigation Pane and Access Objects
File Formats and Other Access Settings
Access Help
Using versus Creating Databases
Chapter 2 - The Database Table
Creating Tables
Creating a New Table
Field Names, Data Types, and Field Properties
Indexing and Primary Keys
Entering and Formatting Data
Adjusting and Hiding Columns and Rows
Copying and Pasting Data
Sorting and Filtering Data
Editing Tables
Changing Data Types and Field Properties
Changing the Sequence of Field
Editing Data and Field Names
Inserting Fields
Deleting Fields and Records
Importing and Linking Data
Importing Data
Linking Data
Printing Tables
Chapter 3 - Selecting and Summarizing Data from Tables
Know Your Data
Getting Started
Single Field Primary Key Tables
Multiple Field Primary Key Tables
Fundamental Query Techniques (The Select Query)
Creating a New Query
Adding Fields and Adjusting Columns
Query Name and Properties
Defining Basic Criteria (OR AND)
Formatting and Sorting Data
Editing Queries
Exporting Queries to Excel
Advanced Queries
Grouping Data
Mathematical Summaries (Aggregate Functions)
Nested Queries
Crosstab Queries
Chapter 4 - Applying Calculations to Data
Formulas
Custom Fields
Calculated Fields
The Expression Builder
IIF Function
Basic IIF Function
Nested IIF Functions
Financial Functions
Future Value
Payment Function
Help with Functions
Chapter 5 - Reports
Fundamental Report Techniques
Creating a New Report
Setting the Dimensions of a Report
Report Header
Page Header
Detail
Page Footer
Report Footer
Advanced Report Techniques
Grouping Data
Sorting Data
Calculated Fields
Conditional Formatting
Group and Report Totals
Lines
Dates
Chapter 6 - Applying Core Competency Skills
Using Multiple Tables in Queries
Joining Tables
Inner Joins
Outer Joins
Defining Table Relationships
Comprehensive Access Project
Selecting Tables
Adding and Joining Tables in a Select Query
Creating a Parameter Query
Adding Calculations
Constructing the Final Report
Chapter 7 - Date, Text and Error Functions
Date Functions
Year
Month
Day
Text functions
Concatenate
Len
Left, Right, and Mid
String Conversion
Error Functions
Is Error
Is Null
Chapter 8 - Advanced Techniques for Managing and Using Tables
Managing Tables Through Queries
Delete Query
Append Query
Make Table Query
Duplicate records query
Pivot Tables
Chapter 9 - Forms
Basic Forms
Advance Forms
Chapter 10 - Macro
The Macro Window
Basic Macro routines
Appendix A - Access Utilities
ODBC Connections
Compacting Databases
Security