Microsoft Office Access 2007 in Business Core and Student Resource DVD
Prentice-Hall
978-1-4058-7372-7 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
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.
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
| Erscheint lt. Verlag | 19.9.2007 |
|---|---|
| Verlagsort | Harlow |
| Sprache | englisch |
| Maße | 226 x 281 mm |
| Gewicht | 830 g |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Informatik ► Office Programme ► Access | |
| ISBN-10 | 1-4058-7372-8 / 1405873728 |
| ISBN-13 | 978-1-4058-7372-7 / 9781405873727 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
