Page 6 of 7PREVNEXT

Build and publish web databases

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


To publish a new web database for the first time, you go to Backstage view and:

On the Info tab, click Sync All. Enter the URL of your SharePoint server and a name for the site, then click Publish.

On the Recent tab, right-click a database and click Publish to Access Services. Enter the URL of your server and a name for the site, and click Publish.

On the Save & Publish tab, click Publish to Access Services. Enter the URL of your Server and a name for the site, then click Publish to Access Services again.

On the Save & Publish tab, click Save Database As. Use the Save As dialog box to navigate to your SharePoint Server, and once you open the parent folder for the site, click Publish to Access Services.

To alter a value list in a web database, you:

Open the table in Design view, click the Lookup tab, and alter the values in the Row Source box.

Open the table in Datasheet view, right-click a record in the field with the value list and click Edit List Items.

Click the Fields tab on the ribbon, and in the Properties group, click Default Value.

You don’t need to right-click anything. Just double-click the field and start typing.

In a web database, you can use aggregate functions in your queries.

True.

False.

You can add client objects to a web database.

True.

False.

Which of the following is not a rule for web databases?

You must use Layout view to change a form or report.

You must use Lookup fields instead of table relationships.

You can only create one-to-many relationships in a web database.

You must create tables in Datasheet view.

Page 6 of 7PREVNEXT