Microsoft Access 2013 - Beginner to Advanced

5( 1 REVIEWS )

1992 STUDENTS

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
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.

Successful candidates will be awarded a Certificate in Microsoft Access 2013 Beginner to Advanced Training.

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/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 NUS extra Discount Card.
Recognised Accredited Qualification.
Excellent customer service and administrative support.

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