Question

Q1 What is MS Access ?
Q2 Differentiate between record and field ?
Q3 Defination of Data type​

Answer 1

1. Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. 
2. Fields and records are two basic components of a database, which is an organized collection of information, or data. The term "fields" refers to columns, or vertical categories of data while the term "records" refers to rows, or horizontal groupings of unique field data.
3. a particular kind of data item, as defined by the values it can take, the programming language used, or the operations that can be performed on it.

Answer 2

Answer:

A1. Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

A2. In computer science, data that has several parts, known as a record, can be divided into fields. In object-oriented programming, a field (also called data member or member variable) is a particular piece of data encapsulated within a class or object.

2. A record is a data structure that groups together related items of data. These are slightly more complex than arrays as you can store more than one type of data together. Creating records will vary in different languages. Python uses a data structure called 'dictionaries' that has some features of the record structure.

A3. In computer science and computer programming, a data type or simply type is an attribute of data which tells the compiler or interpreter how the programmer intends to use the data. Most programming languages support basic data types of integer numbers, floating-point numbers, characters and Booleans.