Glossary

Office Data Access Pages

previous page next page

Glossary


C
calculated field: A field, defined in a query, that displays the result of an expression rather than displaying stored data. The value is recalculated each time a value in the expression changes.
chart: A graphical view of database data that is used to visually display trends, patterns, and comparisons. When the data in the database changes, the chart updates accordingly. If the chart is linked to a PivotTable list or spreadsheet on the data access page, the chart changes when you change the data in the PivotTable list or spreadsheet. A chart includes its own toolbar and built-in Help.

D
data access page: A Web page that has a connection to a database. By using a data access page, you can view, add, edit, and manipulate data stored in the database. A data access page can also include data from other sources, such as Microsoft Excel.
database: A collection of data related to a particular subject or purpose. A data access page can connect to a Microsoft Access database or a Microsoft SQL Server database.

E
expand indicator: A button that is used to expand or collapse groups of records on a data access page; it displays the plus (+) or minus (-) sign.

F
filter: A set of criteria that is applied to data to show a subset of the data. In a data access page, you can filter records by using the Filter By Selection command. Note: A data access page can also have a built-in filter. On this type of page, you don't see any records until you choose a value from a list on the page. Only records that contain the value you choose will be displayed in the page until you choose another value to filter on.

G
GIF: A graphics file format (.gif extension in Microsoft Windows) used to display indexed-color graphics on the World Wide Web. It supports up to 256 colors and uses lossless compression, meaning that no image data is lost when the file is compressed.
group: A collection of objects that behave as one for the purpose of moving, resizing, or rotating them. A group can be composed of multiple sets of groups.
group level: The depth at which a group in a report or data access page is nested inside other groups. Groups are nested when a set of records is grouped by more than one field, expression, or group record source.
grouped data access page: A data access page that uses two or more group levels to create a hierarchy that groups records from general categories to specific details.

H
HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.
HTML extensions: A feature or setting that is an extension to the formal HTML specification. Extensions may not be supported by all Web browsers, but they may be used widely by Web authors. An example of an extension is marquee scrolling text.

J
JPEG: A graphics file format (.jpg extension in Windows) supported by many Web browsers that was developed for compressing and storing photographic images.

M
Microsoft Access database: A collection of data and objects, such as tables, queries, or forms, related to a particular topic or purpose. The Microsoft Jet database engine manages the data.
Microsoft Office Web Components: Interactive components, such as spreadsheets, charts, and PivotTable lists on Web pages that facilitate data analysis. To use these components, you must have an Office 2003 license.
Microsoft SQL Server database: A database in Microsoft SQL Server that consists of tables, views, indexes, stored procedures, functions, and triggers.

P
path: The route the operating system uses to locate a folder or file; for example, c:\House finances\March.doc.
PivotTable list: Similar to a Microsoft Excel PivotTable report, a PivotTable list displays data in a row and column format. A PivotTable list provides interactive capabilities in Microsoft Internet Explorer, enabling you to reorganize the data by moving rows to columns and columns to rows, displaying totals at the intersection of rows and columns, and otherwise rearranging and summarizing the data to analyze it in different ways. A PivotTable list includes its own toolbar and built-in Help.

R
record navigation toolbar: A toolbar that contains buttons for adding, deleting, saving, undoing changes to, sorting, filtering, and moving between records, and getting Help. In a grouped data access page, each group may have its own record navigation toolbar that's located at the bottom of the expanded group.

S
spreadsheet: A feature on a data access page that is similar to a Microsoft Excel worksheet. Using a spreadsheet, you can enter raw data, add formulas, apply filters, and perform additional spreadsheet operations. A spreadsheet includes its own toolbar and built-in Help.

U
Uniform Resource Locator (URL): An address to an object, document, page, or other destination (for example, a newsgroup or a World Wide Web page) on the Internet or an intranet. A URL expresses the protocol (such as FTP or HTTP) to be accessed and where the destination is located. A URL may also specify an Internet e-mail address. Some examples of URLs are: http://www.someones.homepage/default.html, ftp://ftp.server.somewhere/ftp.file, news:alt.hypertext
Universal Naming Convention (UNC): A naming convention for files that provides a machine-independent means of locating the file. A UNC name will usually include a reference to a shared folder and file accessible over a network rather than a folder and file that's specified by a drive letter and path. For example, the UNC name for a database named Northwind.mdb on a shared directory named Samples on a computer called MyWorkstation would be \\MyWorkstation\Samples\Northwind.mdb. The UNC is particularly useful in Web-based applications because it allows you to reference data that is not necessarily stored on a particular Web server.

previous page start next page