专业微软培训机构,为北京、上海、广州、深圳、长沙、武汉、福州、厦门、泉州、漳州等城市提供EXCEL、PPT、WORD、ACCESS、PROJECT、MCSE、MCITP、OFFICE等高级培训及相关技术服务。

0592-2962798 2963798
2966798 2968798
厦门市厦禾路南洋大厦二楼

最新文章列表

VISIO商务图形设计高级课程

厦门高士达帮助你恢复,修复,重建,访..

【金牌技术服务】数据安全服务

“个人有成长,企业才会有成长”---厦门..

项目管理,我们先行一步 ——实记厦航P..

让工作变得更轻松

热门文章列表

使用OUTLOOK进行时间和任务管理

【课程】Project 2010实战课程

【课程】WORD高级排版与文档处理

【教程】使用 PERT 分析来估计Project..

老板的小问题,人事的大难题--EXCEL快..

【课程】ACCESS数据库开发与设计

【课程】Access 2013 training courses 英文培训大纲

关键字:ACCESS培训,ACCESS开发    发布时间:2015-08-20 17:47:30    作者:admin

Access 2013 training courses

You can use Access to build powerful databases with relatively little effort. Microsoft Access is extremely versatile, and applications can range from linking simple data lists to fully functional accounts and invoicing systems.Are you taking advantage of what Access can offer?

 

With GSD, delegates can check their skill level which ensures they book on the correct course.   This facility is also invaluable when putting together training programmes or bespoke courses for numbers of delegates.

 

We can also tailor your Microsoft Access training to your needs, or to your company project requirements, taking you from first principles to whatever level you want to achieve.

 

Instructor-led / Microsoft qualified trainers

Benefits

This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.

After completing this course you will be prepared to attend the Access 2013 Advanced training course.

 

Who is this course for?

Our 2007 Intermediate Access Training - IT is suitable for those with a basic working knowledge of Microsoft Access.

Prerequisites

A working knowledge of Access is required, or our Access 2013 Introduction course.

Objectives

This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.

After completing this course you will be prepared to attend the Access 2013 Advanced training course.

About Microsoft Access

Access is a Relational Database Management System (or RDBMS for short). As you may know, all databases store information -- but Access is a relational system, in that it links together data stored in separate lists, or tables. As an example, one table could contain a list of customers while another might show orders placed. A connection would be made via an account number or ID appearing in both tables, thus enabling Access to recognise and work with the shared relationship.

Course Syllabus

1. Get familiar with Access

Course

What you''ll learn

Choose between Access and Excel

When to use Access and when to use Excel. This course helps you answer that essential question so you don''t set off in the wrong direction.

Get to know Access 2013

Access basics, how to download and use templates, how to create and use forms and reports.

Up to speed with Access 2013

-or-

Demo: Up to speed with Access 2013

Brief lessons in the Ribbon, Quick Access toolbar, and Microsoft Office Button, plus working with file formats.

Take charge of your database with the Navigation Pane

-or-

Demo: Meet the Navigation Pane

How to use the Navigation Pane, the essential tool for using and managing your databases.

2. Build your first database

Course

What you''ll learn

Design tables for a new Access 2013 database

Step 1 in the process of creating a new database — how to plan the tables that store your data.

Create tables for a new Access 2013 database

Step 2 in the process — how to build the tables and set the data types for the fields in each table.

Build relationships for a new Access 2013 database

Step 3 in the process — how to create the relationships between your tables, and how to put them to work.

Create queries for a new Access 2013 database

Step 4 in the process — how to create the queries that extract data, add calculations, and make it easier to create forms and reports.

Create forms for a new Access 2013 database

Step 5 in the process — how to create forms and put an intuitive "public face" on your database.

Create reports for a new Access 2013 database

The final step — how to create the reports that make it easy for others to understand and use your data.

3. Start managing your data, fast

Course

What you''ll learn

Easy Access with templates I: Create a database

Download and use a ready-made database template. All you''ll need to do is enter the data.

Easy Access with Templates II: Modify a database

Make modifications to the database that you created from a template.

Datasheets I: Create a table by entering data

A quick, easy way to create a simple table, just by entering data.

Datasheets II: Sum, sort, filter, and find your data

How to use a new feature called the Totals row, plus built-in sorting and filtering tools.

Datasheets III: Make data easier to read by formatting columns and rows

How to change the visual look and feel of your table and data.

Import data from Excel to a new table in Access

A fast, accurate way to move data from Excel to Access.

4. Find answers with queries

Course

What you''ll learn

Queries I: Get started with queries

An overview of what queries are, what goes into them, and how to use them.

Queries II: Create basic select queries

How to create basic select queries by using a wizard or a designer.

Queries III: Use expressions and other criteria

How to use selection criteria and expressions — formulas that do more than math — in your queries.

Queries IV: Use functions and calculated fields in your queries

How to use functions to sum, average, or count data, and how to create calculated fields that display the results of an expression.

Queries V: Use "And", "Or", and "In" to set multiple conditions

How to use AND, OR, and IN logic to find records that meet multiple conditions, such as customers who also own their businesses.

Queries VI: Use wildcards in queries and parameters

How to use wildcard characters to find data and match patterns of characters.

Queries VII: Query multiple sources for data

How to query more than one table (or query) for data.

Queries VIII: Dealing with ambiguous joins

How to work around ambiguous outer joins, a problem that sometimes arises when you query multiple tables.

5. Deepen your Access skills

Course

What you''ll learn

Demo: Select the right form view

The differences between the various form views, and when to use each.

Demo: Set the relationship between two tables

The advantages of using a relational structure, the logic behind a many-to-many relationship, and the steps for creating that type of relationship.

Demo: Use the Expression Builder

The basics of using the Expression Builder to create functions.

Demo: Collect data in Access 2013 by using e-mail

How to use collect data for your database by using e-mail messages.

Watch this: Make a query ask for input

Have Access ask for input, then filter the results of a query to match that input.

 

本文关键词:ACCESS培训   ACCESS开发   

厦门高士达是一家微软认证培训机构,是专业的EXCEL培训、PPT培训、ACCESS培训、OFFICE培训、微软培训、微软考试及其他IT服务供应商 ©2014 厦门高士达微软高级技术教育中心   闽ICP备14021819号 技术支持:港湾有巢

闽公网安备 35020302001653号