Microsoft Access Course Bundle

Overview:

This excellent Microsoft Access Bundle has been created so you can become an expert user of Microsoft Access, the most widely used database management system. This Microsoft Access Bundle is taught by instructors who have years of experience and heaps of insider tips and tricks to share with you. This Microsoft Access Bundle consists of the following courses: Access 2010: Essentials, and Access 2010 – Advanced. During this Microsoft Access Bundle you will study: how to build a database from the ground up, the basics of design, how to use PivotTables, create relationships, charts, switchboards and macros.

Our courses couldn’t be more convenient, the course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

What skills will I learn?

• Take your working knowledge of tables, queries, reports and forms to expert level
• Gain a thorough understanding of making tables, queries, forms and reports
• You’ll not only be able to enter data and open reports in Access, you’ll be able to design and structure them so they meet the needs of both you and your data, right from your desktop
• Learn to export and import data, use smart tags, link tables from other Access databases, and much more

Included Courses:

• Access 2010: Essentials
• Access 2010 – Advanced

What are the requirements?

• You must be 16 or over
• You should have a basic understanding of English, Maths and ICT
• You will need a computer or tablet with internet connection (or access to one)

How will I be assessed?

• You will have 2 assignments. Pass mark is 65%.
• You will only need to pay £19 x 2 for assessments.
• You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

Certification:

Successful candidates will be awarded Access 2010: Essentials and Access 2010 Advanced certificates. Anyone eligible for certification will receive free e-certificates, and printed certificates.

Career Path:

This excellent Access 2010: Essentials and Access 2010 Advanced course will qualify you to be a Database Developer. The average salary of a Database Developer in the UK is £30,183, and this will go up with experience (payscale.com). With this course you could fulfil any of the following roles:

• Business analyst
• Database developer
• Data analyst
• Reporting analyst
• Access database specialist

COURSE CURRICULUM

-------- ACCESS 2010: ESSENTIALS --------

1: GETTING TO KNOW ACCESS 2010

-------- ACCESS 2010 – ADVANCED --------

1: RELATIONSHIPS & REFERENTIAL INTEGRITY

2: TABLES & FIELDS

3: QUERIES

4: FORMS

5: REPORTS

6: CHARTS, PIVOTTABLES, AND PIVOTCHARTS

7: SWITCHBOARDS

8: MACROS

9: EXPORTING DATA

10: IMPORTING DATA

11: DATABASE TOOLS & MAINTENANCE

12: SMART TAGS, STARTUP, & HELP