A relational database enables you to set up relationships among the tables and then create queries, reports and forms that tie together and display the information in various ways. Tables, forms, queries and reports are database objects . Approved users may all work with the same database. Tables in the database may reside at remote computers. Forms enable you to view and enter data one record at a time, and into more than one table.
Information is obtained from the database using queries .
Queries enable you to manipulate data in a table, e.g. sort and select data from tables, and perform calculations on them. You can import data from an Excel spreadsheet or from Word, or other databases. Reports enable you to format data from your tables so that it is suitable for printing. No matter how carefully you design your database and its objects, you will probably need to fine-tune or even drastically alter it after you have entered the data. No-one said being organised is easy.