Microsoft Access 2013 - Intermediate
Access Duration - 365 Days
Accredited By "CPD & iAP"
Guided Learning Hours (06)
Course Material
Number of Modules 06
Mock Exam Included
Final Exam Included
5( 1 REVIEWS )
741 STUDENTS
Accredited By
What Will I Learn?
Lean to use the software in a skilful manner
Taught by qualified and experienced trainers in the industry
Learn the intermediate aspect of the ms access software
Ability to learn how to make databases easier to create and use
Learn how to store a set of information, query information, build easy-to-use graphical interfaces and create reports on the stored data
Learn the skills essential to help develop your career in an effective manner
Create, develop and manipulate with Microsoft Access 2013
On this Microsoft Access 2013 intermediate course (USA Standards), provided by Global Edulink, a well-respected provider of online training courses globally, you are skilfully guided through the use of the software by qualified trainers who are specialists in their field. We make it easy for you to understand the intermediate aspects of this application, such as: relational database design, joining tables and querying their joints, efficient organisation of databases, import and export of data to and from Access, useful mail merges, and finally, its advanced reporting tools.
Microsoft Access 2013 is the number one database application in the world and is designed to make databases easier to create and use. It’s used to store a set of information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data.
Many businesses use Microsoft Access, from small one-person outfits to the largest corporations world-wide, because it’s easy to maintain and requires very little infrastructure to support. Understanding Access is vital to real-world database use and, at Global Edulink, our course will furnish you with skills that we believe can certainly progress your career.
Please Note: This Course is Based on USA Standards.
- Who is this course aimed at?
- Entry requirements
- Method of assessment
- Certification
- Progression and career path
- Other Benefits
- Those with technical roles within the IT industry
- Professionals who design and programme system-level software such as database systems, operating systems, and embedded systems
- Project-based technical analysts and engineers
- Technical support personnel
- This course is available to all students, of all academic backgrounds. However, basic IT skills would be an advantage.
- Learners should be ages 16 or over to undertake the qualification.
- Good understanding of English language, numeracy and ICT are required to attend this course.
At the end of the course, learners will also take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Successful candidates will be awarded certificates for Certificate in Microsoft Access 2013 Intermediate Training.
With this certificate in your CV, you are sure to wave you way thorough to a rewarding job within the IT industry. This course can also pave way for your career progression by helping you obtain the salary increment, job promotion or other job opportunities put forth by your organisation. Following are some of the jobs you can get ahold of with this course, along with the average UK salary per annum according to https://www.payscale.com/career-path-planner,
- Software Engineer – £34,981 per annum
- Technical Support Engineer – £23,993 per annum
- Technical Sales Manager – £35,939 per annum
- Business Analyst, IT – £35,800 per annum
- Web Developer – £24,886 per annum
- Software Tester – £24,559 per annum
- High quality e-learning study materials and mock exams.
- Tutorials/materials from the industry leading experts.
- 24/7 Access to the Learning Portal.
- Benefit of applying TOTUMÂ Discount Card.
- Recognised Accredited Qualification.
- Excellent customer service and administrative support.
Course Curriculum
| 1. Relational Database | |||
| Relational Database Design | 00:12:00 | ||
| Create a Table – Access | 00:05:00 | ||
| Create Table Relationships | 00:09:00 | ||
| 2. Joining Tables | |||
| Create Query Joins | 00:10:00 | ||
| Join Tables That Have No Common Fields | 00:03:00 | ||
| Relate Data within a Table | 00:05:00 | ||
| Work with Subdatasheets | 00:04:00 | ||
| Create Subqueries | 00:05:00 | ||
| 3. Organizing a Database for Efficiency | |||
| Data Normalization | 00:13:00 | ||
| Create a Junction Table | 00:06:00 | ||
| Improve Table Structure | 00:03:00 | ||
| 4. Import and Export the Data | |||
| Import Data into Access | 00:11:00 | ||
| Export Data to Text File Formats | 00:06:00 | ||
| Export Access Data to Excel | 00:03:00 | ||
| 5. Mail Merge | |||
| Create a Mail Merge | 00:10:00 | ||
| 6. Advanced Reporting | |||
| Organize Report Information | 00:18:00 | ||
| Format Reports | 00:17:00 | ||
| Control Formatting in a Report | 00:03:00 | ||
| Add a Calculated Field to a Report | 00:05:00 | ||
| Subreport to an Existing Report | 00:03:00 | ||
| Mock Exam | |||
| Mock Exam: Microsoft Access 2013 – Intermediate | 00:20:00 | ||
| Final Exam | |||
| Exam : Microsoft Access 2013 – Intermediate | 00:35:00 | ||
| Certificate Download Guide | |||
| Certificate Download Guide | 00:03:00 | ||
Andilina adole
Very well designed, throughout course with attention to detail. If you used excel before, as you’ll be familiar with the usage of access. Worth the money, give confidence in using access.