Microsoft Access
Microsoft Access provides the creation and management of databases at a much higher level than what enables eg. Excel. One of the advantages is the unlimited amount of records in the tables. Use the queries obtained from the tables the information we need, and allow them aggregate results. Thanks to the forms you can create your own user interface so users have easier access to data. To print the data we use reports. Why buy expensive programs, when you can have all the records in Access? Let ITLektor show you the mysteries of this powerful application.
Many tips and tricks, which I met in practice, giving to readers free of charge in my useful videos. See with your own eyes how to deal with situations that are perhaps your daily basis. To view a list of all video tutorials just go to the video category.
Nemáte čas chodit na drahá školení? Stejnou osnovu jako běžná školení mají i online kurzy (E-learning) v podobě video lekcí s podrobným návodem, cvičnými soubory ke stažení, certifikátem a doživotním přístupem. Podívejte se na Online kurzy Accessu.
If you find that you are missing some knowledge, there is no easier way than to be trained. If you choose the path of “self-learning”, some procedures you will learn can take more time or perhaps not quite correct. You can always use the articles on this site for inspiration or consult the ITLektor.
Newest Access posts
- (Čeština) Online kurz Access – Tvoříme databázi
Sorry, this entry is only available in Czech.
- Setting new report
Access Reports are designed for printouts. The proposed structure of the graphical elements is filled with data from tables or queries, and printed on paper like Word documents. The difference between the reports and forms is mainly in the fact that ... - Setting new form
Forms of Access serve as a user interface, which allows us to easily inspect the data, modify it, add entries etc. Additionally, it can include graphic objects – pictures, charts, controls, and even conditional formatting. When properly adjusted, related forms in Access ... - Setting new query
To get information from tables are designed Queries. This object in Access gets the data from tables or other queries like filters in Excel, but at a much more advanced level. Queries can not only filter but also to count, ... - Setting new table
In the created database it is good to start with tables because without them the database does not make sense. In previous article you could read how to set up a new database. Now we look at the creation of tables, ... - Setting new database
Microsoft Access is used to create and manage databases. Generally, it is a higher level of Excel because Access does not have limitations on the number of records in tables, and links between the tables is created more efficiently than ... - Training Access
Training description
On this training, students will learn techniques for practical use of Microsoft Access and control of database objects, including theoretical introduction to the world of databases. A list of topics is provided below. Topics are presented by the trainer, ...