Access Develop (3 days) -Access高端培训系列

北京最专业的Access高端培训,*的Access专业培训机构, 北京Access Develop (3 days) 课程简介 -------------------------------------------------------------------------------- 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