Microsoft Office Access 2007 Forms, Reports, and Queries, 2/e
暫譯: Microsoft Office Access 2007 表單、報告與查詢,第二版
Paul McFedries
- 出版商: QUE
- 出版日期: 2007-05-01
- 售價: $1,840
- 貴賓價: 9.5 折 $1,748
- 語言: 英文
- 頁數: 408
- 裝訂: Paperback
- ISBN: 0789736691
- ISBN-13: 9780789736697
已過版
買這商品的人也買了...
-
$880$695 -
$650$553 -
$880$695 -
$880$695 -
$990$891 -
$620$558 -
$550$468 -
$620$527 -
$560$437 -
$780$616 -
$580$458 -
$590$460 -
$680$578 -
$620$527 -
$650$514 -
$500$395 -
$520$411 -
$390$308 -
$750$638 -
$490$387 -
$520$468 -
$420$357 -
$780$663 -
$400$360 -
$550$435
商品描述
Description
“Everything you need to master Access 2007 forms, reports, and queries.”
–Charles Carr, Reviews Editor, ComputorEdge Magazine
Create Forms for Business
Ensure Data Entry Accuracy
Build Elegant Form Interfaces
Collect Data Via Email
Design Effective Business Reports
Make an Invoice Report
Create Mailing Labels
Extract Data
Work with Multiple Tables
Calculate Discounts
Analyze Data
Develop your Microsoft Access expertise instantly with proven techniques
Let’s face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you’re forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.
This book changes all that by giving you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.
· Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.
· Avoids database theory in favor of practical know-how that you can put to use right away.
· Packed full of real-world examples and techniques to help you learn and understand the importance of each section.
· Covers what’s new and changed in Microsoft Access 2007.
Table of Contents
Introduction 1
Part I: Creating Forms 5
Chapter 1 Creating and Using a Form 7
Chapter 2 Working with Form Controls 29
Chapter 3 Designing Forms for Efficient and Accurate Data Entry 49
Chapter 4 Designing Forms for Business Use 77
Chapter 5 Creating Specialized Forms 95
Part II: Designing and Customizing Reports 111
Chapter 6 Creating and Publishing a Report 113
Chapter 7 Designing Effective Business Reports 141
Chapter 8 Designing Advanced Reports 157
Chapter 9 Creating Specialized Reports 177
Part III: Creating Powerful Queries 197
Chapter 10 Creating a Basic Query 199
Chapter 11 Building Criteria Expressions 231
Chapter 12 Working with Multiple-Table Queries 259
Chapter 13 Creating Advanced Queries 287
Chapter 14 Creating PivotTable Queries 311
Chapter 15 Querying with SQL Statements 341
Index 361
商品描述(中文翻譯)
描述
“掌握 Access 2007 表單、報告和查詢所需的一切。”
–Charles Carr,《ComputorEdge》雜誌評論編輯
為商業創建表單
確保數據輸入的準確性
構建優雅的表單介面
通過電子郵件收集數據
設計有效的商業報告
製作發票報告
創建郵寄標籤
提取數據
處理多個表格
計算折扣
分析數據
立即透過經驗法則發展您的 Microsoft Access 專業知識
讓我們面對現實:Microsoft Access 是一個龐大且令人畏懼的程式。大多數人從未超越創建簡單表格和使用精靈來構建基本表單和報告的階段。與此同時,您需要資訊,並且知道您所尋求的資料嵌入在您的 Access 數據庫中。沒有更高級的知識來提取和呈現這些數據,您被迫依賴辦公室專家和超負荷的 IT 人員提供現成的報告或一刀切的解決方案。
這本書改變了這一切,讓您具備構建高效數據前端(表單)、以吸引人且易於閱讀的格式發布結果(報告)以及提取所需數據(查詢)的技能。這本書不關注 Access 的大局,而是專注於表單、報告和查詢。這種深入的方法將使您獲得獲取數據所需的知識和理解,並證明「知識就是力量」這句老話的真實性。
· 專注於您必須掌握的三項技術,以充分利用 Access:表單、報告和查詢。
· 避免數據庫理論,專注於您可以立即使用的實用知識。
· 充滿現實世界的範例和技術,幫助您學習和理解每個部分的重要性。
· 涵蓋 Microsoft Access 2007 中的新功能和變更。
目錄
引言 1
第一部分:創建表單 5
第 1 章 創建和使用表單 7
第 2 章 使用表單控制項 29
第 3 章 設計高效且準確的數據輸入表單 49
第 4 章 設計商業用途的表單 77
第 5 章 創建專用表單 95
第二部分:設計和自定義報告 111
第 6 章 創建和發布報告 113
第 7 章 設計有效的商業報告 141
第 8 章 設計高級報告 157
第 9 章 創建專用報告 177
第三部分:創建強大的查詢 197
第 10 章 創建基本查詢 199
第 11 章 構建條件表達式 231
第 12 章 使用多表查詢 259
第 13 章 創建高級查詢 287
第 14 章 創建樞紐分析表查詢 311
第 15 章 使用 SQL 語句查詢 341
索引 361