微软office 2010中文官方培训课件-生成和发布 web 数据库 -2

Save a changed database to the web,Build and publish web databases,Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.,Create a web database from scratch,Build and publish web databases,Point to the bottom of the video to see the video controls. Drag or point along the progress bar to move forward or go back.,Suggestions for practice,Download a web database template.Trust the database and log in. Change placeholder values.Add a field to a form. Publish a database the first time. Change a published database.Save (synch) a changed database to the web.,Build and publish web databases,Online practice,Test question 1,To publish a new web database for the first time, you go to Backstage view. Then what? (Pick one answer.),Build and publish web databases,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.,Test question 1,Build and publish web databases,After you publish your database the first time, Access adds the server URL to a list for easier reuse. If you change your database, you save your changes to the web by using the Sync All command on the Info tab.,To publish a new web database for the first time, you go to Backstage view. Then what?,Answer:,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.,Test question 2,To alter a value list in a web database, you do what? (Pick one answer.),Build and publish web databases,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 dont need to right-click anything. Just double-click the field and start typing.,Test question 2,Build and publish web databases,You can also right-click the field header, click Modify Lookups, and use the Lookup Wizard to alter the list.,To alter a value list in a web database, you do what?,Answer:,Open the table in Datasheet view, right-click a record in the field with the value list and click Edit List Items.,Test question 3,In a web database, you can use aggregate functions in your queries. (Pick one answer.),Build and publish web databases,True.False.,Test question 3,Build and publish web databases,Use aggregate functions in reports (grouping and totaling) or data macros.,In a web database, you can use aggregate functions in your queries.,Answer:,False.,Test question 4,You can add client objects to a web database. (Pick one answer.),Build and publish web databases,True.False.,Test question 4,Build and publish web databases,You can add client objects and create a hybrid database, but you cant publish those objects. You can only use them when the database is open in Access.,You can add client objects to a web database.,Answer:,True.,Test question 5,Which of the following is not a rule for web databases? (Pick one answer.),Build and publish 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.,Test question 5,Build and publish web databases,You can set indexing and create a one-to-one relationship, and you can create junction tables and create many-to-many relationships.,Which of the following is not a rule for web databases?,Answer:,You can only create one-to-many relationships in a web database.,Quick Reference Card,For a summary of