Question

D. Answer the following:
What is MS Access?
Explain any four features of MS Access.
izato
What is the function of Navigation Pane?
4. What is the role of a Primary key in a database?
5. Explain any two rules for naming field size properties.
What are data types in MS Access? Write the names of any four.​

Answer 1

Answer:

1. Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
2. Microsoft Access forms provide a quick and easy way to modify and insert records into your databases. Microsoft Access has capabilities to answer more complex requests or queries. Access queries provide the capability to combine data from multiple tables and place specific conditions on the data retrieved.
3. The Navigation Pane is the main way you view and access all your database objects and it displays on the left side of the Access window by default.
4. Primary key allows you to create a unique identifier for each row in your table. It is important because it helps you link your table to other tables (relationships) using primary key as links.
5. The name can contain up to 31 characters. It must start with a letter of the alphabet. It may contain any combination of letters, numbers, spaces and underscores.
6. Access: Data Types
7. TEXT. Short Text (formerly Text) is a simple data type. ...
8. NUMBER. For Number, the critical distinction is made in the Field Size property: Byte, Integer, Long Integer, Single, Double, Replication ID, and Decimal. ...
9. DATE/TIME. Date/Time is stored as a number. ...
10. CURRENCY. ...
11. YES/NO. ...
12. OLE OBJECT. ...
13. HYPERLINK. ...
14. ATTACHMENT.

Hope it help you ..