Understanding an Access Course - What Do You Learn and What Can You Do With It?
With more and more companies having CRM (customer relationship management) or CMS (customer management system) programs, Access is no longer a very popular program. However, there are always exceptions and if you have to ever create a database in an organisation that doesnâEUR(TM)t have its own CMS or CRM system, you may find it useful to undertake an Access course. Because of the lack of popularity, most training providers now only offer the level 2 course.
Course Overview
During a level 2 training course, you will learn how to manage a database, teaching you to create a table, design a form, run a report, build a query and so on. Your knowledge of what a rational database is will increase, allowing you to create more advanced queries. By the end of the course, you should also be able to share data through various applications, customise your reports and structure the data that you have.
Who Is the Course for?
The level 2 course essentially teaches intermediate skills. It is for those who have to deal with keeping data integrity intact, handling complicated forms, queries and reports and who have to be able to share data with others in different applications.
Course Prerequisites
Participants need to be able to already know what a database object is and how a simple database can be constructed. They have to have an understanding of tables and the relationships between these tables, as well as knowing how to deal with data inside a table. Furthermore, they have to be able to deal with the data inside a table and know how to create queries. Query records have to be created by using expressions and people have to know how to create a report and change a form. Besides this, course participants need to have a basic understanding of both Word and Excel, and they need to know how Notepad works.
What the Course Will Teach You
Upon completion, students will know how to join tables, thereby retrieving data from tables that have no relations. They should also be able to create and use a relational database, as well as being able to streamline data entry, keeping the integrity of the data intact at all times. They will know how to share data through various other applications (mainly Word, Excel and Notepad) and they will be able to create fully customised reports, with the data displayed how they want it to be.
Course Overview
During a level 2 training course, you will learn how to manage a database, teaching you to create a table, design a form, run a report, build a query and so on. Your knowledge of what a rational database is will increase, allowing you to create more advanced queries. By the end of the course, you should also be able to share data through various applications, customise your reports and structure the data that you have.
Who Is the Course for?
The level 2 course essentially teaches intermediate skills. It is for those who have to deal with keeping data integrity intact, handling complicated forms, queries and reports and who have to be able to share data with others in different applications.
Course Prerequisites
Participants need to be able to already know what a database object is and how a simple database can be constructed. They have to have an understanding of tables and the relationships between these tables, as well as knowing how to deal with data inside a table. Furthermore, they have to be able to deal with the data inside a table and know how to create queries. Query records have to be created by using expressions and people have to know how to create a report and change a form. Besides this, course participants need to have a basic understanding of both Word and Excel, and they need to know how Notepad works.
What the Course Will Teach You
Upon completion, students will know how to join tables, thereby retrieving data from tables that have no relations. They should also be able to create and use a relational database, as well as being able to streamline data entry, keeping the integrity of the data intact at all times. They will know how to share data through various other applications (mainly Word, Excel and Notepad) and they will be able to create fully customised reports, with the data displayed how they want it to be.
Source...