what information to have to develop a website

Important   Microsoft no longer recommends creating and using Access 2010 spider web databases. For more information, see Access 2010 web databases roadmap.

You lot tin can use Access 2010 and Access Services, a component of SharePoint, to build web database applications. This helps you:

• Secure and manage admission to your information

• Share information throughout an organisation, or over the Cyberspace
  

  Note: A user account is required to utilise a web database. Anonymous access is not supported.

• Create database applications that don't require Admission to employ

This article provides an overview of Access web database design. For an introduction to desktop database design, see the articles Create a new desktop database and Database design basics.

In this article

• Overview

• Create a web database

• Publish and synchronize changes to your application

Overview

Admission 2010 and Access Services (an optional component of SharePoint) provide a platform for you to create databases that you can apply on the Spider web. Yous blueprint and publish a web database by using Access 2010 and SharePoint, and people who take SharePoint accounts use the web database in a web browser.

How it works

When you publish a web database, Access Services creates a SharePoint site that contains the database. All of the database objects and data move to SharePoint lists in that site. The following video illustrates the procedure.

After you publish, SharePoint visitors tin employ your database, based on their permissions for the SharePoint site.

• Total Control    This lets yous make data and blueprint changes.

• Contribute    This lets yous make data changes, but non design changes.

• Read    This lets you lot read information, simply you lot can't alter annihilation.

You tin open up the web database in Access, revise the pattern, and so sync your changes — effectively, save them to the SharePoint site. The following video illustrates the process of making a design alter after you have published your web database.

You can also have your web database offline, apply the offline version, then sync data and pattern changes when you lot are back online.

Note:To build a spider web database, you demand Total Control permissions on the SharePoint site where y'all want to publish it. For more data almost SharePoint permissions, meet the Encounter Also section.

Forms and reports run in the browser

Forms, reports, and almost macros run inside the browser. This lets Access refresh data on the screen without having to redo the whole page.

You can create a course to assistance people navigate your application. A new control, the Navigation control, makes information technology easy to add standard Web-style navigation buttons to a grade for this purpose.

Note:The Navigation Pane (the characteristic that you utilise in Admission to browse the objects in a database) is non available in a spider web browser.

Data is stored in SharePoint lists

All of your tables get SharePoint lists, and records get list items. This lets yous use SharePoint permissions to command access to your web database, likewise every bit take advantage of other SharePoint capabilities.

Security Note: The connect string for linked tables is unencrypted, including the username and countersign if that data was saved (and the link target supports user accounts). In a database that has a link to a SharePoint list and the link includes the username and password, a malicious user could change which list is the target of the link, using the saved credentials. Even if the credentials aren't saved with the connect string, a malicious user could modify permissions on the SharePoint site with the aid of a collaborator who already has sufficient permissions. Exercise circumspection when you share copies of a database that contains links to lists in a published web database.

Queries and data macros run on the server

All SQL processing happens on the server. This helps improve network performance by limiting traffic to result sets.

Intranet or Internet

You can publish to your own intranet SharePoint server, or to the Internet. Microsoft is offering an Internet-facing, hosted SharePoint solution.

Top of Page

Create a web database

This department describes cardinal new features and provides steps for the basic design tasks you lot need to complete to create a web database.

In this section

• Before you brainstorm

  • Pattern differences between desktop and web databases

  • Desktop-only features with no Access Services counterpart

• Consider using a template

• Get started with a bare web database

• Pattern a web tabular array

  • Create a new web table

  • Add a field from the field gallery

  • Add a field past clicking the datasheet

  • Change field backdrop

• Add a calculated field

• Set upwards data validation rules

  • Prepare a field validation dominion and bulletin

  • Gear up a tape validation rule and message

• Create a relationship between two web tables

  • Create a lookup field in Datasheet view

• Change a lookup field in Datasheet view

• Maintain data integrity by using data macros

• Create a web query

• Create a spider web course

• Create a web report

• Create a Navigation form and prepare it as the default grade to display on start

Before y'all begin

There are a few tasks that you should perform earlier you first to design your web database. Moreover, there are design differences between web databases and desktop databases that you lot should know nigh, especially if you are an experienced Access developer.

• Determine the purpose of your database    Have a clear program so you tin make skilful decisions when working out pattern details.

• Detect and organize the data required    You cannot employ linked tables in a spider web database. Any data that you want to utilize that will not originate in the database must be imported before yous publish. If you line upwards your data before you commencement designing, you tin avoid having to refit your design to accommodate unexpected data challenges.

• Place the SharePoint site yous will utilise to publish    You cannot publish at all without SharePoint. If y'all desire to examination your design in a browser while yous design it (not a bad idea), y'all have to publish it first.

• Programme your security    You lot can take reward of SharePoint security to control access to your web database. Plan security early on so you can build it into your design.

Design differences between desktop and web databases

Some database features that yous can utilise in a desktop database are not bachelor with Access Services. However, there are new features that support many of the same scenarios as these desktop features.

The following table lists the desktop-but features, and the new feature that helps back up the same scenario.

Scenario	Desktop-just characteristic	New characteristic
Designing database objects	Design view	Enhanced Datasheet view; Layout view
Reviewing summarized information, such as sums, averages, and groups	Grouping functions	Data macros; grouping functions in reports
Programming events	VBA	Macros and data macros; New macro design experience with IntelliSense
Navigate to a database object	Navigation Pane; switchboards	Navigation control or other form element

Important:You tin can create many client objects in a web database, but you cannot apply them in a browser. Yet, they are role of the spider web database and can exist used in Access 2010 on the desktop. People can open the web database in Access, and then use the client objects. This is an effective manner to share a database, and also opens new opportunities for working together over the Web. SharePoint handles any concurrency issues.

Desktop-only features with no Access Services counterpart

Annotation:The following list is non exclusive.

• Union queries

• Crosstab queries

• Overlapping controls on forms

• Table relationships

• Conditional formatting

• Various macro actions and expressions

Consider using a template

When you take determined what your application must do, consider whether a database template would work. Database templates are pre-built applications that you can use equally-is or modify to arrange your particular needs.

You tin review the available templates on the New tab in Backstage view. For more than information well-nigh the templates that come with Access 2010, run into the article Select and use an Access template.

Get started with a blank web database

• On the File tab, click New.

  

The File tab opens Backstage view, a new part of the Access interface where you lot'll discover commands that employ to an unabridged database, such as Publish to SharePoint.

In Backstage view, the New tab has commands for creating a database.

one. Under Available Templates, click Blank Spider web Database.

2. Review the proposed file proper name in the File Name box, and the path for the database file, listed simply below. You can change the file name past typing in the File Name box.

3. To change the path, click the binder icon next to the File Name box to browse for a location to put your database file.

iv. Click Create. Your new spider web database opens and displays a new empty table.

Blueprint a web table

You lot use Datasheet view to design a web table.

When you starting time create a blank web database, Admission creates a new table and opens it in Datasheet view. You tin can employ the commands on the Fields tab and the Table tab to add fields, indexes, validation rules, and data macros — a new characteristic that lets you change information based on events.

After you edit and use the new tabular array, you'll most likely want to create more tables.

Create a new spider web tabular array

With your web database open:

• On the Create tab, in the Tables group, click Table.

When you lot get-go create a table, it has i field: an AutoNumber ID field. You tin can add new fields to store the items of information required by the table discipline. For example, you might desire to add a field that stores the date yous begin tracking something.

Add together a field from the field gallery

You can choose from a diversity of preformatted fields and add them to your table past using the field gallery.

• On the Fields tab, in the Add & Delete grouping, click the field type that you want.

Add a field past clicking the datasheet

1. With the table open, click Click to Add, and so select a field type.

2. Give the field a name that reflects its contents.

   Tip:To change the name of an existing field, double-click the field name.

3. Repeat for each field that you want to create.

Change field properties

Formatting and properties decide how a field behaves, such as what kind of data it tin store. You can alter these settings then that the field behaves the fashion that you want.

1. Select the field that has formatting and backdrop that you desire to modify.

2. On the ribbon, click the Fields tab.

3. Utilize the commands in the Formatting and Backdrop groups to change the settings.

Add a calculated field

You can add a field that displays a value that is calculated from other information in the aforementioned tabular array. Data from other tables cannot be used as the source for the calculated data. Some expressions are not supported past calculated fields.

1. With the table open, click Click to Add.

2. Signal to Calculated Field, and then click the data type that you want for the field.

   The Expression Builder opens.

3. Use the Expression Builder to create the calculation for the field. Recall that y'all can only use other fields from the aforementioned table as data sources for the adding. For Assist using the Expression Builder, see the article Apply the Expression Builder.

Set up data validation rules

You can use an expression to validate input for nearly fields. You can too use an expression to validate input for a table, which can be useful if you desire to validate input for a field that does not back up validation, or if you want to validate field input based on the value of other fields in the tabular array. For a more thorough explanation of validation, see the article Restrict data input by using a validation rule.

Y'all can also specify the message that is displayed when a validation dominion prevents input, known as a validation message.

Fix upwards a field validation rule and bulletin

1. Select the field to which yous want to add a validation rule.

2. On the ribbon, click the Fields tab.

3. In the Field Validation group, click Validation, and then click Field Validation Rule.

   The Expression Builder opens.

4. Use the Expression Builder to create your validation rule. For Help using the Expression Architect, see the article Use the Expression Builder.

5. In the Field Validation group, click Validation, and then click Field Validation Message.

6. Blazon the message that you want to display when input data is not valid, and so click OK.

Set up a tape validation rule and message

Y'all can apply a record validation rule to prevent indistinguishable records, or to require a certain combination of facts about the tape are true, such as [Outset Date] is greater than January 1, 2010, and less than [End Date]

1. Open up the tabular array to which yous want to add a validation rule.

2. On the ribbon, click the Fields tab.

3. In the Field Validation group, click Validation, so click Record Validation Rule.

   The Expression Builder opens.

4. Utilise the Expression Builder to create your validation dominion. For Assist using the Expression Architect, come across the article Utilise the Expression Builder.

5. In the Field Validation group, click Validation, and then click Record Validation Bulletin.

6. Type the message that you want to display when input data is not valid, and then click OK.

Create a relationship between two web tables

To create a relationship in a spider web database, you use the lookup wizard to create a lookup field. The lookup field goes in the table that is on the many- side of the relationship, and points to the table that is on the one- side of the relationship.

Create a lookup field in Datasheet view

1. Open the table that you want on the many- side of the relationship.

2. Click the arrow next to Click to Add, and then click Lookup & Human relationship.

3. Follow the steps of the Lookup Wizard to create the lookup field.

Alter a lookup field in Datasheet view

1. Open up the tabular array that has the lookup field that y'all want to alter.

2. Do one of the following:

   • On the Fields tab, in the Properties group, click Modify Lookups.

   • Correct-click the lookup field, so click Modify Lookups.

3. Follow the steps of the Lookup Wizard.

Maintain data integrity by using data macros

You can implement pour updates and deletes by using data macros. You tin can use commands on the Table tab to create embedded macros that modify information. The following video shows you the nuts.

For more information about creating data macros, see the article Create a data macro.

Create a spider web query

You tin use a query as the data source for forms and reports. Queries run on the server, helping minimize network traffic.

For instance, suppose you utilise a spider web database to rails charitable contributions. Yous want to see who donated money while an event was occurring. Y'all could use a query to select the data and set up it for apply in forms and reports.

Note:This procedure uses the charitable contributions template equally an example. You lot can follow along if you create a new database by using the charitable contributions database template.

1. On the Create tab, in the Queries group, click Query.

2. In the Show Table dialog box, double-click each tabular array that you want to include, and then click Close.

   In this example, double-click Constituents, Donations, Events, and EventAttendees.

3. Create any required joins past dragging fields from one object to another in the query design window.

   In this example, drag the ID field from Constituents to the DonorConstituentID field in Donations, and then drag the DonorConstituentID field from Donations to the ConstituentID field in EventAttendees.

4. Add the fields that you desire to use. You can elevate the fields to the grid, or you lot tin can double-click a field to add it.

   In this example, add Event from the table Events, DonationDate from the table Donations, and Greeting, FirstName, and LastName from the tabular array Constituents.

5. Add together any criteria that you lot want to apply.

   In this case, y'all want to limit DonationDate and so that it falls betwixt the StartDate and EndDate of the event. In the query blueprint grid, in the Criteria row under DonationDate, type >=[StartDate] And <=[EndDate].

Create a spider web course

Forms are the principal way to enter and edit information in your web database, and are likewise useful for reviewing information. Forms run in the browser, helping optimize operation. When you open a form, your browser retrieves the required data from the SharePoint server. Y'all tin filter and sort the information in the course without having to call back information from the server again.

Tip:For best performance, limit the records retrieved past your main forms and reports.

1. Select a table or query to use equally a information source.

   Note:If you lot want to create an unbound form, skip this step.

2. On the Create tab, in the Forms group, click ane of the following buttons:

   • Class    Create a elementary form that shows one tape at a time, using the object you selected as a information source.

     Notation:If you are creating an unbound form, this push is not available.

   • Multiple items    Create a form that shows multiple records at a time, using the object you selected as a data source.

     Annotation:If you are creating an unbound form, this push button is non available.

   • Blank form    Create a course that has cypher on information technology.

   • Datasheet    Create a course that looks and behaves similar a datasheet, using the object yous selected as a data source.

     Note:If y'all are creating an unbound form, this button is not bachelor.

Create a web study

Reports are the primary mode to review or print data from your web database. Reports run in the browser, helping optimize performance. When yous 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 information from the server again.

Tip:For best performance, limit the records retrieved by your main forms and reports.

1. Select a table or query to apply equally a data source.

2. On the Create tab, in the Reports group, click one of the following buttons:

   • Report    Create a basic report using the object yous selected equally a data source.

   • Blank Report    Create a report that has nothing on it.

Create a Navigation form and ready it equally the default form to display on start

People need a way to navigate your application. Remember — the Navigation Pane is not bachelor in a web browser. For people to employ your database objects, you must provide them a ways. Y'all can create a Navigation form and specify that information technology be displayed whenever someone opens your awarding in a web browser. Moreover, if you don't specify a form to brandish when the application starts, no form volition open, making it hard for anyone to use the awarding.

Tip:Yous 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.

1. On the ribbon, click the Create tab.

2. In the Forms group, click Navigation, and then select a navigation layout from the list.

3. To add an detail, drag it from the Navigation Pane to the Navigation control.

   Note:You tin can only add forms and reports to a Navigation control.

4. Add together any other controls that you lot want to the body of the Navigation form. For example, y'all might want to provide search functionality across all forms by calculation some controls to your Navigation form.

Set your navigation form equally the default web display form

1. On the File tab, nether Assist, click Options.

2. In the Admission Options dialog box, click Electric current Database.

3. Under Application Options, click Web Display Form, then select the form that you lot want from the list.

   Notation: Y'all exercise not accept to select your navigation form equally the spider web display course. You tin can specify any web grade.

Summit of Page

Publish and synchronize changes to your awarding

Publish a spider web database

Y'all can watch a video of this process in the Overview section.

1. On the File tab, click Save & Publish, and then click Publish to Access Services.

2. Click Run Compatibility Checker.
   
   The compatibility checker helps you brand sure that your database will publish correctly. If it discovers any problems, you should address them before you publish.
   

   Note: If whatsoever issues are discovered, Access stores them in a table called Web Compatibility Issues. Each row in the table contains a link to troubleshooting information.

3. Nether Publish to Access Services, fill in the following:

   • In the Server URL box, type the web address of the SharePoint server where you want to publish the database. For example, http://Contoso/.

   • In the Site Proper name box, type a proper name for your web database. This name will be appended to the Server URL to produce the URL for your awarding. For example, if the Server URL is http://Contoso/ and the Site Name is CustomerService, the URL is http://contoso/customerservice.

4. Click Publish to Access Services.

Synchronize a web database

After you brand design changes or have a database offline, y'all eventually want to synchronize. Synchronizing resolves differences betwixt the database file on your figurer and the SharePoint site.

Yous can watch a video of this process in the Overview section.

1. Open the web database in Access and make your design changes.

2. When you are finished, click the File tab, and then click Sync All.
   

Top of Page

vizcarraoffs1956.blogspot.com

Source: https://support.microsoft.com/en-us/office/build-an-access-database-to-share-on-the-web-cca08e35-8e51-45ce-9269-8942b0deab26