INFOCHINA全国office培训中心(46家)

加盟电话:400 600 1998

金融/保险专区

客户:中行  建行 法兴 三菱东京 PICC...

汽车/制造专区

客户:宝马 丰田 卡特彼勒 三一重工...

通信/电子专区
客户:移动、联通、澳电、 VERIZON 
石化/能源专区
客户:中石油 中石化 康菲 斯伦贝谢...
医疗/生物专区
客户:辉瑞、强生、合生元、诺和诺德...

 敬 告

诸多培训机构复制INFOCHINA培训大纲、培训客户、培训方案甚至公司简介,却没有专业讲师授课,让客户蒙受损失!INFOCHINA是宝马、华夏银行、卡特彼勒...全国唯一指定高端Office培训与服务提供商,如有雷同,绝非巧合。

Access Training in English:Access Develop

用户评价:  / 211
好 
课程简介

This Microsoft Access training course is designed for students new to working with Microsoft Access. Students will learn to get data out of existing databases and to create their own new databases.

培训对象

Good practical knowledge of Microsoft Access.

 

培训大纲

1  An Overview of Microsoft Access 
1.1   Understand Relational Databases 
1.2   Examine the Access Environment 
1.3   Open the Database Environment 
1.4   Examine an Access Table 
2  Managing Data in Microsoft Access 
2.1   Examine an Access Form 
2.2   Add and Delete Records 
2.3   Sort Records 
2.4   Display Recordsets
2.5   Update Records 
2.6   Run a Report 
3  Establishing Table Relationships in Microsoft Access 
3.1   Identify Table Relationships 
3.2   Identify Primary and Foreign Keys in the Relationships Window 
3.3   Work with Subdatasheets
4  Querying the Database in Microsoft Access 
4.1   Create a Select Query 
4.2   Add Criteria to a Query 
4.3   Add a Calculated Field to a Query 
4.4   Perform a Calculation on a Record Grouping 
5  Designing Forms in Microsoft Access 
5.1   Examine Form Design Guidelines 
5.2   Create a Form Using AutoForm
5.3   Create a Form Using the Form Wizard 
5.4   Modify the Design of a Form 
6  Producing Reports in Microsoft Access 
6.1   Create an AutoReport
6.2   Create a Report by Using the Wizard 
6.3   Examine a Report in Design View 
6.4   Add a Calculated Field to a Report 
6.5   Modify the Format Properties of a Control 
6.6   AutoFormat a Report 
6.7   Adjust the Width of a Report 
7  Planning a Database in Microsoft Access 
7.1   Design a Relational Database 
7.2   Identify Database Purpose 
7.3   Review Existing Data 
7.4   Determine Fields 
7.5   Group Fields into Tables 
7.6   Normalize the Data 
7.7   Designate Primary and Foreign Keys 
8  Building the Structure of a Database in Microsoft Access 
8.1   Create a New Database 
8.2   Create a Table Using a Wizard 
8.3   Create Tables in Design View 
8.4   Create Relationships between Tables 
9  Controlling Data Entry in Microsoft Access 
9.1   Restrict Data Entry with Field Properties 
9.2   Create an Input Mask 
9.3   Create a Lookup Field 
10    Finding and Joining Data in Microsoft Access 
10.1   Find Data with Filters 
10.2   Create Query Joins 
10.3   Join Unrelated Tables 
10.4   Relate Data Within a Table 
11    Creating Flexible Queries in Microsoft Access 
11.1   Set Select Query Properties 
11.2   Create Parameter Queries 
11.3   Create Action Queries 
11.4   Improving Your Forms 
11.5   Enhance the Appearance of a Form 
11.6   Restrict Data Entry in Forms 
11.7   Add Command Buttons 
11.8   Create a Subform
12    Customizing Your Reports in Microsoft Access 
12.1   Organize Report Information 
12.2   Set Report Control Properties 
12.3   Control Report Pagination 
12.4   Summarize Information 
12.5   Add a Subreport to an Existing Report 
12.6   Create Mailing Labels 
13    Expanding the Reach of Your Data in Microsoft Access 
13.1   Publish Access Data as a Word Document 
13.2   Analyze Access Data in Excel 
13.3   Export Data to a Text File 
13.4   Merge Access Data with a Word Document 
14    Structuring Existing Data in Microsoft Access 
14.1   Import Data 
14.2   Analyze Tables 
14.3   Create a Junction Table 
14.4   Improve Table Structure 
15    Writing Advanced Queries in Microsoft Access 
15.1   Create Unmatched and Duplicates Queries 
15.2   Group and Summarize Records Using the Criteria Field 
15.3   Summarize Data with a Crosstab Query 
15.4   Create a PivotTable and a PivotChart
15.5   Display a Graphical Summary on a Form 
16    Simplifying Tasks with Macros in Microsoft Access 
16.1   Create a Macro 
16.2   Attach a Macro to a Command Button 
16.3   Restrict Records Using a Where Condition 
17    Adding Interaction and Automation with Macros in Microsoft Access 
17.1   Require Data Entry with a Macro 
17.2   Display a Message Box with a Macro 
17.3   Automate Data Entry 
18    Making Forms More Effective in Microsoft Access 
18.1   Change the Display of Data Conditionally 
18.2   Display a Calendar on a Form 
18.3   Organize Information with Tab Pages 
19    Making Reports More Effective in Microsoft Access 
19.1   Cancel Printing of a Blank Report 
19.2   Include a Chart in a Report 
19.3   Arrange Data in Columns 
19.4   Create a Report Snapshot 
19.5   Maintaining an Access Database 
19.6   Link Tables to External Data Sources 
19.7   Back Up a Database 
19.8   Compact and Repair a Database 
19.9   Protect a Database with a Password 
19.10 Determine Object Dependency 
19.11 Document a Database 
19.12 Analyze the Performance of a Database 
 Alfred Morris Authentic Jersey

客户展示 - 涵盖56.4%的世界500强企业


企业Office培训专线: 400 600 1998
咨询QQ 张老师: 

点击这里给我发消息
咨询QQ 李老师: 点

击这里给我发消息

战略合作伙伴

   
   
   
   
   
   
   
   @2004 北京助力东方(INFOCHINA)科技有限公司版权所有 京ICP备06024442全国业务咨询热线:400-600-1998   

十大经典课程 + 十大金牌讲师 + 独创5S教学法 + 一年完美技术服务 = INFOCHINA|中国Office培训专家