New

Microsoft Access 2010 – Interactive Training Programme (German)

Course Type:

Progress from database novice to Access expert in a matter of days with the Microsoft Access 2010 Online Training course. Specifically designed for people with little or no experience of Access or database design, this course will help them quickly master the techniques and principles of relational database design.


£84.00

Qty:
Seller Name: Atom Training Centre
SKU: EC111827-DE. Category:

Progress from database novice to Access expert in a matter of days with the Microsoft Access 2010 Online Training course. Specifically designed for people with little or no experience of Access or database design, this course will help them quickly master the techniques and principles of relational database design.

Students will be recording and retrieving data in no time at all.

This course is best suited to:

  • Individuals who want to take their data management skills beyond spreadsheets.
  • Employees who need to design and implement business-class desktop database systems.
  • Power-users who need to manage a small database and train others in using Access.
  • Home users who would like to use databases to manage their personal information.

Using a blend of interactive simulations, instructor-led videos and other self-study materials, the Microsoft Access 2010 Online Training course is delivered over the Internet, so that contents can be accessed anyplace anytime, whenever is most convenient for the student.

Students taking the Microsoft Access 2010 Online Training course can use the social networking platform to ask for assistance from other learners or to share their own knowledge and experience. At the end of this course students will have all the knowledge and experience required to build powerful Access 2010 databases from scratch.

Key learning points

The Microsoft Access 2010 Online Training course is divided into three sections, taking students from the most basic concepts of database tables, through to building data collection forms and up to the use of macros and data validation routines. Using a step-by-step approach, each new concept builds upon the last, helping students acquire new skills in a logical way.

The introduction section of the course takes students through:

  • Understanding table creation and design.
  • Finding, editing, sorting and filtering data.
  • Building table relationships and enforcing referential integrity to keep data “clean”.
  • A basic introduction to functions and using the formula creator.

Once the basic concepts have been properly understood, the Intermediate section introduces concepts like:

  • Using aggregate functions and totals to simplify calculations.
  • Building forms using the forms wizard to simplify data collection and display.
  • Using form controls to create a true application interface for the database.

The final, advanced stage of the course focuses on creating reports, data access pages and macros, along with advanced database management techniques.

  • Building reports, and using calculations and graphics to improve the appearance of data.
  • Building macros and assigning actions to form buttons, increasing the functionality of database applications.
  • Importing and exporting data.
  • Using the SQL language to manipulate data in the database directly.

Advantages of this course

The Microsoft Access 2010 Online Training course is the perfect introduction to desktop database design and operation. By completing this course, students will have mastered intermediate and advanced database techniques, so they have the skills and experience required to build genuinely useful applications and reports.

Other benefits of completing this course include:

  • The ability to build relational databases and forms that simplify data capture and display.
  • The skills to generate advanced reports that provide additional insights from the data in the database.
  • Knowledge and experience that can be used to train other employees in using Microsoft Access 2010.

The Microsoft Access 2010 Online Training course is an essential step towards building database systems that fulfil genuine business needs and generate additional, valuable insights from corporate data.

Introduction
In this course, you will become familiar with the basics of using the Microsoft Access program. You will learn how to use and design tables and create various types of queries over them for purposes of an effective information retrieval.

List of Lessons:

  • Introduction to databases
  • The Microsoft Access environment
  • Table creation in datasheet view
  • Table design view
  • Special field types
  • Work within extensive tables
  • Looking up and editing data
  • Data sorting and filtering
  • Designing databases
  • Field selection and data sorting via queries
  • Work with criteria for select queries
  • Calculated items
  • Analysis of table relations
  • Relationships and referential integrity
  • Linked tables in queries
  • Relation features
  • Lookup column
  • Queries with parameters
  • Functions and formula creator
Intermediate
In this course, you will learn advanced techniques of designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.

List of Lessons:

  • Field indexing and data validation
  • Totals
  • Aggregate functions
  • Crosstab query
  • Action queries
  • Data normalization
  • Make Table query
  • Form creation using wizard
  • Working with form
  • Creating forms in design view
  • Working with form controls
  • Calculated form fields
  • Combo Box in forms
  • Option buttons in forms
  • Organising Form fields
  • Creating a Form with a subform
  • Subform insertion in design view
  • Form as a user interface
Advanced
This course focuses on the creation of reports, data access pages and macros. It will also familiarize you with the options for database management, data import and export, as well as with the SQL language.

List of Lessons:

  • Report creation
  • Reports with calculations
  • Graphical editing of Reports
  • Additional report options
  • Pivot table and chart
  • Object dependencies and properties inheritance
  • Macro basics
  • Assigning a macro to a button
  • Data validation using macros
  • Data evaluation via macros
  • Database print and documentation
  • Importing Access Objects and splitting a database
  • Data exporting
  • Program import and export
  • XML format
  • Navigation in a database
  • Security and privacy in databases
  • SQL language

Progress from database novice to Access expert in a matter of days with the Microsoft Access 2010 Online Training course. Specifically designed for people with little or no experience of Access or database design, this course will help them quickly master the techniques and principles of relational database design.

Reviews

There are no reviews yet.

Be the first to review “Microsoft Access 2010 – Interactive Training Programme (German)”

You're reviewing: Microsoft Access 2010 – Interactive Training Programme (German) . How do you rate this product? *

Vendor Information

  • Store Name: Atom Training Centre
  • Vendor: Atom Training Centre
  • Address: The clockhouse, 50 East Street
    Barking
    Essex
    IG11 8EQ
  • No ratings found yet!
New
CCNA & CCNA Security Bundle (Live Labs Included)

Designed for network managers and engineers responsible for implementing network security for small and medium businesses, this course teaches the fundamentals of IP technology implementations, before showing delegates how to boost security.

Learn More

£360.00

Sold by: Atom Training Centre
EC111862
New
MS Powerpoint 2013 Package – Introduction, Intermediate And Advanced

Microsoft Powerpoint is one of the most commonly used presentation programs, used in numerous places of work and study across the world. This good value three course package will take your Powerpoint 2013 skills from total beginner to advanced level, and contains all the information you need to become a proficient Powerpoint user.

Learn More
Sold by: Atom Training Centre
EC113000
New
Office 2010 Basic & Advanced for Dummies

Gain an advanced working knowledge of the Microsoft Office 2010 productivity suite with the Office 2010 Basic & Advanced for Dummies course. Fully approved by the world-famous “For Dummies” group, Office 2010 Basic & Advanced for Dummies course uses simple examples and tips to help students master Word, Excel, PowerPoint and Outlook so that they will be creating docs, manipulating figures, managing mail and creating presentations like a pro.

Learn More
Sold by: Atom Training Centre
EC111655
New
Microsoft Excel 2016

Whether you need to use spreadsheets at home, at work or for both, a good working knowledge of Microsoft Excel 2016 is essential. This great-value online course is designed to get you up-to-speed with very latest developments in the gold standard in spreadsheet applications by guiding you step-by-step from a beginner to an advanced level.

Learn More

£171.60

Sold by: Atom Training Centre
EC112736

Other Products From This Seller

Register