What Will I Learn?
Learn the database application which enables you to create and use databases easily
Identify how to store information, query that information, build easy-to-use graphical interfaces, and create reports on the stored data
Learn from qualified trainers who are specialised i the industry
Learn how to easily understand the use of the software
Learn from the fundamentals to the advanced skills which area incorporated in the access 2013 package
Learn the skills essential to help advance your career
Learn the skills you need from Microsoft Access experts
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. 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.
Begin your learning with us today.
| Who is this course aimed at? |
|
| Entry requirements |
|
| Certification | Successful candidates will be awarded a Certificate in Microsoft Access 2013 Beginner to Advanced Training. |
| Progression and career path | This course will not directly qualify you for any specific job position, however, will be of great benefit for your candidature for a range of job positions in the IT industry. This course can also be the answer to your much anticipated career progression as it enhances your eligibility for the job opportunities provided by your organisation. Given below are few of the job positions this course will help you in, along with the average UK salary per annum according to https://www.payscale.com,
|
| Other Benefits |
|
Course Curriculum
| ------------ beginner ------------ | |||
| 1. introduction to access 2013 | |||
| Orientation to Microsoft Access | 00:46:00 | ||
| Simple Access Database | 00:27:00 | ||
| Get Help in Microsoft Access | 00:04:00 | ||
| 2. table data | |||
| Modify Table Data | 00:13:00 | ||
| Sort and Filter Records | 00:06:00 | ||
| Create Lookups | 00:15:00 | ||
| 3. querying a database | |||
| Join Data from Different Tables in a Query | 00:14:00 | ||
| Sort and Filter Data in a Query | 00:19:00 | ||
| Calculations in a Query | 00:10:00 | ||
| 4. advanced queries | |||
| Parameter Queries | 00:11:00 | ||
| Action Queries | 00:08:00 | ||
| Unmatched and Duplicate Queries | 00:05:00 | ||
| Summarize Data | 00:08:00 | ||
| 5. generating reports | |||
| Create a Report | 00:10:00 | ||
| Controls to a Report | 00:08:00 | ||
| 6. enhance the appearance of a report | |||
| Appearance of a Report | 00:05:00 | ||
| Report for Print | 00:03:00 | ||
| 7. the access options dialog box | |||
| The Access Options Dialog Box | 00:05:00 | ||
| ------------ intermediate ------------ | |||
| 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 | ||
| ------------ advanced ------------ | |||
| 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 – Beginner to Advanced | 00:40:00 | ||
| final exam | |||
| Exam: Microsoft Access 2013 – Beginner to Advanced | 00:40:00 | ||
1992 STUDENTS ENROLLED
Accredited Qualification
Unit Summary
Accredited by CPD & iAP
CPD Membership No: 10582
Study independently accredited and recognised CPD courses. Gain your certification today
Buy with Confidence
Build Your CV Here
All students enrolled with Global Edulink are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews.
MORE INFO
All students enrolled with Global Edulink are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews.
MORE INFO
If you need career support Global Edulink is here for you. We provide excellent career support through our Career Support Service.
MORE INFO
TOTUM Card
Every student of Global Edulink is eligible to apply for a TOTUM card powered byNUS Extra, allowing you to enjoy great saving by top brands on the high-street and online.Paypal Credit
Course Reviews
Related Courses
Microsoft Excel 2013 Dashboard Design
Overview Microsoft Excel Dashboard is...- 365 Days
- ACCREDITED BY CPD & iAP
COBIT® 5 Foundation, COBIT® 5 Implementation and COBIT® 5 Assessor Official Exams Package
Overview Get started with this...- 365 Days
- Awarded by 'ISACA'
COBIT® 5 Foundation and COBIT® 5 Assessor Official Exams Package
Overview This exams package has...- 365 Days
- Awarded by 'ISACA'
COBIT® 5 Foundation and COBIT® 5 Implementation Official Exams Package
Overview Here is a wonderful...- 365 Days
- Awarded by 'ISACA'
RESILIA™ Foundation and RESILIA™ Practitioner Official Exams Package
Overview With the growing concern...- 365 Days
- Awarded by 'Axelos'
RESILIA™ Practitioner Official Exam
Overview This exam might interest...- 365 Days
- Awarded by 'Axelos'
RESILIA™ Foundation Official Exam
Overview With the growing concern...- 365 Days
- Awarded by 'Axelos'
COBIT® 5 Foundation Official Exam
Overview Here is a wonderful...- 365 Days
- Awarded by 'ISACA'
COBIT® 5 Implementation Official Exam
Overview Get on board to...- 365 Days
- Awarded by 'ISACA'
COBIT® 5 Assessor Official Exam
Overview This exam in COBIT®...- 365 Days
- Awarded by 'ISACA'
ITIL® 4 Foundation Official Exam
Overview Would you like to...- 365 Days
- Awarded by 'Axelos'
ITIL®Foundation Certification
Overview The ITIL® Foundation Certification...- 365 Days
- Awarded by 'ITIL'
Price Options +
Great Course
The course exceeded my expectations in many regards — especially in the depth of information supplied.