MS ACCESS 10 Flashcards

1
Q

What is database

A

It is an combined collection of logical related records in the form of tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is dbms?

A

It is a set of computer program that controls the creation, maintenance and the use of database in the computer.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is database objects?

A

These are various components of ms access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is data type

A

It is format in which the data is accepted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

FIELD

A

It is a column arranged vertically in a table that stores information of the same type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Form

A

It is a customised screen for viewing, entering, modifying and deleting data in a table or query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Primary key

A

It uniquely identifies each record in the table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Query

A

It is a question pertaining to data with a specific answer to it

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Record

A

It includes complete information pertaining to a particular record arranged horizontally in a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Report

A

It is the representation of data in a printed format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Table

A

It is a collection of related information in the form of rows and columns.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is Microsoft access

A

Microsoft access 2010 is a database program used for storing information in the form of tables, queries, forms, reports, etc.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How is DBMS USEFUL?

A

A DBMS is useful in the following aspects: reduces data redundancy, facilitates file sharing, controls data insecurity, enforces standards.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How can a new database be created?

A

A new database can be created either using a blank database or sample templates.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How can tables be created

A

Tables can be created either in data sheet view or design view in MS ACCESS 2010.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does design view consist of

A

The design consists of two panes:field grid pane and field properties pane.

17
Q

Why are queries raised

A

Queries are raised to retrieve specific info from a table or tables.

18
Q

What do forms provide

A

Forms provide different views for adding, deleting, formatting, and designing the data.

19
Q

What can be saved in a database

A

Queries, forms and reports created for a table can be saved in a database.