Question

E. 1. Answer in detail. What is Database Management System? Describe any two advantages of DBM 2. What is the difference between Datasheet view and Design view? 3. Write the steps to create table using Design view. 4. How do you set a primary key in a table? 5. Write the steps to add a new field in the existing table using Datasheet view. 6. How do you add a new field in an existing table using Design view? a​

Answer 1

Answer:

1. Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database.

2. Any two Advantages of Database Management System are as follows :

. Data Integrity. Data integrity means data is consistent and accurate in the database. ...

. Data Security. Data security is a vital concept in a database.

3. how to create a table in Design View :

. Click the Table Design Button. Click Table Design on the Ribbon (from the Create tab).

. The Blank Table. A blank table will appear in Design View. ...

. Enter the Fields. Enter a name for each field down the left column. ...

. Enter the Field Properties. ...

. Set a Primary Key.

4.Add a primary key to a table in Access :

1. In the Navigation Pane, right click a table, and select Design View.

2. Select the field or fields you want to use as the primary key.

3. Select Design > Primary Key.

5. Add a new field :

1. Create or open a table in Datasheet view by right-clicking the table that you want in the Navigation Pane and then clicking Datasheet view from the shortcut menu.

2. In the Add New Field column, enter the name of the field that you want to create. ...

3.Enter data in the new field.

6.To add a field to a form:

1. Select the Form Layout Tools Design tab, then locate the Tools group on the right side of the Ribbon.

2 Click the Add Existing Fields command. The Add Existing Fields command.

3. The Field List pane will appear. Select the field or fields to add to your form. ...

4. The new field will be added.

Hope it helps.