- Duration / Course length: Upto 6 Hours Start now
- Accredited by: CPDiAP
- Certificates:
- Course delivery: This course is delivered in video format
Course details
On this Microsoft Access 2013 intermediate course, 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 of work. 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.
COURSE CURRICULUM
Module 1 : Relational Database
- Relational Database Design
- Create a Table – Access
- Create Table Relationships
- Create Query Joins
- Join Tables That Have No Common Fields
- Relate Data within a Table
- Work with Subdatasheets
- Create Subqueries
- Data Normalization
- Create a Junction Table
- Improve Table Structure
- Import Data into Access
- Export Data to Text File Formats
- Export Access Data to Excel
- Create a Mail Merge
- Organize Report Information
- Format Reports
- Control Formatting in a Report
- Add a Calculated Field to a Report
- Subreport to an Existing Report
- 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.
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.
Certification:
Successful candidates will be awarded certificates for Certificate in Microsoft Access 2013 Intermediate ;
Updated on 18 March, 2024
Eligibility / Requirements
- 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.
Job roles this course is suitable for:
Software Engineer , Technical Support Engineer , Technical Sales Manager , Business Analyst , IT , Web Developer , Software TesterAbout Global Edulink
Global Edulink – online education for a skill-hungry workforce
Education is just one aspect of life that can shape who you are and who you want to be as an employee. In a time-poor world, sometimes you need a flexible approach to help you achieve your goals. Online learning with Global Edulink offers just that – professional and vocational training to fit in with your life.
Global Edulink is well-established in the UK, but reaches out to learners all over the world. The company aims to bridge the gaps in a three step process of training, skills, and jobs, where you can learn at your own pace using interactive teaching techniques.
How the courses work
Learn with Global Edulink and you’ll have the opportunity to gain insight and knowledge from tutors that are well qualified and experienced in their industry sector. Your tutor will be your mentor and support during your learning journey.
- Because each course combines practical and theory, you’ll pick up essential knowledge and gain the confidence to put it into practice at the same time.
- High-quality course materials are provided, which you can access at any time during the course, which will help strengthen your knowledge and help you to perform well in the workplace.
- You’ll find a course structure focused around modules, which can have mock and final exams at the end, with pass grades and diplomas awarded on completion. Some courses will lead to professional qualifications assessed and awarded by external bodies such as NCFE, PEARSON, and PEOPLECERT etc.
- Browse through the course guides and you will find details on any skill level or entry requirements, who the course is best suited to and what you can hope to achieve and build on while you learn. Some courses require no prior knowledge or experience, while others are for those already in a specific job or with some experience to build on. The course details also cover the method of assessment and length of course.