Access 2016 Introduction to Databases

       Microsoft Access 2016 Introduction to Databases

        Basic introduction to Access 2016 explained in easy steps

Microsoft Access is a database creation and management program. To comprehend Access, you should first understand databases.

In this lesson, you will find out about databases and how they are utilized. You will acquaint yourself with the contrasts between information administration in Microsoft Access and Microsoft Excel. At long last, you will advance a look beyond at whatever is left of the Access instructional exercise.

Watch the video underneath to take in more about databases in Access.

What is a database?

A database is an accumulation of information that is put away in a PC framework. Databases permit their clients to enter, access, and analyze their information rapidly and effortlessly. They’re such a valuable apparatus, to the point that you see them constantly. Ever paused while a specialist’s assistant entered your own data into a PC, or watched a store representative utilize a PC to see whether a thing was in stock? Assuming this is the case, at that point you’ve seen a database in real life.

The least demanding approach to comprehend a database is to consider it a collection of records. Consider one of the databases we said over: the database of patient data at a specialist’s office. What records are contained in a database like this? To begin with, there’s a rundown of patients’ names. At that point, there’s a rundown of past arrangements, a rundown with medicinal history for every patient, a rundown of contact data, et cetera.

This is valid for all databases, from the least difficult to the most perplexing. For example, on the off chance that you get a kick out of the chance to prepare you may choose to keep a database containing the kinds of treats you know how to make and the companions you give these treats too. This is one of the least complex databases possible. It contains two records: a rundown of your companions, and a rundown of treats.

two lists

Notwithstanding, on the off chance that you were an expert dough puncher, you would have numerous more leans to monitor: a rundown of clients, a rundown of items sold, a rundown of costs, a rundown of requests, et cetera. The more records you include, the more complex the database will be baker’s companions.

 many lists

In Access, records are somewhat more mind-boggling than the ones you compose on paper. Access stores its arrangements of information in tables, which enable you to store significantly more itemized data. In the table underneath, the People list in the novice pastry specialist’s database has been extended to incorporate other important data on the cook’s companions.

table in Access

If you are familiar with other programs in the Microsoft Office suite, this might remind you of Excel, which allows you to organize data in a similar way. In fact, you could build a similar table in Excel.