Sams Teach Yourself Microsoft Office Access 2003 in 24 Hours
暫譯: Sams 24小時自學 Microsoft Office Access 2003

Alison Balter

  • 出版商: SAMS
  • 出版日期: 2003-09-21
  • 售價: $1,690
  • 貴賓價: 9.5$1,606
  • 語言: 英文
  • 頁數: 624
  • 裝訂: Paperback
  • ISBN: 0672325454
  • ISBN-13: 9780672325458
  • 已過版

買這商品的人也買了...

相關主題

商品描述

In just 24 sessions of one hour or less, the reader picks up all the skills needed to increase the effectiveness and reliability of Access applications. Using a straightforward, step-by-step approach, each lesson builds upon the previous one, allowing the reader to quickly learn the essentials of Access programming from the ground up. The book helps the reader to understand the fundamentals of the Access architecture, gain fast knowledge of the new features that Access offers, learn how to effectively use the latest tools and features of Access by following practical, real-world examples, and get expert tips from the best-selling author, Alison Balter. This book is designed for the way readers learn. They can go through each step-by-step chapter or just choose the lessons that interest them the most.

Table of Contents

Introduction.


Conventions Used in This Book.

I. INTRODUCTION TO RELATIONAL DATABASES AND ACCESS 2003.

Hour 1. Relational Databases and Office Access 2003 Introduced.


 

What Is a Relational Database? What Types of Things Can I Do with Microsoft Access? Starting Microsoft Access. Opening an Existing Database. The Access Desktop. The Database Window. A Preview of the Database Components. Closing an Access Database. Summary. Q&A. Workshop.

II. WORKING WITH EXISTING DATABASES AND OBJECTS.

Hour 2. Tables Introduced.

Viewing and Navigating Table Data. Editing Table Data. Adding Records to a Table. Deleting Records. Finding and Replacing Records. Filtering Table Data. Modifying the Appearance of a Datasheet. Correcting Errors by Using Spell Check and AutoCorrect. Summary. Q&A. Workshop.

Hour 3. Queries Introduced.

What Is a Query and When Should You Use One? Opening a Query in Datasheet View. Opening a Query in Design View. Running a Query. Adding and Removing Fields. Modifying the Sort Order of a Query. Working with Simple Criteria. Modifying the Datasheet View of a Query. Saving a Query. Printing Query Results. Closing a Query. Summary. Q&A. Workshop.

Hour 4. Forms Introduced.

Uses for Forms. Opening a Form. Working with Data in a Form. Sorting Records. Filtering the Data Underlying a Form. Viewing the Design of a Form. Closing a Form. Using the AutoForm Feature. Using the Form Wizard to Build a Form. Using the Conditional Formatting Feature of a Form. Summary. Q&A. Workshop.

Hour 5. Reports Introduced.

Opening and Viewing a Report. Printing a Report. The AutoReport Feature and the Report Wizard. Viewing the Design of a Report. Closing a Report. Printing Database Objects. Summary. Q&A.

III. CREATING YOUR OWN DATABASE AND OBJECTS.

Hour 6. Using Wizards to Create a Database.

Using a Database Template to Create a Database. Creating a Database from Scratch. Building a Table by Using a Wizard. Building a Query by Using a Wizard. Building a Form by Using a Wizard. Building a Report by Using a Wizard. Summary. Q&A.

Hour 7. Designing Databases.

Task Analysis. Data Analysis and Design. Prototyping. Testing. Implementation. Maintenance. Summary. Q&A.

Hour 8. Creating Tables.

Building a New Table. Selecting the Appropriate Field Type for Data. The All-Important Primary Key. Summary. Q&A. Workshop.

Hour 9. Creating Relationships.

Introduction to Relational Database Design. Establishing Relationships in Access. Establishing Referential Integrity. The Benefits of Relationships. Summary. Q&A. Workshop.

Hour 10. Creating Queries.

Query Basics. Ordering Query Results. Refining a Query by Using Criteria. Updating Query Results. Building Queries Based on Multiple Tables. Creating Calculated Fields. Getting Help from the Expression Builder. Summary. Q&A. Workshop.

Hour 11. Creating Forms.

Creating a Form in Design View. Working with the Form Design Window. Selecting the Correct Control for the Job. Conditional Formatting. What Form Properties Are Available, and Why Should You Use Them? Summary. Q&A. Workshop.

Hour 12. Creating Reports.

Types of Reports. The Anatomy of a Report. Creating a Report in Design View. Working with the Report Design Window. Selecting the Correct Control for the Job. Report Properties and Why to Use Them. Summary. Q&A. Workshop.

Hour 13. Creating Macros.

The Basics of Creating a Macro. Running an Access Macro. Modifying an Existing Macro. Documenting a Macro: Adding Comments. Testing a Macro. When You Should Use Macros and When You Shouldn't. Converting a Macro to VBA Code. Creating an AutoExec Macro. Creating an AutoKeys Macro. Summary. Q&A. Workshop.

IV. POWER ACCESS TECHNIQUES.

Hour 14. Power Table Techniques.

Working with Field Properties. Working with Table Properties. Using Indexes to Improve Performance. Summary. Q&A. Workshop.

Hour 15. Power Query Techniques.

Adding Calculated Fields to Select Queries. Applying Advanced Filters. Creating and Running Parameter Queries. Creating and Running Action Queries. Using Aggregate Functions to Summarize Numeric Data. Working with Outer Joins. Refining Queries with Field, Field List, and Query Properties. Summary. Q&A. Workshop.

Hour 16. Power Form Techniques.

The Other Properties of a Form. Control Properties and Why to Use Them. Bound, Unbound, and Calculated Controls. Using Expressions to Enhance Forms. The Command Button Wizard: Programming Without Typing. Building Forms Based on More Than One Table. Basing Forms on Queries: The Why and How. Summary. Q&A. Workshop.

Hour 17. Power Report Techniques.

Other Properties of a Report. Control Properties and Why to Use Them. Inserting Page Breaks. Bound, Unbound, and Calculated Controls. Using Expressions to Enhance Reports. Building Reports Based on More Than One Table. Working with Sorting and Grouping. Basing Reports on Stored Queries or Embedded SQL Statements. Summary. Q&A. Workshop.

V. ADVANCED TOPICS.

Hour 18. Sharing Data with Other Applications.

Importing, Linking, and Opening Files: When and Why. Exporting to Another Access Database. Exporting to an Excel Spreadsheet. Exporting to ASCII. Importing from Another Access Database. Importing Spreadsheet Data. Importing ASCII Data. Linking to Tables in Another Access Database. Linking to Another Type of Database. The Linked Table Manager. Summary. Q&A. Workshop.

Hour 19. Access and the Internet.

Saving Database Objects as HTML. Linking to HTML Files. Importing HTML Files. Exporting Data to XML. Importing XML Data into Access. Creating and Modifying Data Access Pages. Saving PivotTables and PivotCharts to Data Access Pages. Summary. Q&A. Workshop.

Hour 20. Database Administration.

Backing Up a Database. Compacting and Repairing a Database. Encrypting and Decrypting a Database. Converting a Database to Another Version. Creating an MDE File. Using the Database Splitter. Summary. Q&A. Workshop.

Hour 21. Database Documentation.

Preparing an Application to Be Self-Documenting. Using the Documenter. The Object Dependencies Feature. Summary. Q&A. Workshop.

Hour 22. Security Introduced.

Implementing Share-Level Security: Assigning a Database Password. Establishing User-Level Security. Summary. Q&A. Workshop.

Hour 23. VBA Introduced.

VBA Explained. Access Class Modules, Standard Modules, Form Modules, and Report Modules. Working with Variables. Adding Comments to Code. Using the Line Continuation Character. Using the VBA Control Structures. Passing Parameters and Returning Values. The DoCmd Object: Performing Macro Actions. Working with Built-in Functions. Summary. Q&A. Workshop.

Hour 24. Finishing Touches.

Adding Custom Menu Bars, Toolbars, and Shortcut Menus. Creating an Application Switchboard. Setting Startup Options. Summary. Q&A. Workshop.

Index.

商品描述(中文翻譯)

在僅僅 24 次每次一小時或更短的課程中,讀者將掌握提高 Access 應用程式效能和可靠性所需的所有技能。這本書採用簡單明瞭的逐步教學方式,每一課都在前一課的基礎上進行,讓讀者能夠快速從基礎學習 Access 程式設計的要點。本書幫助讀者理解 Access 架構的基本原理,快速掌握 Access 提供的新功能,通過實用的真實案例學習如何有效使用 Access 的最新工具和功能,並從暢銷作者 Alison Balter 那裡獲得專業建議。本書的設計考慮了讀者的學習方式,讀者可以逐步閱讀每一章,或僅選擇他們最感興趣的課程。

目錄

引言。

本書使用的約定。

I. 關聯式資料庫與 Access 2003 簡介。

第 1 小時。關聯式資料庫與 Office Access 2003 介紹。

關聯式資料庫是什麼?我可以用 Microsoft Access 做什麼?啟動 Microsoft Access。打開現有資料庫。Access 桌面。資料庫視窗。資料庫組件的預覽。關閉 Access 資料庫。總結。問答。工作坊。

II. 使用現有資料庫和物件。

第 2 小時。介紹資料表。

查看和導航資料表數據。編輯資料表數據。向資料表添加記錄。刪除記錄。查找和替換記錄。篩選資料表數據。修改資料表的外觀。使用拼寫檢查和自動更正來修正錯誤。總結。問答。工作坊。

第 3 小時。介紹查詢。

查詢是什麼,何時應該使用查詢?在資料表視圖中打開查詢。在設計視圖中打開查詢。運行查詢。添加和刪除欄位。修改查詢的排序順序。使用簡單條件進行查詢。修改查詢的資料表視圖。保存查詢。列印查詢結果。關閉查詢。總結。問答。工作坊。

第 4 小時。介紹表單。

表單的用途。打開表單。在表單中處理數據。排序記錄。篩選表單底層的數據。查看表單的設計。關閉表單。使用自動表單功能。使用表單精靈建立表單。使用表單的條件格式功能。總結。問答。工作坊。

第 5 小時。介紹報告。

打開和查看報告。列印報告。自動報告功能和報告精靈。查看報告的設計。關閉報告。列印資料庫物件。總結。問答。

III. 創建自己的資料庫和物件。

第 6 小時。使用精靈創建資料庫。

使用資料庫範本創建資料庫。從頭開始創建資料庫。使用精靈建立資料表。使用精靈建立查詢。使用精靈建立表單。使用精靈建立報告。總結。問答。

第 7 小時。設計資料庫。

任務分析。數據分析與設計。原型設計。測試。實施。維護。總結。問答。

第 8 小時。創建資料表。

建立新資料表。為數據選擇適當的欄位類型。至關重要的主鍵。總結。問答。工作坊。

第 9 小時。創建關聯。

關聯式資料庫設計簡介。在 Access 中建立關聯。建立參考完整性。關聯的好處。總結。問答。工作坊。

第 10 小時。創建查詢。

查詢基礎。排序查詢結果。使用條件精煉查詢。更新查詢結果。基於多個資料表建立查詢。創建計算欄位。從表達式生成器獲取幫助。總結。問答。工作坊。

第 11 小時。創建表單。

在設計視圖中創建表單。使用表單設計視窗。為工作選擇正確的控制項。條件格式。可用的表單屬性是什麼,為什麼要使用它們?總結。問答。工作坊。

第 12 小時。創建報告。

報告的類型。報告的結構。以設計視圖創建報告。使用報告設計視窗。為工作選擇正確的控制項。報告屬性及其使用原因。總結。問答。工作坊。

第 13 小時。創建宏。

創建宏的基礎。運行 Access 宏。修改現有宏。記錄宏:添加註解。測試宏。何時應該使用宏,何時不應使用。將宏轉換為 VBA 代碼。創建 AutoExec 宏。創建 AutoKeys 宏。總結。問答。工作坊。

IV. Power Access 技術。

第 14 小時。Power 表格技術。

處理欄位屬性。處理資料表屬性。使用索引提高性能。總結。問答。工作坊。

第 15 小時。Power 查詢技術。

向選擇查詢添加計算欄位。應用高級篩選。創建和運行參數查詢。創建和運行操作查詢。使用聚合函數彙總數據。處理外部連接。使用欄位、欄位列表和查詢屬性精煉查詢。總結。問答。工作坊。

第 16 小時。Power 表單技術。

表單的其他屬性。控制項屬性及其使用原因。綁定、非綁定和計算控制項。使用表達式增強表單。命令按鈕精靈:無需輸入編程。基於多個資料表建立表單。基於查詢建立表單:為什麼和如何。總結。問答。工作坊。

第 17 小時。Power 報告技術。

報告的其他屬性。控制項屬性及其使用原因。插入分頁符。綁定、非綁定和計算控制項。使用表達式增強報告。基於多個資料表建立報告。處理排序和分組。基於儲存查詢或嵌入 SQL 語句建立報告。總結。問答。工作坊。

V. 進階主題。

第 18 小時。與其他應用程式共享數據。

導入、鏈接和打開檔案:何時和為什麼。導出到另一個 Access 資料庫。導出到 Excel 試算表。導出到 ASCII。從另一個 Access 資料庫導入。導入試算表數據。導入 ASCII 數據。鏈接到另一個 Access 資料庫中的資料表。鏈接到其他類型的資料庫。鏈接資料表管理器。總結。問答。工作坊。

第 19 小時。Access 與互聯網。

將資料庫物件保存為 HTML。鏈接到 HTML 檔案。導入 HTML 檔案。將數據導出到 XML。將 XML 數據導入 Access。創建和修改數據訪問頁面。將樞紐分析表和樞紐分析圖保存到數據訪問頁面。總結。問答。工作坊。

第 20 小時。資料庫管理。

備份資料庫。壓縮和修復資料庫。加密和解密資料庫。將資料庫轉換為其他版本。創建 MDE 檔案。使用資料庫分割器。總結。問答。工作坊。

第 21 小時。資料庫文檔。

準備應用程式以便自我文檔化。使用文檔生成器。物件依賴性功能。總結。問答。工作坊。

第 22 小時。安全性介紹。

實施共享級安全性:分配資料庫密碼。建立使用者級安全性。總結。問答。工作坊。

第 23 小時。VBA 介紹。

VBA 解釋。Access 類模組、標準模組、表單模組和報告模組。處理變數。向代碼添加註解。使用行延續字符。使用 VBA 控制結構。傳遞參數和返回值。DoCmd 物件:執行宏操作。使用內建函數。總結。問答。工作坊。

第 24 小時。最後的修飾。

添加自定義菜單欄、工具列和快捷菜單。創建應用程式切換板。設置啟動選項。總結。問答。工作坊。

索引。