Microsoft Access 2013 - Advanced
Access Duration - 365 Days
Accredited By "CPD & iAP"
Guided Learning Hours (04)
Course Material
Number of Modules 08
Mock Exam Included
Final Exam Included
4( 1 REVIEWS )
892 STUDENTS
Accredited By
What Will I Learn?
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 advanced level skills such as data validation, form design and user interface design
Ability to understand how to secure a database, database distribution and switchboard creation and modification
Creating and manipulating databases on order to suit diverse projects you’re working on
Learn a tool which is easy to maintain and requires little infrastructure
Become a Microsoft Access expert!
Microsoft Access 2013 (USA Standards) is the number one database application in the world and is designed to make databases easier to create and use. It’s essentially used to store a set of information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data. It’s where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services.
As a leading UK training provider, Global Edulink understands the training requirements of professionals, both beginners hoping to learn new skills, and those hoping to build on existing skills. This is why we have created this Microsoft Access 2013 advanced course to meet your specific requirements. Our online training guides you expertly through skills such as advanced form design, data validation and user interface design, to understanding how to secure a database, database distribution and switchboard creation and modification.
On completion of this course, you will understand the advanced features of Microsoft Access 2013 and be capable of not only creating databases but manipulating them to suit tasks or projects you’re working on in the way you see fit.
Many businesses use Microsoft Access, from small one-person organisations to multinational corporations, because it’s easy to maintain and requires very little infrastructure to support. Understanding Access is crucial to real-world database use and our course will provide you with in-depth knowledge of the tools and functions available to you in this software, tools, and skills you can use to help advance 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
- Project-based technical analysts and engineers
- Technical support personnel
- Professionals who design and programme system-level software such as database systems, operating systems, and embedded systems
- This course is available to all learners, 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 Advanced Training.
With this course listed in your CV, you are sure to stand out among the other candidates and get ahold of a desirable job role within the IT industry. This course can also help you attain career growth by building on your knowledge and improving your eligibility for job promotions and salary increments provided by your organisation. Listed as follows are some of the job roles 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. Advanced Form Design | |||
| Create Subforms | 00:03:00 | ||
| Organize Information with Tabs Pages | 00:05:00 | ||
| Navigation of Forms | 00:06:00 | ||
| Conditional Formatting | 00:04:00 | ||
| 2. Data Validation | |||
| Field and Record Validation | 00:20:00 | ||
| Form Validation | 00:07:00 | ||
| 3. User Interface Design | |||
| Create a Macro | 00:07:00 | ||
| Restrict Records Using a Condition | 00:05:00 | ||
| Validate Data Using a Macro | 00:06:00 | ||
| 4. Data Entry Using a Macro | |||
| Automate Data Entry Using a Macro | 00:06:00 | ||
| Convert a Macro to VBA | 00:04:00 | ||
| 5. Database Management | |||
| Link Tables to External Data Sources | 00:04:00 | ||
| Manage a Database | 00:06:00 | ||
| Determine Object Dependency | 00:04:00 | ||
| Document a Database | 00:04:00 | ||
| Analyze the Performance of a Database | 00:03:00 | ||
| 6. Securing a Database | |||
| Splitting a Database for Multiple User Access | 00:05:00 | ||
| Implement Security | 00:08:00 | ||
| Set Passwords | 00:06:00 | ||
| 7. Distributing Database | |||
| Convert an Access Database to an ACCDE File | 00:07:00 | ||
| Analyze the Performance of a Database | 00:03:00 | ||
| 8. Switchboards | |||
| Create a Database Switchboard | 00:06:00 | ||
| Modify a Database Switchboard | 00:03:00 | ||
| Set Startup Options | 00:03:00 | ||
| Mock Exam | |||
| Mock Exam: Microsoft Access 2013 – Advanced | 00:40:00 | ||
| Final Exam | |||
| Exam: Microsoft Access 2013 – Advanced | 00:40:00 | ||
| Certificate Download Guide | |||
| Certificate Download Guide | 00:03:00 | ||
Brittany Lydia
Very informative, would recommend to anyone. I’ll be keeping an eye on new courses coming up in the future. The support staff were very welcoming and made me feel confident.