Access Web Apps  «Prev  Next»

Lesson 5 Creating a data entry style data access page
Objective Use the Page Wizard to create a data entry style page.

Utilizing Page Wizard for Creating a Data Entry Style Page in Microsoft Access 2019

This document offers a comprehensive guide on employing the Page Wizard in Microsoft Access 2019 for generating a data entry style page. It elucidates the step-by-step process and key considerations for efficiently designing a seamless and functional data entry interface, ensuring precise and organized data collection.
The Page Wizard in Microsoft Access 2019 is a powerful tool for creating structured and user-friendly data entry style pages. It allows administrators to design forms tailored for efficient data input, ensuring accuracy and consistency in data collection. Utilizing the Page Wizard effectively is pivotal for generating interfaces that streamline the data entry process, enhancing the overall productivity and reliability of database systems.

Step-by-Step Process:

  1. Launch Microsoft Access 2019: Open the Microsoft Access 2019 application and select the relevant database where the data entry style page will be incorporated.
  2. Navigate to the Page Wizard:
    1. In the Navigation Pane, click on the 'Create' tab.
    2. In the 'Forms' group, select ‘Form Wizard’. This action initiates the Page (Form) Wizard.
  3. Select Data Source: Choose the table or query to be used as the data source for the data entry style page. This source will determine the fields available for data entry in the created page.
  4. Select Fields for Data Entry: Add the desired fields from the available list by selecting and moving them to the selected fields' section. Ensure to only include fields pertinent for data entry to maintain an organized and efficient interface.
  5. Define Form Layout: Choose the desired layout for the data entry style page. Access 2019 offers various layout options including Tabular, Datasheet, and others. Select one that aligns with the data entry requirements.
  6. Apply Style: Choose a style for the data entry page from the available options. Apply a style that ensures clarity and ease of navigation for users engaging in data entry.
  7. Name the Data Entry Page: Provide a descriptive and succinct name for the data entry style page. This name should reflect the purpose and content of the page for easy identification.
  8. Finish the Wizard: Review the settings and configurations, and click 'Finish' to create the data entry style page. The Page Wizard will generate the page based on the provided specifications.
In conclusion, the Page Wizard in Microsoft Access 2019 is an invaluable asset for administrators in developing efficient and structured data entry style pages. Following the outlined steps ensures the creation of a reliable and user-friendly data entry interface, fostering accurate and organized data collection. Proper utilization of this tool significantly augments the overall effectiveness and reliability of database management in Microsoft Access 2019.

Data Entry Style Pages

Data entry style pages are useful when you have a need to just enter data. They are not for examining large amounts of records because you will have to move record by record. The data entry style page is just like creating a form that’s in Single Form view.
As with other Access objects, wizards are provided to help you create DAPs. In this lesson you will use the Data Access Page Wizard to help you create the simplest of the DAPs, a data entry page. When using the wizard you will be asked to specify:
  1. The record source
  2. The fields that you want to display or update
  3. Which sort order to use

In addition to the items just listed, you can also specify that you would like to use a Theme for your page. Similar to formatting forms and reports, the themes you can choose from are those that are used in Microsoft Expression Web.

Microsoft Expression Web and Microsoft SharePoint Designer.

Microsoft Expression Web was a web design and development application that was released in 2006. It was designed to be a more powerful and flexible alternative to FrontPage, and it offered a number of features that FrontPage did not, such as support for CSS, XHTML, and JavaScript. However, Expression Web was discontinued in 2012.
Microsoft SharePoint Designer is a web design and development application that is still supported today. It is designed to help users create and manage SharePoint sites and applications. SharePoint Designer offers a number of features that are similar to Expression Web, such as support for CSS, XHTML, and JavaScript. However, SharePoint Designer is more focused on SharePoint development than Expression Web was.
In addition to Expression Web and SharePoint Designer, Microsoft also offers a number of other web development technologies, such as Visual Studio Code and Azure DevOps. These technologies are more powerful and flexible than Expression Web or SharePoint Designer, but they are also more complex to use.
Which technology is best for you depends on your needs and experience. If you are looking for a simple and easy-to-use web design tool, then SharePoint Designer is a good option. If you are looking for a more powerful and flexible web development tool, then Visual Studio Code or Azure DevOps is a better option.

Access Group Fields

If you choose to group field(s), then the page will no longer be able to be used for inputting data. The wizard warns you about this.
Microsoft Access "Group Fields" are still used in Microsoft Access 2019. They are used to group records in reports and queries. For example, you could use a group field to group sales records by region or product category. This would allow you to see how sales are performing in each region or category.
To use group fields in a report, you can use the Report Wizard or create the report manually. In the Report Wizard, simply select the fields that you want to group on and Access will create the report for you. To create a report manually, you will need to add the group fields to the report's design grid.
To use group fields in a query, you can use the Query Wizard or create the query manually. In the Query Wizard, select the group fields from the list of available fields and Access will create the query for you. To create a query manually, you will need to add the group fields to the query's design grid.
Group fields are a powerful tool for analyzing data in Microsoft Access. They can help you to identify trends and patterns in your data that you might not otherwise see. Here are some examples of how group fields can be used in Microsoft Access:
  1. Group sales records by region to see how sales are performing in each region.
  2. Group sales records by product category to see how each category is performing.
  3. Group employee records by department to see how each department is performing.
  4. Group customer records by country to see how sales are performing in each country.
  5. Group product records by price to see how sales are performing at different price points.

Group fields can be used in conjunction with other features of Microsoft Access, such as calculated fields and aggregate functions, to create powerful reports and queries that can help you to gain insights into your data.
The following series of steps discusses how to use the wizard to create a data entry style data access page.

Working with data Entry Sytle Data Access Page

  1. Starting at the Page list of the Database window, you would have created a data access page by double-clicking the icon for the second choice in the list, "Create data access page by using wizard".
  2. From the first screen of the Page wizard, you would have specified the company to be selected by double-clicking the Company field, seen in the Available Fields list on the left-hand side of the screen.
  3. With the Company field moved over to the Selected Fields list box, you would have specified another table from which to pull a field by clicking the drop-down arrow in the Tables/Queries list box.
  4. You would have viewed a list of fields by clicking Table: Projects.
  5. You would have viewed the list of fields from the Projects table in the Available Fields list by double-clicking the ProjectDescription field from the Available Fields list.
  6. The ProjectDescription field had been moved over to the Selected Fields column. To go to the next screen, you would have clicked Next >.
  7. You would have specified the Company field by clicking the ">" button.
  8. You would have then moved to the next screen by clicking Next >.
  9. You would have again moved to the next screen by clicking Next >.
  10. You would have opened the finished page by clicking the option button labeled "Open the page."
  11. You would have clicked the Finish button to exit the wizard.
  12. In the finished page, you would have expanded the first client’s projects by clicking the top-left plus sign.
  13. Finally, you viewed the first of the projects for this client in the finished page.

In the next lesson, you will learn how to use the Page Wizard to create a grouped page.