Database

Question 1

What is DBMS?

Answer 1

Database Management System are Programs that handle the storage, modification and retrieval of data as well as restricting the persons that have access to the information. i.e renweb

Question 2

What is a database made up of?

Answer 2

a database is made up of tables, records and fields

Question 3

What are the different keys in a database?

Answer 3

Primary Key
Candidate Key
Composite Key
Secondary/Alternate Key
Foreign Key

Question 4

Primary Key

Answer 4

A unique field that is used to identify each record in a database table.

Question 5

Secondary/Alternate Key

Answer 5

A candidate key that has not been selected as the primary key.

Question 6

Foreign Key

Answer 6

A field in a table that has been linked with the primary key field of another table.

Question 7

Composite Key

Answer 7

A primary key that consists of two or more fields together.

Question 8

Candidate Key

Answer 8

A field that could possibly act as the primary key for the table.

Question 9

How do you create a calculated query?

Answer 9

1. Navigation pane–>Click your query–> click design view
2. Click field cell in where you want the calculated field
3. Manually type your expression –> Run

Question 10

How do you create a query?

Answer 10

1. Create Tab–>Query Design–>Show table –> select table for the query
2. Click add, repeat as needed–> click close
3. Click the required fields from the lower right area of the query design screen–> set criteria and sort orders
4. Click Run