How long do you have access to the Access Basics, Advanced and Expert e-learning?

You have nine months' access to the platform from the moment you start the e-learning. Within that period you set your own pace: you can stop along the way and continue later, as your progress is saved. The course consists of 5 modules with lesson videos and exercises. As long as your licence is valid, you can rewatch and retake the material without limit.

Which topics are covered in the Access e-learning course?

The Access e-learning covers five modules: database and objects, records, tables, forms and reports, and queries with data analysis. You learn to set up and secure a database, manage records, create relationships between tables, design forms and reports, and build advanced queries such as parameter queries, update queries and delete queries. This way you master both the basics and the expert functionality of Access.

Do you need prior knowledge for the Access Basics, Advanced and Expert e-learning?

No, for the Access Basics, Advanced and Expert e-learning course you don't need any prior knowledge. The course starts with the basics and builds up step by step to advanced features such as queries, forms and reports. Basic knowledge of Windows is useful. The course is suitable for anyone who wants to learn Access or expand their knowledge, from beginner to advanced user.

Can you follow the Access e-learning course without installing Access on your computer?

Yes, you do not need to install Access. The e-learning course runs entirely in the cloud, so you log in via a website and start straight away with the video lessons and assignments. You can log in at home, at the office or on the move, on any device with an internet connection. The Office suite does not need to be installed on your computer in order to take the course.

Is the Access e-learning course suitable for large groups of employees?

Yes, the Access Basics, Advanced and Expert e-learning course is very suitable for large groups of employees, for example during a migration or a company-wide roll-out. A volume discount is available for larger numbers of participants. Each participant's progress is clearly tracked and can also be viewed by their manager if required. Get in touch to discuss the options and receive a suitable proposal.

Which version of Access is the e-learning suitable for?

The e-learning is suitable for the most recent version of Microsoft Access. You don't need to install Access on your own computer, because the course runs entirely in the cloud. You log in via a website and get immediate access to the lesson videos and exercises. Working from home, the office or another location is therefore no problem.

When should you choose this Access e-learning course and when is a classroom Access course a better option?

This e-learning course suits you if you want to learn flexibly at your own pace and master Access from basics through to expert level. You work independently through video lessons and assignments, whenever it suits you, and have 9 months' access to the platform. A classroom course is more suitable if you expect to have a lot of questions, want to discuss things directly with a trainer or learn better in a group with fixed lesson times. Also choose the e-learning course for large groups of employees, for example during a migration project, because you can train everyone at the same time without timetables. Do you want to practise specifically with your own databases and receive immediate feedback? In that case, a classroom course offers more interaction. For independent learners with discipline and a busy diary, the e-learning course is the practical choice.

How do testing and tracking my progress work in this Access e-learning course?

During the Access Basics, Advanced and Expert e-learning course you complete assignments for each module and a test at the end. Your progress is saved automatically in the learning platform, so you can see at any time how far you have got and which parts you have already completed. The test must be completed in one go; the rest of the course can be interrupted and resumed later. If you wish, a manager can follow your progress, which is useful for training programmes in the workplace. Compared with individual YouTube tutorials, you therefore get a structured overview of what you have mastered and what still needs attention. Once you have finished, you can revisit the course for as long as your 9-month licence is valid.

What will I learn in the Access e-learning course that I could not simply pick up from a YouTube tutorial?

A single YouTube video often shows you one action, such as creating a query. This e-learning builds up the material in a structured way across five modules: databases and objects, records, tables, forms and reports, and queries and data analysis. You work from basics to expert level in one continuous learning path, with lesson videos and assignments that let you apply the material straight away. Your progress is tracked and can also be viewed by a manager, which is useful for business use. You also finish with a test, so that you know whether you have mastered the material. You have nine months' access and can repeat sections for as long as the licence runs. That makes it suitable if you want to learn Access properly, rather than simply solve one problem.

Which type of employee is this Access e-learning actually intended for?

The Access Basics, Advanced and Expert e-learning course suits employees who want to set up or manage databases independently in Microsoft Access. Think of administrative staff who want to convert customer data from Excel into a proper relational database, management assistants who generate reports and mailings, and data analysts who want to build queries with criteria, parameters and statistical calculations. The course consists of five modules with instructional videos and assignments, and covers topics such as tables with primary keys, relationships, forms, reports and update or delete queries. You have 9 months' access from the start. For IT specialists looking only for SQL or database administration at server level, this is less suitable. The course is aimed at the end user of Access, from beginner to expert level.

Can I also use the Access e-learning as a reference while I'm working?

Yes, that is one of the practical advantages of this e-learning course. As long as your licence is valid (nine months from the start), you can rewatch modules without limit and revisit specific sections whenever you need them. Are you stuck at work on a parameter query or an update query? Then look up the relevant lesson video and rewatch just that section. That works differently from a classroom course, where afterwards you only have your notes. The module structure (Database and objects, Records, Tables, Forms and reports, Queries and data analysis) makes it easy to find the right topic quickly. Do bear in mind that access lapses after the licence period, so plan your learning within those nine months.

What is the difference between this Access e-learning and a three-day classroom Access course?

A classroom Access course usually takes three days and you work at a fixed pace on exercises together with a trainer and fellow participants. You can ask questions straight away and receive immediate feedback on your solutions. This Access e-learning course works differently. You have nine months' access to the platform and decide your own pace, order and revision moments. You get five modules with lesson videos and exercises, from database structure and tables to queries and reports. There is no live trainer; feedback comes from the automatic assessment and the worked examples in the videos. Choose the classroom option if you need interaction and a fixed rhythm. Choose the e-learning if you want to learn flexibly, have the self-discipline and want to revisit the material at your own pace while you work.

Access Basics + Advanced + Expert e-learning course

Name: Access Basics + Advanced + Expert e-learning
Price: 250.0 EUR
Availability: InStock

In this Access e-learning you work with databases, from the basics to expert level. You learn to set up and manage tables, records, queries, forms and reports. You work at your own pace, with video lessons and exercises that really move you forward.

Description

In this e-learning you get to know Access, Microsoft's database program. You work through five modules with lesson videos and assignments, in which you learn step by step how a database is structured and how to build one yourself.

You start with the basics: opening, creating, converting and securing a database. You then work with records and tables, setting primary keys, indexing and establishing relationships. Next, you build forms and reports, including formatting, labels for mailings and page numbering.

In the final part you delve into queries and data analysis. You create selection, parameter, delete and update queries and apply statistical calculations. In this way you work towards setting up and managing a complete database independently.

You take the course entirely online, at your own pace and at a time that suits you. Once you have started, you have nine months' access to the platform.

Topics

During this e-learning course you work through five modules towards a complete command of Access. Step by step, you learn how to build, fill and analyse a database.

Database and objects: opening, creating, converting and securing a database.
Records: creating, searching, filtering and sorting records and importing data (including from XML).
Tables: creating tables, setting a primary key, indexing and establishing relationships between tables.
Forms and reports: designing forms and reports, labels for mailings, inserting text boxes and images, page numbering and formatting.
Queries and data analysis: select, parameter, delete and update queries, queries with criteria, total fields and statistical calculations.

Every module contains lesson videos and exercises with which you put the material straight into practice.

Result

After this e-learning course you will understand how a database in Access is structured and you will be able to work with it independently. You create and manage tables, records and relationships, and you set primary keys and indexes. You build tailored forms and reports, including labels for mailings, page numbering and formatting. You also put together various types of queries, from select and parameter queries to update and delete queries, and you carry out statistical calculations on your data. This allows you to work more efficiently and get more out of the advanced features of Access.

Target audience

This e-learning course is suitable for anyone who wants to get to know the possibilities of Access or expand their existing knowledge. Whether you have never worked with a database before or already have some basic knowledge: you work through the modules at your own pace.

The course is a good fit for employees who need to manage data, create queries or produce reports and forms in their work. It is also an excellent choice for self-employed professionals and students who want to expand their digital skills.

Teaching method

You take this course entirely online via e-learning. You work through the material in five modules, with lesson videos and exercises so that you can put everything into practice straight away. You learn at your own pace and at a time that suits you.

After starting you have nine months' access to the platform. You can pause along the way and continue later, as your progress is saved automatically. The closing test has to be completed in one go.

Nothing needs to be installed. You log in via a website and work from home, at the office or anywhere else where you can study in peace.

Prior knowledge

You don't need any prior knowledge of Access. Do you occasionally work with Windows and can you handle a mouse and keyboard? Then you can start straight away. We begin with the basics and build up step by step to the more advanced functions.

Comments

None in particular.

In-company

Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.

Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.

Request a quote

Education level:

This training is suitable for all levels.

Exemptions:

Exemptions do not apply to this course.

Preparation time:

No preparation time applies to this course.

Certificate:

At the end of the course, a certificate is issued as proof of participation.

The best training for you

At Learnit you will always find a course that takes you further. From (technical) IT skills to communication or personal leadership. You can also choose the training format that suits you best: a classroom course, a tailor-made course at your own office, an online course or an e-learning. We have the right course and the right format for everyone. Because learning in the way that suits you best delivers the best results.

Moving forward together

Taking a training course at Learnit means learning together. Together with your experienced trainer, together with your course group or together with your colleagues. And whether you take the training at home, at your office or at one of our training locations, we are always available to help you. To share our knowledge with you in a way that is genuinely useful to you. Getting further together through personal attention and understanding each other well; that is what we believe in.

Apply it directly in your work

Learning theory from a book that you can then hardly use in your work? Not at Learnit! Whichever training you take with us, you can put it to use at your workplace straight away. Because of the unique learning objectives you set together with the trainer at the start of the training. Because of the alternation between theory and (interactive) practical assignments. And by bringing the challenges you face in your daily work along to the training.