database applications

Question 1

what is a table

Answer 1

a table consists of a number of records

Question 2

what is a record

Answer 2

a record is represented as a row in a table

Question 3

what is a field

Answer 3

a field is part of a record that stores a single fata item represented by a column

Question 4

what is a key field

Answer 4

a key field uniquely identifies one record

Question 5

what is a query

Answer 5

a query seaches and filters data in a database that satisfies the query criteria

Question 6

what is a form

Answer 6

a form is used to collect data to create a new record or modify an existing record or view records already stored in a table

Question 7

what is a report

Answer 7

reports are used to present results from queries in an effective manner

Question 8

what is a macro

Answer 8

a macro is an application that are written to do a specific task automatically

Question 9

what is a database relationships

Answer 9

a database relationship link two or more tables in a database using a relationship type

Question 10

what is importing data

Answer 10

it is possible to import a number of worksheets from a spreadshee

Question 11

what is text

Answer 11

text and data that requires a mathematical calculations

Question 12

what is number

Answer 12

numeric data that requires a mathematical calculations

Question 13

what is date/time

Answer 13

dates and times

Question 14

what is currency

Answer 14

monetary data includes two decimal places

Question 15

what is autonumber

Answer 15

to create a key field the computer generates sequintial numbers that are automatically inserted for each new record