Microsoft Office Access 2007 In Business / Edition 1
by Joseph Manzo
The In Business system is the only series that prepares you expressly for your core business classes such as Accounting, Economics, Marketing, Finance and Business Statistics by doing the following: exposing you to real business files that meet professional standards; providing a useful reference to be used in your business classes; instructing how to use the
… See more details belowOverview
The In Business system is the only series that prepares you expressly for your core business classes such as Accounting, Economics, Marketing, Finance and Business Statistics by doing the following: exposing you to real business files that meet professional standards; providing a useful reference to be used in your business classes; instructing how to use the software as a tool to accomplish business goals; coverage of the core Office skills that you will need in your business courses. In Business includes tools that will benefit any style of learning. Whether you need to reference specific skills for another course or understand how to utilize Microsoft Office to complete your business objectives, In Business will allow you to apply these skills directly to your own education and career aspirations.
Microsoft Office Access 2007 In Business, Adv., 1/e covers the following topics: advanced techniques for managing and using tables; date, text, and error functions; forms; and macros.
Ideal for business students and professionals.
Product Details
- ISBN-13:
- 9780132368872
- Publisher:
- Prentice Hall
- Publication date:
- 09/14/2007
- Edition description:
- New Edition
- Pages:
- 704
- Product dimensions:
- 8.96(w) x 10.88(h) x 0.77(d)
Table of Contents
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
Customer Reviews
Average Review: