Answer the following questions.
1. How much space is required to store a table with 5 tuples, each tuple having two Big Ints and one date field?
2. What is the location in the Base interface of the link to create a table using wizard?
3. What are some similarities between a spreadsheet and a database table?
Answers
Answer:
In MS Access a table is named collection of records related to a single entity. Table acts as a place holder for your data it is place where all the data is stored it represents a single entity and stores the attribute of the entity in different fields.
Methods Of Saving A Table In MS Access :
⟹ After you have set all the fields and their properties, it is the time to save your table, To save the table, you can follow any of these commands.
(i) Click on File menu from the keyboard OR
(ii) Press Ctrl+S from the keyboard OR
(iii) Click on the save button on the standard toolbar, when Access displays a dialog box.
(iv) Enter the name of the table in the dialogue box and click OK button.
(v) You will now see the name of the table in the database window, when you press Tables object button.