Microsoft Access 2013 – Advanced

Microsoft Access 2013 – Advanced

Become an Access expert

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. 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 who are not just starting out in their learning of a specific skill, but so too those who are looking to build on existing skills and knowledge with a view to using these to progress up the career ladder. This is why we’ve 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’ll 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 best 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.

* Free E-certificate (No additional cost for E-certificates)

Why You Should Choose Global Edulink

• 12 months Access to your course.
• The price shown on Reed is for the whole course, including the final exam and free e-certificate.
• CPD and iAP accredited certificate upon successful completion
• Tutor Support available Monday – Friday

Course Curriculum : Microsoft Access 2013 – Advanced

[Module 01] Advanced Form Design

• Create Subforms
• Organize Information with Tabs Pages
• Navigation of Forms
• Conditional Formatting

[Module 02] Data Validation

• Field and Record Validation
• Form Validation

[Module 03] User Interface Design

• Create a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro

[Module 04] Data Entry Using A Macro

• Automate Data Entry Using a Macro
• Convert a Macro to VBA

[Module 05] Database Management

• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database

[Module 06] Securing A Database

• Splitting a Database for Multiple User Access
• Implement Security
• Set Passwords

[Module 07] Distributing Database

• Convert an Access Database to an ACCDE File
• Analyze the Performance of a Database

[Module 08] Switchboards

• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup Options

Benefits you will gain:

• High quality e-learning study materials and mock exams.
• Tutorials/materials from the industry leading experts.
• 24/7 Access to the Learning Portal.
• Recognised Accredited Qualification.
• Excellent customer service and administrative support.

Certification:

Successful candidates will be awarded a certificate in Microsoft Access 2013 – Advanced

• 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

• Software Engineer
• Technical Support
• Technical Sales
• Business Analyst
• Web Developer
• Software Tester

Currently there are no Q&As for this course. Be the first to ask a question.