However, if the system is to be a multi-user system accessed by many people, then a higher end DBMS system should be used like Microsoft SQL Server. Access consist of a single file which has an .mdb suffix. This makes it an easy to use system but also causes it to bog down with many users. A table is a collection of information about a specific topic. It consists of records which are a grouping of fields.
Queries allow the user to interrogate the database.
A form is used to enter, update or add information to a table or query. It allows a view of one record at a time. While the datasheet view of a table allows the user to view all or a subset of the records. Reports are used to display queries or tables in a formatted user friendly format. Single records or multiple records may be displayed in a format which can be viewed on the screen or printed.