Question

Very short answer type questions, (1)Which option allows you to build a new table by entering data directly into the datasheet?
(2) In how many ways can the records of table be sorted?
(3) What do you do to the two different tables when you have to combine data from those tables?
(4) when sorting a table on a field in which text is stored, how are records arranged in ascending sort?
(5) How can you remove a relationship
defined between two tables? ​

Answer 1

Answer:

1- Create tab

2- [Not sure of the answer] You can sort the recoreds of the table by checking the differences.

3-  Basting them in the first empty cells to the right of the table.

4- Sort data in a table

Select Custom Sort.

Select Add Level.

For Column, select the column you want to Sort by from the drop-down, and then select the second column you Then by want to sort. ...

For Sort On, select Values.

For Order, select an option, like A to Z, Smallest to Largest, or Largest to Smallest.

5 - On the Database Tools tab, in the Relationships group, click Relationships.

On the Design tab, in the Relationships group, click All Relationships.

Click the relationship line for the relationship that you want to delete.

Press the DELETE key.