Introduction to Objects
Databases in Access are composed of four objects: tables, queries, forms, and reports. Together, these objects allow you to enter, store, analyze, and compile your data however you want.
In this lesson, you will learn about each of the four objects and come to understand how they interact with each other to create a fully functional relational database.
By this point, you should already understand that a database is a collection of data organized into many connected lists. In Access, all data is stored in tables, which puts tables at the heart of any database.
You might already know that tables are organized into vertical columns and horizontal rows.
In Access, rows and columns are referred to as records and fields. A field is more than just a column; it’s a way of organizing information by the type of data it is. Every piece of information within a field is of the same type. For example, every entry in a field called First Name would be a name, and every entry in the field called Street Address would be an address.
Likewise, a record is more than just a row; it’s a unit of information. Every cell in a given row is part of that row’s record.
Notice how each record spans several fields. Even though the information in each record is organized into fields, it belongs with the other information in that record. See the number at the left of each row? It’s the ID number that identifies each record. The ID number for a record refers to every piece of information contained on that row.
Tables are useful for storing closely related data. Suppose you claim a pastry kitchen and have a database that incorporates a table with your clients’ names and data, similar to their telephone numbers, personal residences, and email addresses.
Since these snippets of data are for the most part points of interest on your clients, you’d incorporate them all in the same table.
Every client would be spoken to by a unique record, and each kind of data about these clients would be put away in its own particular field. On the off chance that you chose to include any more data—say, a client’s birthday—you would basically make another field inside a similar table.
Forms, queries, and reports
Although tables store all of your data, the other three objects—forms, queries, and reports—offer you ways to work with it. Each of these objects interacts with the records stored in your database’s tables.
Forms are utilized for entering, modifying, and viewing records. You likely have needed to round out structures on numerous events, similar to when going by a specialist’s office, applying for a vocation, or enrolling for school. The reason shapes are utilized so frequently is that they’re a simple method to control individuals toward entering information effectively. When you enter data into a shape in Access, the information goes precisely where the database creator needs it to go: in at least one related tables.
Structures make entering information less demanding. Working with broad tables can be confounding, and when you have associated tables you may need to work with more than each one in turn to enter an arrangement of information. Be that as it may, with shapes it’s conceivable to enter information into various tables immediately, across the board put.
Database planners can even set limitations on singular frame segments to guarantee the majority of the required information is entered in the right organization. All things considered, frames help keep information predictable and sorted out, which is basic for a precise and intense database.
Questions are a way of searching for and compiling data from at least one tables. Running a question resembles asking a detailed question of your database. When you construct an inquiry in Access, you are defining particular hunt conditions to find precisely the information you need.
Questions are much greater than the basic hunts you may do inside a table. While a search would have the capacity to enable you to discover the name of one client at your business
you could run a query to discover the name and telephone number of each client who’s made a buy inside the previous week. An all-around planned inquiry can give data you won’t have the capacity to discover just by looking through the information in your tables.