Access web software

Tip: For best performance, limit the records retrieved by your main forms and reports. Note: If you want to create an unbound form, skip this step. On the Create tab, in the Forms group, click one of the following buttons:. Form Create a simple form that shows one record at a time, using the object you selected as a data source. Note: If you are creating an unbound form, this button is not available. Multiple items Create a form that shows multiple records at a time, using the object you selected as a data source.

Blank form Create a form that has nothing on it. Datasheet Create a form that looks and behaves like a datasheet, using the object you selected as a data source. Reports are the main way to review or print data from your web database. Reports run in the browser, helping optimize performance.

When you open a report, your browser retrieves the required data from the SharePoint server. You can filter and sort data in the report without having to retrieve data from the server again.

On the Create tab, in the Reports group, click one of the following buttons:. Report Create a basic report using the object you selected as a data source. Blank Report Create a report that has nothing on it. People need a way to navigate your application. Remember — the Navigation Pane is not available in a web browser. For people to use your database objects, you must provide them a means.

You can create a Navigation form and specify that it be displayed whenever someone opens your application in a web browser. Tip: You might want to wait until last to create your Navigation form, so that that you can add all your objects to the form when you create it. In the Forms group, click Navigation , and then select a navigation layout from the list.

Note: You can only add forms and reports to a Navigation control. Add any other controls that you want to the body of the Navigation form. For example, you might want to provide search functionality across all forms by adding some controls to your Navigation form. On the File tab, under Help , click Options. Under Application Options , click Web Display Form , and then select the form that you want from the list. Note: You do not have to select your navigation form as the web display form.

You can specify any web form. You can watch a video of this process in the Overview section. Click Run Compatibility Checker. The compatibility checker helps you make sure that your database will publish correctly. If it discovers any issues, you should address them before you publish. Each row in the table contains a link to troubleshooting information. In the Site Name box, type a name for your web database.

After you make design changes or take a database offline, you eventually want to synchronize. Synchronizing resolves differences between the database file on your computer and the SharePoint site. When you are finished, click the File tab, and then click Sync All. Access Access Access More Note: The following list is not exclusive.

Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Microsoft Access is the latest version of Access available as a one-time purchase. Access is compatible with Windows Elevate data Create your own database apps easily in formats that serve your business best. Buy now For home For business. Try for free For home For business.

Elevate data. Choosing Datasheet opens the Customers Datasheet view. Datasheet is the other kind of view Access automatically generates when you create a table. Datasheet views are useful for those who find it easier to enter, sort, and filter data in a spreadsheet-like manner. Choosing Groups opens a Summary view. Summary views can be used to group records based on a field and optionally calculate a sum or average.

As you're adding customers, use the Action Bar to add records, edit records, save records, delete records, and cancel edits. The Action Bar is a customizable toolbar that appears at the top of each view, as shown in Figure 5.

Once you've added some customers and employees open the Issues List view and start adding an issue. As you type the name of a customer into the into the Customer box, one or more of the customer names will appear, as shown in Figure 6.

The Customer box is an AutoComplete control. The AutoComplete control displays a list of records that match what you're typing into the box. This helps ensure the accuracy of data entry. Now that you've taken a tour of the app, you notice that the Issues List view doesn't contain contact information for the customer.

Let's customize the app to add the customer's work phone to the Issues table as the issue is being created. Now that we have field in which to store the phone number, let's create a data macro to look up the contact information. In the Create group, choose Advanced , and then choose Data Macro.

In the Name box, enter CustID. In the Type dropdown, choose Number Floating Decimal. Choose Save. Now we should write a user interface UI macro that copies the Work Phone field from the Customers table into the Contact Phone field of the Issues table. Then, select Create. Add structured or blank tables to the web app, or create tables from existing data sources.

Search for a table template based on the type of information you want to track, create a table from the existing source data, or add a blank table to customize yourself.

Excel training. Outlook training. Table of contents. Create an Access database. Desktop database or web app? Next: Add tables.

Table of contents Create an Access database. Access training.