Question: Which of the following database object is created first before any other created?
A Table
B Form
C Report
D Query
Answer: Table
Order of Database Object | Description | |
1 | Table | · Tables are the foundation of a database.
· They define the structure and schema, specifying the fields and their data types. · Tables store the actual data. |
2 | Query | · Queries are created to extract, manipulate, or filter data from the tables.
· They are used to search for and retrieve specific data based on criteria. · Queries depend on the existing tables. |
3 | Form | · Forms are designed to provide user-friendly interfaces for data entry and retrieval.
· They allow users to interact with and input data into the database. · Forms often rely on the structure defined by tables and queries for data display and input. |
4 | Report | · Reports are typically created last.
· They are used to present data in a formatted, readable, and often printable manner. · Reports depend on tables, queries, and sometimes form for data sources. · Reports are essential for summarizing and presenting data in a structured format for analysis or presentation purposes. |