Microsoft Access is a program designed for creating and managing relational databases. In three courses dedicated to this program, you will learn step by step to create such databases and to process their data. Within the first lessons, you will get acquainted with the program environment and the used terminology.
Access 2013 Online Course
You will learn to design tables, set the properties of their fields and try the entry of data to them. You will link the individual tables with each other via relations and will set the relation properties. You will also learn how to structure the entire database to be able to use it efficiently. Then you will learn to select specific data from the created tables via queries, in combination with calculations to achieve new data. You will also learn to use special action queries. You will examine how to arrange the data from tables and those derived by queries using forms and reports in order to print them or to make the entry of new data easier even to other users. You will learn to create macros that will automate the work in a database and will control whether the entered data comply with the set rules. You will also familiarise yourself with the options of importing and exporting data in databases and saving their individual objects.
MS Access 2013: Introduction – In this initial course, You will familiarise yourself with the terminology concerning relational databases and with the basics of working in the Access program. You will try various ways of creating tables and setting the properties of their fields. You will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them. You will set relations between tables and ensure their referential integrity. You will also familiarise yourself with an easy way of creating simple forms and reports.
MS Access 2013: Intermediate – In this course, you will learn to create calculated fields in queries that operate with functions. You will create totals queries and parameter queries. You will familiarise yourself with the properties of table joins and will examine how they can affect the result of queries. You will create forms in the Design view and will learn to insert calculated fields into them. You will also design and edit reports and will learn to perform various calculations in them. You will also learn how to insert controls into forms and reports, including subforms and subreports.
MS Access 2013: Advanced – Here you will familiarise yourself with action queries. You will examine different types of queries in the SQL view and will get acquainted with the essential clauses of this language. You will learn to create and use macros to automate your work with databases. You will explore importing and exporting of objects and their data. You will examine the printing options of different objects in details and you will familiarise yourself with normalisation of data. You will also examine the options of navigation in a database.