Microsoft Access Introduction - Nationwide

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

In this course, you will use Microsoft Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

This course is suitable for anybody wanting to learn 2019, 2016, 2013, 2010 or 2007, as it covers 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: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help and configure options in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Lesson 3: Querying a Database

Topic A: Create Basic Queries

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Using Forms

Topic A: Create Basic Access Forms

Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Topic E: Organise Report Information

Topic F: Format Reports

.

Course Objectives

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

• Navigate within the Microsoft Access application environment, create a simple database, and customise Access configuration options.
• Organise and manage data stored within Access tables.
• Use queries to join, sort, and filter data from different tables.
• Use forms to make it easier to view, access, and input data.
• Create and format custom reports.

.

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

This Microsoft Access course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable in the Windows environment, and be able to use Windows to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.

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