Online
.jpg "Global Edulink")
.jpg "More about Global Edulink")
- Duration / Course length: Upto 10 Hours Start now
- Accredited by: CPDiAP
- Certificates:
- Course delivery: This course is delivered in video format
Course details
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 essentially used to store a set of information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data.On this course, provided by Global Edulink who offer the world's best online education all in one place, you are taken step-by-step through the software by qualified trainers who are specialists in their field of work. We make it easy for you to understand how to use the software, from the fundamental aspects such as setting up tables, inputting and manipulating table data, and generating reports, through to advanced skills such as carrying out mail merges, entering data using macros, creating and designing forms, and generating queries and reports.
Many businesses use Microsoft Access, from small one-person enterprises to large, multinational corporations, because it’s easy to maintain and requires very little infrastructure to support. Understanding Access is vital to real-world database use and our course will provide you with the skills required to help advance your career.
COURSE CURRICULUM
------------ BEGINNER ------------
1. INTRODUCTION TO ACCESS 2013
- Orientation to Microsoft Access
- Simple Access Database
- Get Help in Microsoft Access
- Modify Table Data
- Sort and Filter Records
- Create Lookups
- Join Data from Different Tables in a Query
- Sort and Filter Data in a Query
- Calculations in a Query
- Parameter Queries
- Action Queries
- Unmatched and Duplicate Queries
- Summarize Data
- Create a Report
- Controls to a Report
- Appearance of a Report
- Report for Print
- The Access Options Dialog Box
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
1. ADVANCED FORM DESIGN
- Create Subforms
- Organize Information with Tabs Pages
- Navigation of Forms
- Conditional Formatting
- Field and Record Validation
- Form Validation
- Create a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
- Convert a Macro to VBA
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
- Splitting a Database for Multiple User Access
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Analyze the Performance of a Database
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options
- 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.
Successful candidates will be awarded a Certificate in Microsoft Access 2013 Beginner to Advanced Training. Updated on 15 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.
273 students have enrolled with Global Edulink through Laimoon
See all Global Edulink courses
.jpg "More about Global Edulink")
