上海  |   杭州   |   苏州  |   南京  |    北京  |   广东  |   天津  |   湖北  |   贵州  |   辽宁  |   山东  |   河北  |   重庆  |   陕西   |   四川  |  福建
Office 培训
Excel              应用培训
PPT                应用培训
Word              应用培训
Access          应用培训
Outlook          应用培训
Project           应用培训
操作系统       应用培训
SharePoint    应用培训
绘图制作培训
Adobe            应用培训
Visio              应用培训
CorelDraw   应用培训
专业设计培训
Auto CAD        应用培训
Pro/E                应用培训
Office专题培训
Office专题——人力资源
Office专题——市场营销
Office专题——行政文秘
Office专题——财务会计
Office专题——采购
·Microsoft Office Excel 2007认证
·Microsoft Office PowerPoint 2007
·Microsoft Office Word 2007 认证
·Office Access 2007认证
·Office Outlook 2007认证
·认证优势(MOS)
·Office相关软件开发
·Office高手外派协助
·Office高端技术支持--Office难题
·Office高端技术支持-- Excel美化与
·Office高端技术支持--PPT模板设计
·Office高端技术支持-- Word商务排版
  Office认证
Office Access 2007认证   发布时间:2010/10/11

Office Access 2007认证
Exam 70-605: PS: Using Microsoft®Office Access 2007
1. Structuring a Database
1.1. Define data needs and types
1.1.1. Define table fields 
1.1.2. Define appropriate table field data types for fields in each table
1.1.3. Define tables in databases 
1.2. Define and print table relationships
1.2.1. Create relationships
1.2.2. Modify relationships
1.2.3. Print table relationships
1.3. Add, set, change, or remove primary keys 
1.3.1. Define and modify primary keys 
1.3.2. Define and modify multi-field primary keys 
1.4. Split databases
2. Creating and Formatting Database Elements 
2.1. Create databases
2.1.1. Create databases by using templates 
2.1.2. Create blank databases
2.2. Create tables
2.2.1. Create custom tables in Design view
2.2.2. Create tables by copying the structure of other tables
2.2.3. Create tables from templates
2.3. Modify tables
2.3.1. Modify table properties
2.3.2. Evaluate table design by using the Table Analyzer
2.3.3. Rename tables
2.3.4. Delete tables
2.3.5. Summarize table data by adding a Total row 
2.4. Create fields and modify field properties 
2.4.1. Create commonly used fields
2.4.2. Modify field properties
2.4.3. Create and modify multi-valued fields 
2.4.4. Create and modify attachment fields
2.5. Create forms
2.5.1. Create forms by using Design view
2.5.2. Create datasheet forms
2.5.3. Create multiple item forms
2.5.4. Create split forms
2.5.5. Create sub-forms
2.5.6. Create PivotTable forms
2.5.7. Create forms by using Layout view 
2.5.8. Create simple forms
2.6. Create reports
2.6.1. Create reports as a simple report 
2.6.2. Create reports by using the Report Wizard
2.6.3. Create reports by using Design view
2.6.4. Define group headers
2.6.5. Create aggregate fields
2.6.6. Set the print layout
2.6.7. Create labels by using the Label Wizard
2.7. Modify the design of reports and forms
2.7.1. Add controls
2.7.2. Bind controls to fields 
2.7.3. Define the tab order of controls 
2.7.4. Format controls 
2.7.5. Arrange controls
2.7.6. Apply and change conditional formatting on controls
2.7.7. Apply AutoFormats to forms and reports
3. Entering and Modifying Data 
3.1. Enter, edit, and delete records 
3.2. Navigate among records
3.3. Find and replace data
3.4. Attach documents to and detach from records
3.5. Import data
3.5.1. Import data from a specific source
3.5.2. Link to external data sources 
3.5.3. Save and run import specifications
4. Creating and modifying queries
4.1. Create queries 
4.1.1. Create queries based on a single table 
4.1.2. Create queries based on more than one table
4.1.3. Create action queries
4.1.4. Create crosstab queries
4.1.5. Create sub-queries
4.1.6. Save filters as queries 
4.2. Modify queries
4.2.1. Add tables to and remove tables from queries
4.2.2. Add criteria to queries
4.2.3. Create joins
4.2.4. Create calculated fields in queries
4.2.5. Add aliases to query fields
4.2.6. Create sum, average, min, max, and count queries
5. Presenting and Sharing Data
5.1. Sort data
5.1.1. Sort data within tables
5.1.2. Sort data within queries
5.1.3. Sort data within reports
5.1.4. Sort data within forms
5.2. Filter data
5.2.1. Filter data within tables
5.2.2. Filter data within queries
5.2.3. Filter data within reports
5.2.4. Filter data within forms 
5.2.5. Remove filters 
5.3. Create and modify charts
5.3.1. Create charts
5.3.2. Format charts
5.3.3. Change chart types
5.4. Export data
5.4.1. Export data from tables
5.4.2. Export data from queries
5.4.3. Save and run export specifications
5.5. Save database objects as other file types 
5.6. Print database objects
6. Managing and Maintaining Databases
6.1. Perform routine database operations
6.1.1. Open databases
6.1.2. Back up databases
6.1.3. Compact and repair databases
6.1.4. Save databases as a previous version
6.2. Manage Databases
6.2.1. Encrypt databases by using passwords
6.2.2. Configure database options
6.2.3. Set database properties
6.2.4. Identify object dependencies
6.2.5. Print database information
6.2.6. Reset or refresh table links


------------------------------------------------------------------------------------------------------------------------------------------------------------

电  话:0571-28976128, 28976127     版权所有:杭州交网信息技术有限公司   备案序号:浙ICP备09066235号
Office培训专家 企业Office培训 小班Office培训 一对一Office培训 Excel培训 PPT培训 ACCESS培训 Outlook培训 Project培训 Word培训 SharePoint培训 Photoshop培训 Visio培训 CorelDraw培训 Auto CAD培训 Office认证培训考试 上海SharePoint培训 上海Excel培训 上海Project培训 上海Access培训 上海Word培训 上海Outlook培训 上海PPT培训 上海Adobe PhotoShop培训 上海Visio培训 上海CorelDraw培训 上海AutoCAD培训 上海Pro/E培训 杭州Excel培训 杭州PPT培训 杭州Adobe PhotoShop培训 杭州Visio培训 杭州SharePoint培训 杭州Outlook培训 杭州Access培训 杭州Project培训 杭州Word培训 杭州CorelDraw培训 杭州Pro/E培训 杭州AutoCAD培训 苏州Project培训 苏州PPT培训 苏州Access培训 苏州Excel培训 苏州Adobe PhotoShop培训 苏州Visio培训 苏州SharePoint培训 苏州Outlook培训 苏州AutoCAD培训 苏州CorelDraw培训 苏州Word培训 苏州Pro/E培训 南京Excel培训 南京Outlook培训 南京Project培训 南京Access培训 南京Word培训 南京PPT培训 南京Adobe PhotoShop培训 南京Visio培训 南京SharePoint培训 南京AutoCAD培训 南京Pro/E培训 南京CorelDraw培训 南京Excel培训 上海杭州苏州南京北京广东深圳天津湖北武汉贵州辽宁沈阳山东青岛济南河北重庆成都陕西 四川福建福州厦门