資料介紹

• 辦公軟件與office教程
• 計算機資料

資源簡介

Lynda最新出品的Access 2007: Queries in Depth 深入講解教程.

主講：Adam Wilbert

教程時長：2小時9分

教學光盤提供有配套素材文件.

官網鏈接：http://www.lynda.com/home/DisplayCourse.aspx?lpk2=63146

Microsoft Office Access是由微軟發布的關聯式數據庫管理系統。它結合了 Microsoft Jet Database Engine 和 圖形用戶界面兩項特點，是 Microsoft Office的成員之一。其實Access 也是微軟公司另一個通訊程序的名字，想與 ProComm 以及其他類似程序來競爭。可是事後微軟證實這是個失敗計劃，並且將它中止。數年後他們把名字重新命名於數據庫軟件。另外，Access還是c語言的一個函數名和一種交換機的主干道模式。

Description

In Access 2007: Queries in Depth, author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw data into usable information. The course covers setting up queries, performing calculations, using the built-in Access functions to further refine query results, and identifying top performers or areas for improvement based on a range of criteria. Exercise files are included with the course.

Topics include:
Naming conventions and best practices
Working with joins and primary keys
Using comparison operators
Printing query results
Creating parameter queries
Creating calculated fields
Using the Expression Builder
Making conditional statements
Appending queries
Updating queries

截圖預覽：