DATABASE MANAGEMENT

1. Dasign View
2. Datashet View
3. Form View
4. Print Preview
5. Layout Preview

To do this

1. Open the database file Exclusive
2. With the database file open, go to the "File" tab and click on "Info."
3. Click on the "Encrypt with Password" option.
4. Enter a password in the "Password" field and click on "OK."
5. Confirm the password and click on "OK" again.
6. Click on save on the quick access toolbar to save changes

The three layouts of a report in MS Access are:

1. Columnar Layout: This layout displays the report data in a columnar format, with each record appearing as a separate column.
2. Tabular Layout: This layout presents the report data in a table-like format, with records arranged in rows and fields in columns.
3. Justified Layout: This layout aligns the fields within a record vertically, providing a compact and organized view of the data.

1. TData Retrieval:You can use SQL to query the database and retrieve specific records based on criteria.
   For example:
   SELECT * FROM Customers WHERE Country='USA';
2. Data Manipulation:SQL allows you to insert, update, and delete data in the database.
   For example:
   INSERT INTO Orders (OrderDate, CustomerID)
   VALUES ('2023-06-22', 123);
   UPDATE Products SET Price=10.99 WHERE ProductID=456;
   DELETE FROM Customers WHERE CustomerID=789;
3. Data Definition: SQL can be used to create and modify database objects such as tables, indexes, and views.
   For example:
   CREATE TABLE Employees (EmployeeID INT, FirstName TEXT, LastName TEXT);
   ALTER TABLE Customers ADD COLUMN Email TEXT;
   DROP TABLE Orders;