To create a new database in Microsoft Access, you start by clicking on "Blank Database," enter the database name, and then click "Create." For creating a new table, click the "Create" tab and then click "Table." You can then add fields by clicking the "Click to Add" field heading, choosing a data type, and entering a name for the field .

Queries in relational databases allow users to extract data administered under specific criteria, thus presenting data in a meaningful and actionable manner. Unlike static data storage, queries enable dynamic interaction with the database, allowing users to dissect and analyze data based on current needs or objectives, such as finding turnover statistics for a specific location. This flexibility in data retrieval is crucial for informed decision-making and adaptability to changing business requirements .

Foreign keys in relational databases act as a bridge connecting two tables by referencing the primary key in another table. This relationship enforces data integrity and helps maintain consistent data by ensuring that the foreign key values in one table correspond to valid primary key values in the referenced table. For instance, if you have a 'Student' table and a 'Course Enrollment' table, a foreign key in 'Course Enrollment' referencing the 'Student ID' primary key in 'Student' ensures that every course enrollment entry corresponds to an existing student, preventing orphan records and maintaining relational integrity .

Reports in database systems serve as a tool for summarizing and presenting data in a printable format, allowing for insights and analyses to be shared widely. Reports draw from tables and queries, utilizing the structured data to create layouts that dictate the presentation of information. For example, a report can compile data from sales tables and queries to show monthly sales performance, formatted to highlight key metrics and trends. Thus, reports are instrumental in turning raw data into actionable business intelligence .

Databases offer numerous benefits across sectors by enabling structured data storage and easy retrieval of specific information, thus enhancing efficiency and decision-making. In education, databases track students' progress over time which helps in monitoring performance and areas needing improvement. Retail sectors use databases to manage stock efficiently, preventing overstocking or stockouts. Libraries utilize databases to organize catalogues of books, facilitating easy search and borrowing processes for users. These applications highlight databases' role in improving operation management, data accessibility, and strategic planning in diverse fields .

A primary key is crucial in database management as it uniquely identifies each record within a table, ensuring that there are no duplicate entries for the key field. This uniqueness allows for efficient data retrieval and relationship establishment between tables. For example, in a student database, a student's file number serves as the primary key because it is unique for each student, distinguishing them from others even if other fields such as 'Town' may hold the same data across multiple records .

Hierarchical database models are structured in a parent-child relationship resembling an inverted tree, allowing several child records to be accessed from a single parent. This model is suitable for fixed, predetermined structures. The network model extends this by allowing a child to have multiple parents, offering more flexible linkages, but still within a rigid framework, making it suitable for applications like CD-ROM encyclopedias. The relational database model, however, allows for data to be organized flexibly through tables that can be linked in numerous ways based on queries, thus adapting to varied data organization needs .

To enter data into a table in Microsoft Access, one can use either the datasheet view, where multiple records are visible, or the design view, which allows entry one record at a time. After opening a table, the insertion point appears in the first field where you can type the data. Press the Tab key or click in the next field to continue inputting data. This process facilitates structured data entry and ensures each record is accurately captured within the database .

Hierarchical and network models are inherently rigid due to their structured parent-child relationships, limiting their adaptability to evolving data landscapes typical in modern applications. These models require pre-defined schema, making changes cumbersome and costly as data requirements shift. In contrast, relational models offer flexibility through table relationships and dynamic queries, accommodating complex data interactions and growth. This adaptability is crucial for modern applications that demand real-time data processing and constant updates, something hierarchical and network models struggle with due to their static framework .

Deleting a table, form, or query in Microsoft Access involves selecting the object in the Database window and either pressing the Delete key or right-clicking and selecting Delete. This removes the object permanently from the database. In contrast, saving objects entails clicking ‘File’, then ‘Save As’ and providing a name for saving, which preserves the current state and changes of the object within the database structure. While deletion is irreversible and should be done cautiously to avoid data loss, saving maintains database integrity and allows further modifications .