In Microsoft Access, tables are the primary objects used to store data in a structured format, organized in rows and columns. Each table represents a specific entity, such as customers or orders, and can have relationships with other tables. Forms, on the other hand, are user-friendly interfaces that allow users to enter, edit, and view data from the tables. They serve as a means to interact with the underlying data in a more intuitive way.
Records are stored in tables.
The most important element in Microsoft Access is your tables, which is where your data is stored. Everything else works directly, or in some cases indirectly, from your tables. Things like forms, queries and reports, amongst other things, are based on your tables. You could have forms or reports or queries based on other queries, but even they will initially get their data from your tables. So without tables to hold data, you can't have a database.
A database contains forms and reports stored in tables
All the information in a database is stored in tables. Forms and reports display the data in a more user friendly way. Queries are used to manipulate the data held in tables.
Microsoft Access
Tables,forms,queries,reports
In Microsoft Access, all data is stored in tables, which are organized into rows and columns. Each row represents a record, while each column represents a specific attribute or field of the data. Tables can be related to each other through relationships, allowing for more complex data management and retrieval. Additionally, Access provides forms, queries, and reports to facilitate data entry, analysis, and presentation.
A table is really just one part of a database. The database consists of other things like the queries and reports. In general we do specifically think of the tables as being the database as that is where the data is stored and tables are central to everything else. As there can be multiple tables and other things as part of the system the term database is used to cover them all as one or as what is called a database management system.
with ms access we can create tables, queries, forms, reports, pages, macros and modules which are the objects of ms access.
Tables, Queries, Reports, Forms, Pages, Modules and Macros.
Access Work Area
bilal says MS ACCESS MAIN OBJECTS ARE TABLES HAVE OTHER OBEJECTS FIELDS , ETC QURIES FORMS REPORTS MODULE