How to Build a Website Using MS Access

Create a website using Microsoft Access software, including forms and reports your users can access. Allow your users to enter, view or edit data through MS Access access pages. Data access pages act as Web portals to your database information. Create data access pages for users to review your Access database on both private networks, such a company, and public networks, such as your own personal website. Data access pages can be created within your database or outside your database.

Instructions

Difficulty:

Step 1

Open an Access database.

Step 2

Create the elements you want to include in your data access page or pages, including tables to store information, queries to manipulate data, forms and reports.

Step 3

Press the “Pages” section in the database objects window.

Step 4

Press “New” to create a new data access page.

Step 5

Choose either “Design View” or “Wizard” to create your data access page. Design View creates a blank template, similar to a form or report, for you to create your data access page from scratch. Use the Wizard mode to create a data access page through guided steps. The page can be edited at any point after creation.

Step 6

Add components, such as fields, buttons and links, to your data access page using the Access toolbox. These components link to your database data.

Step 7

Right-click any component and choose “Properties” on your data access page to change the components properties, such as control source, name and event properties.

Step 8

Upload the data access pages and your database to your network server or Web host. The exact steps for this will vary greatly depending on the type of server or host.

References

• microsoft office: create a data access page

Resources

• microsoft office: create a data access page
• microsoft office: data access pages

Tips & Warnings

• Create other data access pages and link the pages to each other by adding links to your data access pages. This creates a website for users to view and manipulate data. To create a stand-alone data access page, see the "Microsoft Office: Create a Data Access Page" link in Resources. For more information on customizing data access pages, see the "Microsoft Office: Data Access Pages link."
• Create other data access pages and link the pages to each other by adding links to your data access pages. This creates a website for users to view and manipulate data.
• To create a stand-alone data access page, see the "Microsoft Office: Create a Data Access Page" link in Resources. For more information on customizing data access pages, see the "Microsoft Office: Data Access Pages link."
• You can only create data access pages in Access 2003 and earlier versions. Access 2007 and 2010 do not support data access pages. Only provide users with access to the data access pages. Do not provide access to the database itself, or else users will be able to change your database and all data.
• You can only create data access pages in Access 2003 and earlier versions. Access 2007 and 2010 do not support data access pages.
• Only provide users with access to the data access pages. Do not provide access to the database itself, or else users will be able to change your database and all data.