Chapter Summary

• Data access pages are Web pages you create in Access. They allow users to view and work with a database over the Internet or an intranet.

• Sources for a data access page can be Microsoft Access, Microsoft SQL Server 6.5 or later, and Microsoft Excel.

• Microsoft Access stores data access pages in an Internet file format using the .htm extension.

• You can open data access pages in either Access or via Internet Explorer 5.01 with Service Pack 2 (SP2) or later.

• Data access pages created in Microsoft Access 2003 cannot be opened in Design view in older versions of Access.

• Creating a data access page in Design view allows you to manage the data access page's connection to a data source through the page connection properties link.

• Database fields can be added to your data access page from either tables or queries using the field list.

• Data access pages are broken into sections: caption, group header, group record, record navigation, and footer.

• Access binds controls on a data access page to the data source field (just like bound controls on an Access form).

• You can graphically display a one-to-many relationship in a data access page by creating additional group sections.

• Data access pages are typically published to either a file server such as Microsoft Windows 2000 or a Web server such as Microsoft IIS.

• Logon procedures for an Access database must be enabled before you can implement user-level security permissions.

• By default, Access 2003 databases come with two groups, Users and Admins. Also by default, Access comes with one user account called Admin belonging to the Admins group.

• Clearing the Admin user account's password disables logon procedures for an Access database.

• Creating or changing the Admin account's password enables logon procedures.

• The User-Level Security wizard is a robust security mechanism for protecting your Access databases.

• The User-Level Security wizard allows you to make a new workgroup information file to enable your Access database with security-enhanced features.

• Users can join a workgroup that has security-enhanced features created by the User-Level Security wizard.

• To disable user-level security, clear the Admin user password and rejoin the default workgroup information file installed with Microsoft Access.

• Access allows you to link a data access page to a workgroup information file, which helps secure Access from data access pages.

0 0

Post a comment