12th Class Computer Chapter 9 Introduction to Data Access Short Questions Answer

12th Class Computer Chapter 9 Introduction to Data Access Short Questions Answer

[toggle title=”Define a database? ” state=”close”]
Database is a collection of data related to a particular topic or subject. The information it can be anything such as names, addresses, inventory, orders, results, etc.[/toggle]
[toggle title=”On which objects do a database consist. ” state=”close”]
A database consists of a collection of objects that is tables, forms, queries, reports etc.[/toggle]
[toggle title=” What does the table hold in Access? ” state=”close”]
In Access the table holds the data. Each database contains one or more tables.[/toggle]
[toggle title=”What is a relationship? ” state=”close”]
A link between entities or tables in a database is known as a relationship. [/toggle]
[toggle title=”What is the structure of Access table? ” state=”close”]
It is very similar to an Excel worksheet. It is organized into rows and columns and individual data items are entered into the cells that are created by the gridlines.[/toggle]
[toggle title=”What do the column and row represent in Access table? ” state=”close”]
In Access each column in a table represents a field while each row in the table consists of a single record.[/toggle]
[toggle title=”What does a field and a record hold? ” state=”close”]
A field holds a piece of data about an item and a record holds all the information for one item in the table.[/toggle]
[toggle title=”What can a field store? ” state=”close”]
A field can store text, numbers, dates, times amounts of money etc. [/toggle]
[toggle title=”How many phases involve working with a database? ” state=”close”]
Working with a database involves two phases that is the design phase and the data-managing phase.[/toggle]
[toggle title=”Write down the use of design view?” state=”close”]
Design view is used which provides tools for Creating and modifying tables and forms.[/toggle]
[toggle title=”What does the design of the object determine? ” state=”close”]
The design of the object determines what you see when you work with data using that object. [/toggle]
[toggle title=”What is the use of datasheet or Form view? ” state=”close”]
Generally datasheet or Form view is used to enter, edit and organize data in various ways. [/toggle]
[toggle title=”Define a form? ” state=”close”]
A form is a window that displays a collection of controls, such as labels, text boxes, check boxes and lists for viewing, entering and editing the information in database fields.[/toggle]
[toggle title=”Differentiate between a table or a form? ” state=”close”]
A table stores the actual database data while a form is merely a tool for viewing or modifying the data.[/toggle]
[toggle title=”What does a form display? ” state=”close”]
A form typically displays only one record at a time and provides access to selected fields within one or more tables.[/toggle]
[toggle title=”What is the use of a report? ” state=”close”]
Reports are used for printing information from the database. A report can combine data from more than one table.[/toggle]
[toggle title=”How are the reports designed? ” state=”close”]
Reports are designed using design view or Report wizards.[/toggle]
[toggle title=”What do you know about the controls in Reports? ” state=”close”]
Reports are designed by adding visual objects known as controls to the design gird. Each control displays and item of information. [/toggle]
[toggle title=”What is a primary key? ” state=”close”]
It is a unique key field in a table.[/toggle]
[toggle title=”How many characters do Memo fields Contain? ” state=”close”]
Memo fields ordinarily contain as many as 65,535 characters.[/toggle]