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
“My experience with Learnit Training is very positive. Good communication, clear arrangements. The content and delivery of the course were perfectly in order.”
“A course where time is taken to actually learn something.”
“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!”
“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.”
“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.”
"Following the Access 2007 Basics course, I would like to tell anyone interested to sign up with Learnit straight away if you want to learn Access, Excel or PowerPoint properly. The material is explained well in the book and the trainer answers any questions immediately."
"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."
“An excellent way to get to know Access.”
“In two days you really do gain a solid basic knowledge of Access in a very practically oriented course. What is more, it makes you keen to get started with it!”
"No"
“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.”
“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.”
“Clear course material that you can work through at your own pace.”
“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.”
"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."
“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.”
“A very good course that fits perfectly with the practical requirements of developing and maintaining a database in Access.”
“Very clear course material and trainer; an instructive course and experience!”
"I am satisfied with the course I attended and will certainly recommend Learnit to others, or take other courses myself in the future. Because you can take the course material home with you, I have a good foundation and reference for what I have learned."
"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!"
"Following the Access 2007 Basics course, I would like to tell anyone interested to sign up with Learnit straight away if you want to learn Access, Excel or PowerPoint properly. The material is explained well in the book and the trainer answers any questions immediately."
“A course where time is taken to actually learn something.”
"A good way to improve your software skills independently."
"The course caters for all kinds of levels, from beginners to advanced users. The trainer responds to that very well and you feel at home in the group straight away, despite the differences in level. I can genuinely recommend the course."
“Excellent course, learned a lot. The exercises are very good. Many of these things can be used for your own applications.”
"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."
"I am satisfied with the course I attended and will certainly recommend Learnit to others, or take other courses myself in the future. Because you can take the course material home with you, I have a good foundation and reference for what I have learned."
“Completely lived up to expectations.”
"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 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 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.”
“Definitely take this course. Individual guidance works really well. Highly recommended.”
“In two days you really do gain a solid basic knowledge of Access in a very practically oriented course. What is more, it makes you keen to get started with it!”
“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.”
"The course caters for all kinds of levels, from beginners to advanced users. The trainer responds to that very well and you feel at home in the group straight away, despite the differences in level. I can genuinely recommend the course."
“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.”
“A pleasant introduction to SQL under the guidance of a knowledgeable and driven trainer.”
“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.”
“To the point training, with your own learning objectives taking centre stage.”
“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.”
“The Access basics course is a very useful course if you are unfamiliar with the program. It starts from first principles, and even if you have little experience with computers at all it is still perfectly manageable. The coursebook describes step by step and in great detail how to work with the program.”
"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 Access Basics course ties in very well with practice. It contains some very useful things. The course material matches the learning objectives perfectly and you can easily work at your own pace. I would certainly take another course with Learnit.”
"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."
“Very clear course material and trainer; an instructive course and experience!”
“To the point training, with your own learning objectives taking centre stage.”
“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!”
“A very good training course for learning and working with Access 2003 Basics.”
"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."
"Very good course. It certainly helps you expand your skills."