The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Home Intranet - Link to Outlook Contacts?



Mark,

Picking up on your IE reading an Access DB idea, this is from the=20
Access (2000) help.  Mail me if you want to think this through=20
further.

Nick

----------------------------


Data access pages: What they are and how they work
A data access page is a special type of Web page designed for=20
viewing and working with data from an Internet or intranet =97 data=20
that is stored in a Microsoft Access database or a Microsoft SQL=20
Server database. The data access page may also include data from=20
other sources, such as Microsoft Excel.=20

This topic provides reference information about:

Designing different types of data access pages

Using data access pages in Internet Explorer

Using data access pages in Microsoft Access

Designing different types of data access pages
You design data access pages in page Design view in Microsoft=20
Access. The page is a separate file that is stored outside Microsoft=20
Access; however, when you create the file, Microsoft Access=20
automatically adds a shortcut to the file in the Database window.=20
Designing a data access page is similar to designing forms and=20
reports =97 you use a field list, the toolbox, controls, the Sorting=20
and Grouping dialog box, and so on. However, there are some=20
significant differences in the way that you design and interact with=20
data access pages as opposed to forms and reports. How you design=20
the page depends on what it will be used for:=20

Interactive reporting   This type of data access page is often used=20
to consolidate and group information that is stored in the database,=20
and then publish summaries of the data. For example, a page might=20
publish the sales performance for each region in which you do=20
business. Using expand indicators, you can go from a general summary=20
of the information, such as a list of all the regions and their=20
combined sales total, to specific details on individual sales within=20
each region. While the data access page may also provide toolbar=20
buttons for sorting and filtering the data, you can't edit data on=20
this type of page. See an example and learn more about data access=20
pages that group records for interactive reporting.=20


Data entry   This type of data access page is used to view, add, and=20
edit records. Learn more about data access pages used for data entry.


Data analysis   This type of data access page may include a=20
PivotTable list, similar to a Microsoft Access PivotTable form or=20
Microsoft Excel PivotTable report, that lets you reorganize the data=20
to analyze it in different ways. The page might contain a chart that=20
you can use to analyze trends, detect patterns, and compare data in=20
your database. Or the page might contain a spreadsheet in which you=20
can enter and edit data, and use formulas to calculate as you do in=20
Microsoft Excel. See an example of a data access page used for data=20
analysis.=20
Return to top

Using data access pages in Internet Explorer
A data access page is connected directly to a database. When users=20
display the data access page in Microsoft Internet Explorer, they=20
are viewing their own copy of the page. That means any filtering,=20
sorting, and other changes they make to the way the data is=20
displayed  =97 including changes they make within a PivotTable list or=20
spreadsheet  =97 affect only their copy of the data access page.=20
However, changes that they make to the data itself  =97 such as=20
modifying values, and adding or deleting data =97 are stored in the=20
underlying database, and therefore are available to everyone viewing=20
the data access page.

Users get Help on how to work with the page in Internet Explorer by=20
clicking the Help  button on the record navigation toolbar. The Help=20
file that displays is automatically included with any data access=20
page that's published with a record navigation toolbar. If you=20
delete the record navigation toolbar or if you disable the Help=20
button on it, you should provide instructions for those who will use=20
the page.

Note   To view and work with the data access page on the Internet or=20
an intranet, users need Microsoft Internet Explorer 5 and a=20
Microsoft Office 2000 license.=20

Return to top

Using data access pages in Microsoft Access
You can also work with a data access page in Page view in Microsoft=20
Access. Data access pages can supplement the forms and reports that=20
you use in your database application. When deciding whether to=20
design a data access page, form, or report, consider the tasks that=20
you want to perform.

You get Help on how to work with the page in Page view by clicking=20
the Help button on the Page View toolbar to display Access Help.=20
Clicking the Help button on a record navigation toolbar on the page=20
displays Help for working with the page in Internet Explorer. As=20
mentioned previously, this Help file is automatically included with=20
any data access page that's published with a record navigation=20
toolbar. You can delete the Help button on pages that are used only=20
within Access, or you can modify the button to provide custom Help.

Return to top

More information
Create a data access page







Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.