design a table for a telephone directory database. Analyze the data required to be stored in this directory and accordingly create fields and records in it . select suitable primary key of the table and give reason for selecting it (in the description section of design view . the table should have at least 4 relevant fields and 5 records in it and give name to table
Answers
Answer:
Create a new table in a new database
Click File > New, and then select Blank desktop database.
In the File Name box, type a file name for the new database.
To browse to a different location and save the database, click the folder icon.
Click Create.
The new database opens, and a new table named Table1 is created and opens in Datasheet view.
Create a new table in an existing database
Click File > Open, and click the database if it is listed under Recent. If not, select one of the browse options to locate the database.
In the Open dialog box, select the database that you want to open, and then click Open.
On the Create tab, in the Tables group, click Table.
A new table is inserted in the database and the table opens in Datasheet view.
Create a new table by importing or linking to external data
Click File > Open.
In the Open dialog box, select and open the database in which you wish to create a new table.
On the External Data tab, in the Import & Link group, click one of the available data sources.
Follow the instructions in the dialog boxes that appear at each step.
Access creates the new table and displays it in the Navigation Pane.
Use a SharePoint site to create a table
You can create a table in your database that imports from or links to a SharePoint list. You can also create a new SharePoint list by using a predefined template. The predefined templates in Access include Contacts, Tasks, Issues, and Events.
Click File > Open.
In the Open dialog box, select the database in which you want to create the new table, and then click Open.
On the Create tab, in the Tables group, click SharePoint Lists.
Do one of the following:
Create a SharePoint list that is based on a template
Click either Contacts, Tasks, Issues, or Events.
In the Create New List dialog box, type the URL for the SharePoint site where you want to create the list.
Enter a name for the new list and its description in the Specify a name for the new list and Description boxes.
To open the linked table after it is created, select the Open the list when finished check box (selected by default).
Create a custom list
Click Custom.
In the Create New List dialog box, type the URL for the SharePoint site where you want to create the list.
Enter a name for the new list and its description in the Specify a name for the new list and Description boxes.
To open the linked table after it is created, select the Open the list when finished check box (selected by default).
Import the data from an existing list
Click Existing SharePoint List.
In the Get External Data dialog box, type the URL for the SharePoint site that contains the data that you want to import.
Click Import the source data into a new table in the current database, and then click Next.
Select the check box next to each SharePoint list that you want to import.
Link to a list
Click Existing SharePoint List.
In the Get External Data - SharePoint Site dialog box, type the URL for the SharePoint site that contains the list to which you want to link.
Click Link to the data source by creating a linked table, and then click Next.
Select the check box next to each SharePoint list to which you want to link.