UNIT-1: Introduction to Microsoft Access

1. What is Microsoft Access?

Microsoft Access is a database management software used to store and manage information in an organised way.

2. What is a Database?

A database is an organised collection of related data.

Example: A school database may contain information about Students, Teachers, Classes, Fees, Attendance, Books, etc.

3. What Makes Up a Database?

A database mainly consists of tables. A table is made up of fields and records.

Database → Table → Record → Field → Data

A. What is this structure called?

Table

B. How many fields are there?

5

C. Name the fields.

ID, Name, Age, Email, City

D. How many records are shown?

3

E. What is the first person's name?

John

F. What is the age of Sarah?

35

4. What is a Table?

A table is a collection of related data arranged in rows and columns.

5. What is a Field?

A field is a column in a table that stores a particular type of information.

6. What is a Record?

A record is a collection of related fields about one particular item or person.

7. What is Data?

Data are individual values that can be stored and processed.