Answer the following questions
1. Write the steps for creating new blank database in MS Access.
2. Define Primary key. Why do we need Primary key?
3. Name and explain different data types in MS Access?
4. Write the steps for setting field size properties of Text data type.
5. Write the steps for saving and closing the table in database.
and follow me for many points
Answers
Answer:
- 1.Open the File Menu. Click File in the top-left corner of Access.
- Select a Blank Database. Click New from the left menu. Click Blank desktop database to create a new database.
- Name the Database. Name the database at the prompt, then click Create .
2.primary key is a field in a table which uniquely identifies each row/record in a database table. ... If a table has a primary key defined on any field(s), then you cannot have two records having the same value of that field(s). Note − You would use these concepts while creating database tables.
3.In Access 2013, we now have two data types — short text and long text.
1.Number
2.Date/Time
4.In the Navigation Pane, right-click the table that contains the field that you want to change, and then click Design View. In the table design grid, select the field for which you want to change the field size. In the Field Properties pane, on the General tab, enter the new field size in the Field Size property
5.In the Navigation Pane, right-click the table that contains the field that you want to change, and then click Design View. In the table design grid, select the field for which you want to change the field size. In the Field Properties pane, on the General tab, enter the new field size in the Field Size
Answer:
This is your answer.
Hope it helps.
Please mark it as brainliest.
