by Things to Remember
a. A collection of related data of a person or anything is known as database.
b. A field which uniquely identifies a record of a table is primary key.
c. A column in a table is called field and row in a table is called record.
d. Primary key must not be null.
e. The default value size of text field is 50.
f. dBase is example of DBMS.
g. Memo is the field type used to store text that is more than 255 characters.
h. Auto number field type automatically enters number in a field which increases by 1 for every new record.
i. We can change data type of a field in design view.
j. Action query is used to change records on a table at the single operation.
k. Parameter queries used to make sure that the data entered in a field is within the criteria set by the user.
l. Delete query is used to delete record(s) from the table.
m. A query is a database object that creates a data sheet of selected fields and records from one or more table.
n. A calculated field displays the results of a calculation in a query.
o. A form is a database object used primarily to display records on screen, to make it easier to enter new records and to make changes to the
existing records.
p. Report is an access database object that presents information in a printed format.
q. The report design view window is the place where you design reports from a scratch or add your own touches to reports you create with report
wizard.
r. DBMS is a complex set of software programs that controls the organization, storage, management, and retrieval of data in database.
s. The smallest unit of data organization is called field.
t. MS-Access is a relational database management system where data is arranges in the form of tables.
u. A primary key is a field that uniquely identifies each record.
v. DBMS is a computer program designed to manage adatabase.
w. Oracle, MS-SQL, MS-Access, etc. is DBMS.
x. SQL stands for Structures Query Language.
y. Primary key value cannot occur twice in one table.
z. A primary key field cannot contain the null values.
aa. Compound/Composite key consists of multiple columns.
bb. Foreign key is the linking pin between two tables.
cc. A text field contains up to 255 characters.
dd. Tables, queries, forms and reports are objects of MS-Access.
a. A collection of related data of a person or anything is known as database.
b. A field which uniquely identifies a record of a table is primary key.
c. A column in a table is called field and row in a table is called record.
d. Primary key must not be null.
e. The default value size of text field is 50.
f. dBase is example of DBMS.
g. Memo is the field type used to store text that is more than 255 characters.
h. Auto number field type automatically enters number in a field which increases by 1 for every new record.
i. We can change data type of a field in design view.
j. Action query is used to change records on a table at the single operation.
k. Parameter queries used to make sure that the data entered in a field is within the criteria set by the user.
l. Delete query is used to delete record(s) from the table.
m. A query is a database object that creates a data sheet of selected fields and records from one or more table.
n. A calculated field displays the results of a calculation in a query.
o. A form is a database object used primarily to display records on screen, to make it easier to enter new records and to make changes to the
existing records.
p. Report is an access database object that presents information in a printed format.
q. The report design view window is the place where you design reports from a scratch or add your own touches to reports you create with report
wizard.
r. DBMS is a complex set of software programs that controls the organization, storage, management, and retrieval of data in database.
s. The smallest unit of data organization is called field.
t. MS-Access is a relational database management system where data is arranges in the form of tables.
u. A primary key is a field that uniquely identifies each record.
v. DBMS is a computer program designed to manage adatabase.
w. Oracle, MS-SQL, MS-Access, etc. is DBMS.
x. SQL stands for Structures Query Language.
y. Primary key value cannot occur twice in one table.
z. A primary key field cannot contain the null values.
aa. Compound/Composite key consists of multiple columns.
bb. Foreign key is the linking pin between two tables.
cc. A text field contains up to 255 characters.
dd. Tables, queries, forms and reports are objects of MS-Access.
No comments:
Post a Comment