Computer Science, asked by Bibliomaniac, 1 year ago

plz answer all these 5 questions...

Attachments:

Answers

Answered by AlwysGonaHelpSome12
8
Heya,
I also did some computer science so I know this one:-
___________________

If you want to create the basic table structure yourself and define all the field names and data types, you can create the table in Design view. To do so, follow these steps: 
Create a new, blank database.In the Database window, click Tables under Objects, and then click New.In the New Table dialog box, double-click Design View.In the <Table Name>: Table dialog box, define each of the fields that you want to include in your table. To do so, follow these steps:

1Click in the Field Name column, and then type a unique name for the field.In the Data Type column, accept the default data type of Text that Access assigns or click in the Data Type column, click the arrow, and then select the data type that you want.In the Description column, type a description of the information that this field will contain. This description is displayed on the status bar when you are adding data to the field, and it is included in the Object Definition of the table. The description is optional.Once you have added some fields, you may need to insert a field between two other fields. To do so, click in the row below where you want to add the new field, and then on the Insert menu, click Rows. This creates a blank row in which you can add a new field.


2To add a field to the end of the table, click in the first blank row.
After you have added all the fields, define a primary key field before saving your table. A primary key is one or more fields whose value or values uniquely identify each record in a table. To define a primary key, follow these steps: 
Select the field or fields that you want to define as the primary key. 

3:-To select one field, click the row selector for the desired field. 

4To select multiple fields, hold down the CTRL key, and then click the row selector for each field.
On the Edit menu, click Primary Key.


5You do not have to define a primary key, but it is usually a good idea. If you do not define a primary key, Microsoft Access asks if you want Access to create one for you when you save the table.


_______Time for 2nd question
2:-      

___________



For a primary key to work well, the field must uniquely identify each row, never contain an empty or null value, and rarely (ideally, never) change. To set the primary key:

Open the database that you want to modify.In the Navigation Pane, right click the table in which you want to set the primary key and, on the shortcut menu, click Design View.Tip: If you don't see the Navigation Pane, press F11 to display it.Select the field or fields that you want to use as the primary key.To select one field, click the row selector for the field you want.To select more than one field to create a composite key, hold down CTRL and then click the row selector for each field.On the Design tab, in the Tools group, click Primary Key.A key indicator is added to the left of the field or fields that you specify as the primary key.______Space limit is over:) bye! could do till 2question only:(
Attachments:
Similar questions