Access Basics + Advanced + Expert e-learning course
In this Access e-learning course you learn how to set up a database, manage tables and records, and create queries, forms and reports. From basics to expert at your own pace.
NRTO quality mark
- A complete Access database at your own pace
- Nine months' access, your schedule
- Practical assignments with every module mln_in_data_v_outConfig = mlnInputConfig{
- Progress visible to you and your manager
- Completing the test and obtaining the certificate
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.
Practical information
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials
- Certificate
- At the end of the course you will receive a certificate of attendance
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.
This course for your team?
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
- Your date and location
- Tailored content
- Multiple groups or an academy are also possible
- More than 25 years' experience
What others say about this course
"A good way to improve your software skills independently."
“Even if you have never worked with Access before, the study books let you get started on your own in a good and enjoyable way.”
"I took the Access Basics course, and after completing the training I am able to extract the reports our organisation needs from our client registration system and present them in a professional way. It's good that the exercises you do during the course are easy to translate to what your own organisation needs."
“An excellent way to get to know Access.”
“I have a very good impression of the course I took with Learnit. The most appealing thing is that you can work through the material at your own pace. So you aren't dependent on fellow participants. If you have any questions, a skilled and very friendly trainer is on hand to answer them.”
"Very useful course. Interesting and clear material that teaches you from the ground up how to build a database. Plenty of practice material and variety. I got through it fairly quickly because it was so clear, and by the end of day two I was already able to create good tables, queries, forms and switchboards."
“The course has a low entry level and is therefore suitable for a wide range of people. Working at your own pace is pleasant and practical application definitely comes up on the second day.”
“Excellent course, learned a lot. The exercises are very good. Many of these things can be used for your own applications.”
"Clear course. The textbooks match the programme perfectly. The material described in the textbooks is more than clear. The exercises are clear and easy to complete with the explanations found in the book. The trainer is at a level where no question goes unanswered. The answers are clear."
"I took the Access beginners course in Heerenveen. Small group, good guidance. The course material is pleasant to work with and well organised. Learned a lot in two days!"
“Learnit provides a good course, delivered in a relaxed and thorough manner. The trainer makes sure you get suitable support for your own practical questions.”
"A good course that is easy to apply in day-to-day use."
"The Access 2010 Basics course is very manageable, even for people with no Access experience. Over 2 days you calmly work your way through Access book part 1; if you have any questions you can ask them and they are explained to you personally. Those who are slightly more advanced work through part 1 more quickly and can go into more depth with part 2 — and here too, if you have questions they are explained to you one to one. An enjoyable and instructive course."
“Clear course material that you can work through at your own pace.”
"No"
“I took the Access Basics course. The trainer is highly knowledgeable and takes all the time needed to help you. Knows how to create a very pleasant atmosphere.”
“I am very positive about Learnit. The course is very clear and the course material goes through the subject matter extensively, step by step. The environment is pleasant and quiet, the group agreeably small and the guidance one-to-one and geared to individual needs. I learned a great deal in two days and now apply it in my work. I warmly recommend Learnit.”
"No"
“To the point training, with your own learning objectives taking centre stage.”
“An easy course to follow thanks to the step-by-step explanations and assignments through practice exercises. If anything is unclear, the trainer can give further explanation, after which you can work through the exercises in the book (2 of them) on your own.”
“Learnit's open learning format works perfectly for me. Everyone can take in the material at their own pace. What's more, several courses can be run at the same time. Our trainer explained things clearly and created a good atmosphere in the group.”
“good course, learned a lot from it”
“I came to Learnit to make my work easier by applying some extra skills. That is certainly going to work out after this instructive and interactive course!”
“The Access Basics course I took through learnit comes with very clear and well-organised course material, and it is further explained and clarified by a very experienced trainer.”
“Good course material, a course book with clear explanations and accompanying assignments/cases. After the course you may take both the course book and the DVD home, so you can always go over the course material again.”
“To the point training, with your own learning objectives taking centre stage.”
“If you really want to learn this, it comes highly recommended. Do take Access for beginners first, so you have a good foundation.”
“Instructive and clear course. Also for people who are less interested in computer programmes. The days flew by.”
“Very clear course material and trainer; an instructive course and experience!”
“Learnit provides a good course, delivered in a relaxed and thorough manner. The trainer makes sure you get suitable support for your own practical questions.”
“A pleasant introduction to SQL under the guidance of a knowledgeable and driven trainer.”
"I took the Access Basics course, and after completing the training I am able to extract the reports our organisation needs from our client registration system and present them in a professional way. It's good that the exercises you do during the course are easy to translate to what your own organisation needs."
"A course you can follow at your own pace. It starts with the basics and slowly guides you towards being able to build a simple database yourself. In my view you do need a solid basic knowledge of Excel. But overall an excellent course that I can recommend to anyone."
“Clear course material that you can work through at your own pace.”
“Access Basics is much more than just learning to understand the layout and buttons; with the basics you can already do a lot with Access, which is enough for me to get started with it.”
“The course material on offer is clear and it is good that you can work at your own pace. The trainer takes a proactive approach and is knowledgeable. Good facilities. Recommended”
“I have a very good impression of the course I took with Learnit. The most appealing thing is that you can work through the material at your own pace. So you aren't dependent on fellow participants. If you have any questions, a skilled and very friendly trainer is on hand to answer them.”
“I am very positive about Learnit. The course is very clear and the course material goes through the subject matter extensively, step by step. The environment is pleasant and quiet, the group agreeably small and the guidance one-to-one and geared to individual needs. I learned a great deal in two days and now apply it in my work. I warmly recommend Learnit.”
"This course and trainer made clear to me what I can do with Access and, above all, what I cannot. Excellent result."
“A pleasant introduction to SQL under the guidance of a knowledgeable and driven trainer.”
“A course where time is taken to actually learn something.”
“The impression I have of Learnit is good; you can work through the material at your own pace and consult the trainer if you have questions.”
“I took the Access Basics course. The trainer is highly knowledgeable and takes all the time needed to help you. Knows how to create a very pleasant atmosphere.”
"For me, the biggest plus was that the course material is very clear. This means you can follow the course at your own pace, without the stress of wondering what they actually mean. I was very pleasantly surprised. I should say, though, that I already had some knowledge of Access."
“Excellent course, learned a lot. The exercises are very good. Many of these things can be used for your own applications.”
“Great to work through the material and all kinds of exercises independently. The expert trainer is always available if you have questions!”
“My experience with Learnit Training is very positive. Good communication, clear arrangements. The content and delivery of the course were perfectly in order.”
"Pleasant course material, nice to be able to work at your own pace and a trainer who is on hand to help you. A good way to take in the material. You work in small groups."
"A good way to improve your software skills independently."
“The course has a low entry level and is therefore suitable for a wide range of people. Working at your own pace is pleasant and practical application definitely comes up on the second day.”