Microsoft Access 2013 Course E-learning Intermediate & Expert

Microsoft certified online Access 2013 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 Access 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

Levels, packages and languages:

• Customized Elearning Course (after Pre-test)
• Beginner
• Advanced
• Expert
• Beginner & Advanced
• Advanced & Expert
• Beginner, Advanced & Expert
• English, Spanish, German, French and Dutch (Netherlands)

Extra:

• Access 2013 Pre-tests
• Access 2013 Post-tests
• Access 2013 Digital Reference
• Access 2013 Course Books
• Access 2013 Quick reference cards
• Access 2013 Microsoft Office Specialist (MOS) Test Exam
• Access 2013 Microsoft Office Specialist (MOS) Exams (Core and Expert)

Volume Discount

When you order a large number of Access 2013 courses at once, we offer a discount. The discount is automatically deducted at the checkout. Please contact us for a customized proposal.

Access 2013 en Level 2: Proficient user Learning intermediate skills for Access 2013
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 2013 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 2013 en Level 3: Advanced user Learning advanced skills for Access 2013
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