Chapter -2 Introduction to Access 2019
Fill in the blanks.
1. retrieves
2. flat file
3. tables
4. record
Exercises (Pgs. 46-48)
A. Tick (✓) the correct answers.
1. b
2. a
3. c
4. b
5. c
B. Fill in the blanks.
1. field
2. title bar
3. query
4. Templates
5. Primary Key
C. Write T for True and F For False.
1. F
2. T
3. F
4. T
5. T
A. Answer the following questions in short.
Q.1 What is database ?
Ans:- A database is an organized collection of data that is stored and accessed electronically. It is designed to efficiently store, manage, retrieve, and update information.
Q.2 How does DBMS help us ?
Ans:- A Database Management System(DBMS) helps organise data, making it easier to update, retrieve , and protect , improving efficiency and accuracy.
Q.3 Why do we use MS Access 2019 ?
Ans:- Access 2019 is a popular Relational Database Management System (RDBMS),which organises data in tables and links them to related data .
Q.4 How many types of databases are there?
Ans:- The two main types of databases are Flat File Database and Relational Database.
B. Answer the following questions in long.
Q.1 Explain the difference between a flat file database and relational database.
Ans:- Flat File Database:- A flat file database stores data in simple text files , where each line represents a single record , The data is unstructured and this type of data called flat file database. Flat file database include CSC (comma-separeted values ) files and MS excel files.
Relational Database :- A relational database organises data into multiple tables ,each containing rows and columns . These table are interconnected to related information. Popular example of relational database include Microsoft Access ,MySQL, and Oracle.
Q.2 What are the key components of a Database Management System?
Ans-The key components of a Database Management System (DBMS) are as follows:
Table:. It organises information into rows and columns, with each row representing a record and each column representing a specific type of data.
Field: A field is a column within a table. It is used to store a specific type of information.
Record: A record is a row on a table. It consists of two or more fields and contains all the information related to a single item, person, or entity in the database.
Data: Data refers to a collection of facts, figures, or details that are stored and organised within a database. It can include several types of information, such as numbers, text, or other forms of content.
Query: A query is like a tool that helps you search for specific information in a database. Queries can also be used to modify or update information, such as correcting a mistake in the data.
Form: A form is a user-friendly interface that helps you add or view information in a database.It sends that information to the database for storage and future use.
Report: A report is a way of displaying information from a database in a clean and organised format, often for printing.
Q.3 What do you understand by Datatype ?
Ans:- A table consists of multiple fields ,each designed to store diverse types of data . In access ,you can assign data type to each field. The data type of a field determines the kind of data that can be entered into it .
.png)
