Microsoft Access 2010 Course E-learning Basics & Intermediate

Product type

Microsoft Access 2010 Course E-learning Basics & Intermediate

OEM Office Elearning Menu EN
Logo OEM Office Elearning Menu EN
Provider rating: starstarstarstarstar 10 OEM Office Elearning Menu EN has an average rating of 10 (out of 2 reviews)

Ready to work on your personal development? Book now!

Description

For discounts and graduated prices, visit the OEM Office Elearning Menu website and contact us directly. You will receive the quote within 1 working day.

This online course you will teach you everything Access 2010 has to offer. 
You will learn how to create a database to work with fields and records. You will also learn how to create a query. Furthermore, you will learn about designing tables and data processing. You will also focus on the classification and design of the database and how to format it. This course will also teach you about statistics. 

Microsoft certified online Access 2010 courses (Elearning):

• Certificate of participation when at least 70% of the course is successfully completed.
• 365 days access to Elearning platform to train at your own pace and order. 
• A unique Elearning method in a virtual Microsoft Excel environ…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft Access, Internet Security, E-commerce, Microsoft Office, and Microsoft Office (management).

For discounts and graduated prices, visit the OEM Office Elearning Menu website and contact us directly. You will receive the quote within 1 working day.

This online course you will teach you everything Access 2010 has to offer. 
You will learn how to create a database to work with fields and records. You will also learn how to create a query. Furthermore, you will learn about designing tables and data processing. You will also focus on the classification and design of the database and how to format it. This course will also teach you about statistics. 

Microsoft certified online Access 2010 courses (Elearning):

• Certificate of participation when at least 70% of the course is successfully completed.
• 365 days access to Elearning platform to train at your own pace and order. 
• A unique Elearning method in a virtual Microsoft Excel environment
• Interactive multimedia lessons. (video’s with spoken explanations and subtitles)
• Practical Assignments with real- time analysis of the actions and results.
• 24/7 accessible in an online environment .You can use any computer connected to the Internet. 
• Results and progress reports
• Can be integrated in LMS or ELO platform (AICC, SCORM)
• Exam Preparation : Microsoft Office Specialist ( MOS )
• Exam Preparation : European Computer Driving Licence ( ECDL )
• Elearning course developed by professional teachers with over 27 years of experience
• Published by a Microsoft Certified Gold Partner

Access 2010 en
Level 1: Beginner
Learning basic skills for Access 2010
Estimated time: 01:38
3 modules - 14 topics

Database basics
Find out what Access is and how it works. Discover the objects which make up a database.
You need to know: About your database management system
You need to know: The ribbon and the Quick Access toolbar
Opening a database
Database objects
Total number of topics in the module: 4

Taking care of your records
Without the records, what would the database be for? Learn to enter them, edit them, delete them, sort them and more.
Entering records
Moving around in a datasheet/form
Editing the value in a field
Finding records
Replacing the value in a field
Deleting records
Sorting records
Total number of topics in the module: 7

Making use of the data
Basic printing techniques and examples of simple queries.
Print Preview
Margins and orientation for printing any object
Running a query
Total number of topics in the module: 3

Access 2010 en
Level 2: Proficient user
Learning intermediate skills for Access 2010
Estimated time: 02:55
4 modules - 25 topics

Objects and their datasheets
More about database objects and, in particular, all that you can do in a 2010 datasheet.
Managing objects
Formatting/reorganising a datasheet
Filtering records by the value in a field
Filtering by a range of field values
Inserting a Total row into a datasheet
Total number of topics in the module: 5

Database creation and protection
How to create, convert and protect databases.
Creating a database
Converting a database
Protecting a database
Total number of topics in the module: 3

More about data
Storing data in tables, forms or reports; linking and transferring data… make the most of the possibilities available.
Creating a table
Primary key
Importing data from another application
Exporting data
Creating a form
Object dependencies
Creating a report
Selecting the records to print in a report
Total number of topics in the module: 8

From question to query
Even if your database is a simple one, do not limit yourself to typing in and printing out your data. Access is much more useful than that. Take a look at what you can do with queries.
Creating a Select query
Using the query design grid
Setting a selection criterion in a query
Setting criteria on multiple fields
Setting multiple criteria on the same field
Sorting the records in a query
Delete query
Make Table query
Update query
Total number of topics in the module: 9

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.