Explain tables in MS Access in details...
Answers
Answer:
1 A relational database like Access usually has several related tables.
2 In a well-designed database, each table stores data about a particular subject, such as employees or products.
3 A table has records (rows) and fields (columns).
4 Fields have different types of data, such as text, numbers, dates, and hyperlinks.
5 Access Tables A table is where data is stored and a table lives within a database. Without a database there can be no table! A table inAccess is quite different then a table in real life. Instead of having wooden legs and being used for meals, Access Tables are a grid made up of rows and columns.
6 For a database object, click Properties on the View menu and enter the description text in the Description box. For tables or queries, you can also enter the description in the table's or query's property sheet.
Explanation:
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.