Uttam Lal Rajbanshi

 Click here to download

 which data type is used to store numeric characters or special symbol in MS Access? = Short Text which view is used to modify a table in MS Access? = Design view What Is a Database? Give examples A database is an organized collection of structured information, or data, typically stored electronically in a computer system. eg. of database are: MySQL, SQL Server, MongoDB, Oracle Database, PostgreSQL, Informix, Sybase, etc. What is primary key ? List its  advantages of it. A primary key is a special relational database table column (or combination of columns) designated to uniquely identify each table record. Advantages of primary key: a) Data can not be repeated. It prevents duplicate records from being entered. b) It makes fast access for database to locate records in the table. Fast sorting and searching records. c) It creates the relationship between tables. d) It avoids null value. what is data sorting??  list the advantages of data sorting. Data sorting is any process that involves