Microsoft Access Advanced - Nationwide

This intensive 1 day, hands-on course Microsoft Access Advanced course helps you gain comprehensive, practical understanding of Access.

In this course you will learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more.

This course is suitable for anybody wanting to learn 2019, 2016, 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.

You can choose either our Classroom training at one of our venues or Live, Instructor-led Virtual training from the comfort of your home.

.

Benefits of Studying Microsoft Access with Infero Training:

• CPD Accredited Classroom training in Small Groups for Max Focus
• Only Microsoft Approved Courseware and Exercise Files are used
• Free Assessment of Skills prior to booking
• Certificate of Completion & Complementary 12 Months Post Course Support
• Premier Locations, Latest Tech, Refreshments, OR We Come to You
• 100% Money Back Guarantee & Price Match Guarantee
• Bespoke Courses & Group Discounts from £89 per person

.

Certification

This Microsoft Access course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Course Content

Lesson 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms

Topic B: Enhance Navigation and Organisation of Forms

Topic C: Apply Conditional Formatting

Lesson 2: Sharing Data Across Applications

Topic A: Import Data into Access

Topic B: Export Access Data

Topic C: Link Tables to External Data Sources

Topic D: Create a Mail Merge

Lesson 3: Using Macros to Improve User Interface Design

Topic A: Create a Macro

Topic B: Restrict Records by Using a Condition

Topic C: Validate Data by Using a Macro

Topic D: Automate Data Entry by Using a Macro

Lesson 4: Using VBA

Topic A: Getting Started with VBA

Topic B: Enhance Access by Using VBA

Lesson 5: Using Advanced Database Management

Topic A: Manage a Database

Topic B: Determine Object Dependency

Topic C: Document a Database

Lesson 6: Distributing and Securing a Database

Topic A: Splitting a Database for Multiple-User Access

Topic B: Implement Security

Topic C: Convert an Access Database to an ACCDE File

Topic D: Package a Database with a Digital Signature

Lesson 7: Managing Switchboards

Topic A: Create a Database Switchboard

Topic B: Modify a Database Switchboard

Topic C: Set Start-up Options

.

Course Objectives

Upon successful completion of this Microsoft Access course, students will be able to:

• Customise a form layout to improve usability and efficiency of data entry.
• Share data across applications.
• Use macros to improve user interface design.
• Use VBA to enhance tasks.
• Organise data into appropriate tables to ensure data dependency and minimise redundancy.
• Lock down and prepare a database for distribution to multiple users.
• Create and modify a database switchboard and set the start-up options.

.

Testimonials

I chose Infero training due to a recommendation from a colleague. The course booking process was easy and straight forward. I chose to do an MS Access course which was on a 1-2-1 basis with the trainer.

The 1-2-1 method of training suited me as this meant the course ran at a speed that I was comfortable with. Upon returning to work, I had used my newly gained skills to create databases for the logging of our equipment, this wouldn't have be possible without the training at Infero.

The whole experience of using and attending Infero Training has meant that I have placed two of my staff on MS Office courses and I plan to send more staff MS Office training in 2014.

Mark Meade (Divisional Service Manager) from Vaillant Group

.

Having had no previous training on Microsoft office, I personally felt the need to enhance my (basic) skills and knowledge by enrolling on a course that would cater for my specific needs so that I could utilise these systems more effectively in the workplace.

The course offerings were perfect, as I was able to choose which level I felt I needed to attend (i.e. beginner, intermediate, advanced etc). Suada offered some very useful advice in deciding which course was most appropriate for me having established what level I was currently working to.

Due to the sessions being on a 1-2-1 basis with just myself and the trainer Huseyn, the course was run at my pace, which was ideal as I did not feel there was any rush to cover the agenda in the allotted time. The workbooks were/are excellent as they explained every step clearly, which was complimented by the trainers contribution. The powerpoint slides also clearly illustrated the discussion points we were covering which aided me whilst completing the exercises.

I found Huseyn to be very friendly, approachable and supportive on all three occasions I spent with him.

Although I have not yet had much of an opportunity in utilising my new skills and knowledge on the systems, they will come in very handy when we will finally be upgraded to Microsoft Office 2007 later in the year.

I thoroughly enjoyed the courses and would certainly recommend Infero should the need arise in the future.

Darren Carlin (Operations Training Officer) from TNT UK

Students taking this Microsoft Access course are database administrators or prospective database administrators who have experience working with Access and need to learn advanced skills.

This course is also for students who seek the Microsoft Office Specialist (MOS) certification.

To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. The following courses or equivalent knowledge is also recommended:

• Microsoft Access Introduction
• Microsoft Access Intermediate

Being proficient in Microsoft Access can open the door to many career opportunities such as:

• Database Developer
• Data Analyst
• Business Analyst

Certificate of completion

Digital certificate - Included