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.
Answers
1.Create a blank database
1. On the File tab, click New, and then click Blank Database.
2. Type a file name in the File Name box. ...
3. Click Create. ...
4. Begin typing to add data, or you can paste data from another source, as described in the section Copy data from another source into an Access table.
2. A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records. ... A primary key's main features are: It must contain a unique value for each row of data. It cannot contain null values.
4. Access opens the table in Datasheet view. Select the field (the column) that you want to change. On the Fields tab, in the Properties group, click the arrow in the drop-down list next to Data Type, and then select a data type. Save your changes.
5. Tables are the foundation of a Microsoft Access database. The ID field has a data type of Auto Number; as a result, Access . After you create a table, you must name and save it.
Answer:
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.
Thanks Follow me