Microsoft Access 2010 Course E-learning Intermediate & Expert

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 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

Database creation and protection 
How to create, convert and protect databases.

Creating a database 
Converting a database 
Protecting a database

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
Selecting the records to print in a report

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 muc 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

----------------------------------------------------------------------------------------------------------------------------

Access 2010 en Level 3: Advanced user Learning advanced skills for Access 2010
Estimated time: 06:04
6 modules - 52 topics

Tables: all about the design
If you have a database to create, pay particular attention to the design of your tables: the efficient management o depends on it.
 
Datasheet view 
Restructuring a table in 
Design view 
Restricting what can be entered in a field Input masks
Lookup lists 
Indexing a table
Relationships between tables

Forms for entering data
You have a well-designed table and a lot of data to put in it. You will find it easier to enter the data via a form - a are less likely if the typing job is comfortable.

Form properties
Preventing access to form fields
Changing the order of access to fields 
Subforms
Using a form to enter data in several tables at once 
Collecting and sharing data

Controls: positioning, organising
Think of controls as containers for your data. If you are creating a form, position them to simplify typing.

If you ar report, position them to simplify reading.
Creating a text box to represent a field Selecting and deleting controls 
Creating a check box/button
Creating an option group
Creating a label
Creating a calculated control
Calculating statistics in forms and reports 
Creating a set list of values
Creating a list of values from an existing table/query

Controls: getting the presentation right
Some simple techniques for the presentation of controls, to ensure that your forms and reports are attractive and understand.

Moving and copying controls 
Aligning and spacing controls 
Changing the height of a section 
Creating a rectangle/line control 
Resizing controls
Formatting text in a control 
Aligning text in a control 
Formatting controls 
Conditional formatting
Copying a format from one control to another 
Grouping/ungrouping controls
Numbering pages in a report or form 
Inserting a picture
Themes

Reports for communicating data
The better your reports look, the more impact your data will have.

Sorting information in a report 
Grouping records in a report
Printing groups on separate pages of a report 
Mailing labels

Find out more
Calculations, statistics, all sorts of queries… get to know some of Access' less known functions.

Calculated fields in a query 
Statistics without grouping 
Statistics on groups
Statistics on groups of pre-selected records 
Parameter queries
Find Unmatched query 
Find Duplicates query 
Crosstab query 
Creating a pivot table
Grouping records in a pivot table 
Adding a totals field to a pivot table 
Pivot charts