MS Access 2007 Intermediate Online Course
Short course
Online
Description
-
Type
Short course
-
Level
Intermediate
-
Methodology
Online
-
Duration
365 Days
The Microsoft Access 2007 Intermediate course will teach learners how to bring together different elements and create a cohesive application. The course is perfect for users with basic knowledge of Access that will help them build on the introduction they’ve already had to the application. It is hands-on training and how to be more interactive with Access and use dialog boxes and more controls. Individuals will also learn how to create macros and how to select proper Event and Control to achieve the most productive outcome. Getting certified in Microsoft Access 2007 Intermediate will give learners the edge on showcasing their skills to potential employees as this is a popular and core skill of Microsoft.
The Microsoft Access 2007 Intermediate course will cover programming tips and how to enhance their database knowledge through macros and effective reports.
The course will help you become an expert in Access 2007 and offer insight into program system-level software. The course will help Individuals become efficient at using Access 2007 for both business and personal use. It is an essential skill that can be applied to any job role. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Access 2007 Intermediate.
Facilities
Location
Start date
Start date
About this course
The course is aimed at individuals who have basic knowledge of Access 2007.
Students looking to expand their skills in Microsoft Office Access 2007.
The course is ideal for individuals working as programmers.
Anyone interested in developing their skills in Microsoft Office Access 2007.
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)
Those who successfully complete the exam will be awarded the certificate in Microsoft Access 2007 Intermediate.
Our online programme is well designed that you feel same as you are in the classroom. This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week in 365 days (12 months). Effective support service, and study materials including step by step guided tutorial videos build your confidence to study well and guide you to secure your qualification.
On receiving your request, one of our stuff members will call you or send you a message by explaining everything about the course you are requesting information including how you can sign up, payment options, exam and enrollment requirements etc.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Access
- Web Programming
- Database
- Database training
- Web
- Programming
- Microsoft Access
- Web Designer
- Web Development
- Programmer
Teachers and trainers (1)
David Nicol
Course Administrator
Course programme
Course Curriculum
➤ Module 01 - Relational Databases
1.0 Topic A: Database Normalization
2.0 Topic B: Relating Tables
3.0 Topic C: Implementing Referential Integrity
➤ Module 02 - Working with Related Tables
1.0 Topic A: Lookup Fields
2.0 Topic B: Modifying Lookup Fields
3.0 Topic C: Subdatasheets
➤ Module 03 - Complex Queries
1.0 Topic A: Joining Tables in Queries
2.0 Topic B: Calculated Fields
3.0 Topic C: Summarizing and Grouping Values
➤ Module 4 - Advanced Form Design
1.0 Topic A: Adding Unbound Controls
2.0 Topic B: Adding Graphics
3.0 Topic C: Adding Calculated Values
4.0 Topic D: Adding Combo Boxes
5.0 Topic E: Creating Advanced Form Types
➤ Module 5 - Reports and Printing
1.0 Topic A: Customized Headers and Footers
2.0 Topic B: Adding Calculated Values
3.0 Topic C: Printing
4.0 Topic D: Labels
➤ Module 6 - Charts
1.0 Topic A: Charts in Forms
2.0 Topic B: Charts in Reports
➤ Module 7 - PivotTables and PivotCharts
1.0 Topic A: PivotTables
2.0 Topic B: Modifying PivotTables
3.0 Topic C: PivotCharts
4.0 Topic D: PivotTable Forms
Learning Outcomes
- Learn how to design an application
- Learn how to use macros
- Understand helpful programming tips
- Learn how to effectively use dialog boxes, sub-forms and controls
- Learn how to create charts and PivotTables
Progression and Career Path
Once you successfully complete Microsoft Access 2007 Intermediate you will be qualified to work in the following positions. The Microsoft Access 2007 Intermediate qualification will also put you in line to demand a higher salary or job promotion.
- Programmer – £44,873 per annum
- Web Developer – £24,833 per annum
- Project Assistant – £20,785 per annum
- Business Executive – £23,667 per annum
- Business Analyst – £35,543 per annum
- Technical Support Analyst – £22,753 per annum
Other Benefits
- Written and designed by the industry’s finest expert instructors with over 15 years of experience
- Repeat and rewind all your lectures and enjoy a personalised learning experience
- Gain access to quality video tutorials
- Unlimited 12 months access from anywhere, anytime
- Excellent Tutor Support Service (Monday to Friday)
- Save time and money on travel
- Learn at your convenience and leisure
- Quizzes, tests mock exams, practice exams to ensure you are 100% ready
- Eligible for a NUS discount card
- Free Career Support Service
- 25% Discount on personal Statement and covering letter writing service
- Free Access to Over 150 courses for 2 days (48 hours)
- Free access to course before you purchase (For selected courses only)
Additional information
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.
Method of Assessment
At the end of the Microsoft Access 2007 Intermediate course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.
Awarding Body
The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.
MS Access 2007 Intermediate Online Course