A database is any collection of information organised into a group. Microsoft Access is a relational database application. A relational database contains a large amount of data that is split into numerous tables.
As a result, each table is smaller; more manageable; and, it turn, more efficient. These tables can then be joined together to make them related. When tables are related, you can access information from any field in any related table, eliminating the need to add the same information to more than one table. In addition, you can create reports, forms, and queries from data stored in any related table.