Introductory Access course - basic training - course contents
Our basic computing education in Access gives you an introduction to the most important features in Access and database use.
Access training courses to manage and handle databases, manipulate, structure and present data
Microsoft Office Access is one of the most common databases in the world. It is a Microsoft application software used for quick application building, particularly for simplified data entry, data storage and structuring of large amounts of data that need to be accessible by many users at the same time. It it also a tool for changing and presenting the data.An Access training course will help you use more functions and features of Access, to become more effective and efficient, saving time and avoiding unnecessary work.
Through Access tutoring and classes, you will learn reporting, data analysis, and summeries, as well as how to pose questions to the database and creating tables.
As an add-on, you can also learn to automate your work using Visual Basic for Application (VBA) macros and SQL programming.
Access Course I: Introductory fundamentals in Access
During our basic training courses in Microsoft Access, you will get an introduction to the most important features of Access development and use.
We practice the following introductory and fundamental features and functions:
- The Access environment
- Common and important database terminology
- Fundamental theory for databases and relational databases
- Basic database modelling
- Creation and updating of database table definitions
- Data types and field properties
- Creating relations between database tables
- Import of data from other data sources
- Filtering stored data
- Posing questions to databases (SQL SELECT statement)
- Using SELECT questions and calculated fields
- Parameterized questions
- Groupings
- Summations
- Building and editing user forms
- Form tools and the field list
- Creating and editing reports and views
We give full support to beginners and provide concise explanations as well as any necessary repetition of basic and fundamental features and functions in Access.
We can also aid you in finding answers to specific questions, explore areas of particular interest and delve into Excel-related problems.
