微软office 2010中文官方培训课件-生成和发布 web 数据库 -2_第1页
微软office 2010中文官方培训课件-生成和发布 web 数据库 -2_第2页
微软office 2010中文官方培训课件-生成和发布 web 数据库 -2_第3页
微软office 2010中文官方培训课件-生成和发布 web 数据库 -2_第4页
微软office 2010中文官方培训课件-生成和发布 web 数据库 -2_第5页
已阅读5页,还剩10页未读 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

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

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论