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. 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.
Product code: EN-Acc16-CS3