• Home
• Microsoft Access Tutorial
• Setting All Objects on MS Access Database

 

 

Setting All Objects on MS Access Database

Even you know well of how each the object can be used, but to put it in together can initially be difficult to be understood how all of them work together. However, remember that all of them work in the same data. In every piece of the data such as a form, query, and report usage is stored in one of the database tables. Forms provide you to both adding the data to the tables and viewing the data that has already existed. The report presents the data from tables and also from the queries, then search for and also analyze the data within the same tables. Those relationships seem like complicated, but they work together naturally and so well that you do not often even notice when you are using a connected database object.

 

 

When you are using your search, you are entering the search terms into a form then creating and operating a query based on the request. When the query finished its searching, the tables for records matched your search and you will be shown a report that is contained with information from queries and the related tables. The relevant records will be spread out in across many tables; for example, a table for the list of titles and description, a table that contained with information on the checking of the book, and a table in each branch in the library.

 

You would have to search for just a book in at least three tables; looking for its location and see whether it has been checked in or not. It seems quite difficult to just find out the right book. If you are not careful, you may even ruin something up accidentally by editing or deleting a record. It is easy to know how the objects of databases can make those searches much simpler and manageable. Make sure that you remind this one, the relational database is able to understand the different sets of the data that is related in one to another. In the situations like as it is mentioned before, it is the simple and easy way to understand people who find out that the relational database is so useful. With no a relational database, it should not be a simple task; searching a book may be a complicated to doand it spends much time. Knowing and understanding the use of four Access objects make the complicated task to be more friendly and simple.