




已阅读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. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2025-2030中国纳迪克酸酐行业应用动态及投资盈利预测报告
- 2025年事业单位工勤技能-海南-海南电工五级(初级工)历年参考题库含答案解析
- 中医药现代化进程中纳米比亚市场拓展前景分析报告
- 工业互联网平台微服务架构性能测试报告:2025年技术演进与市场前景
- 新能源二手车市场2025年流通渠道创新与评估模型研究报告
- 音乐产业2025年版权运营技术突破与音乐科技创新前景分析报告
- 2025-2030中国空白印刷电路板标签(PCB 标签)发展趋势及投资动态预测报告
- 2025年事业单位工勤技能-河南-河南汽车驾驶与维修员一级(高级技师)历年参考题库典型考点含答案解析
- 2025年事业单位工勤技能-河南-河南放射技术员四级(中级工)历年参考题库典型考点含答案解析
- 2024版医用外科口罩购销合同
- 收回员工股权协议书
- 药浴培训课件
- 人民警察职业道德教育
- 小学语文新课标跨学科学习任务群解读及教学建议
- 护士执业资格考试知识点大全2025
- 资料装订合同协议
- 闲置设备日常管理制度
- 阿尔兹海默症康复护理
- (2025)全国交管12123学法减分考试题库附答案
- 名人传课件完整版本
- 能源管理体系内审员培训课程
评论
0/150
提交评论