计算机二级access2012年真题50套重难点答案（Computer two access2012 years Zhenti 50 sets of heavy and difficult to answer）.docVIP

计算机二级access2012年真题50套重难点答案（Computer two access2012 years Zhenti 50 sets of heavy and difficult to answer） This article is contributed by miyusama DOC documents may experience poor browsing on the WAP side. It is recommended that you first select TXT, or download the source file to the local view. [1], (1): the employee table foreign key attribute description - input: Department No. two, (1) departments: Department: Department of (4) is higher than the average age (Select AVG ([age]) from [tTemp]) three, statistics: View - sort and name grouping: =left ([name], 1) - - - new ascending group header text box control - control source: =count ([ID]) (3): me.Caption=Format form load (Date, YY) + annual report output (4) font: me bt2.FontWeight=Ture preview report: Docmd.OpenReport! REmp, acviewPreview call: [exit - click event attribute - -mEmp error handling: errhanle: [2] two (2) showed higher than the average value of the input information: Please enter [to compare scores] (3) cross table: Class Number: left (tScore. No. 8) results: integer Rou nd(avg（[成绩]） 总计-表达式 三， ） （3）显 示时间-页面页脚：=Format(Date(),”yyyy”)+”年”+ Format（Date（） ，”m” ）+”月” 【3】一， （3）入校日期设为 xx 月 xx 日 xxxx：mm\月 dd\yyyy 【4】一， （4）设默认值为本年度 9 月 1 日：DateSerial（Year（Date（），9,1） ） 【5】一， （4）拆分表：工具-分析-表-下一步-选 student 表-否，自己拆-下一步-将“院系” 拖出来做钥匙-拖出另 2 项-原表 “学号” 做钥匙-下一步-不建查询-完成-进入 tStud 设计视 图-删除“院系”的标题-点“查询”-显示控件改为“文本框”二， （4）在职否-条件：-1 三， （3）=DLookUp（”名称” ，”tGr OUP = .. the department number Department ]) [6], (3): list of male, female (two, 1) to find the name of 2 words: Wang left ([tPatient]! [name], 1) - King len ( [tPatient]! [name]) --2 (2) statistics Monday with an average age of weekday ([tSubscribe]! [] appointment date) --2 (4): the doctors name query design form -[Forms]! [fQuery]! [tName] (three, 5) show all records: BBB.Form.RecordSource= select * from tStudent [7]. (3) the effectiveness of rules: =DateSerial (Year (Date) (-1), 5,1 (4)) set the password: password mask - Hu (5) - type self - access to sex: male f