正在加载图片...
C.2 Microsoft Access 9 account account_number branch_name balance 为 Perryridge 2 depositor customer_name account_number -20 y result customer_name account_number balance P _x C.2 Microsoft Access In this section,we survey the QBE version supported by Microsoft Access.While the original QBE was designed for a text-based display environment,Access QBE is designed for a graphical display environment,and accordingly is called graphical query-by-example (GQBE). Figure C.2 shows a sample GQBE query.The query can be described in English as "Find the customer_name,account number,and balance for all accounts at the Perryridge branch."Section C.1.5 showed how it is expressed in QBE. A minor difference in the GQBE version is that the attributes of a table are written one below the other,instead of horizontally.A more significant difference Eile Edit Yiew Insert Query Iools Window Help -日X 回·日题83电9·心回,?9名ΣM图” A account depositor account number customer_name branch_name account_number balance L Field: customer name account number balance branch name Table: depositor account account account Sort: Show: ☑ ☑ ■ Criteria: "Perryridge or: 画 Figure C.2 An example query in Microsoft Access QBEC.2 Microsoft Access 9 account account_number branch_name balance y Perryridge z depositor customer_name account_number x y result customer_name account_number balance P. x y z C.2 Microsoft Access In this section, we survey the QBE version supported by Microsoft Access. While the original QBE was designed for a text-based display environment, Access QBE is designed for a graphical display environment, and accordingly is called graphical query-by-example (GQBE). Figure C.2 shows a sample GQBE query. The query can be described in English as “Find the customer name, account number, and balance for all accounts at the Perryridge branch.” Section C.1.5 showed how it is expressed in QBE. A minor difference in the GQBE version is that the attributes of a table are written one below the other, instead of horizontally. A more significant difference Figure C.2 An example query in Microsoft Access QBE
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有