Sample question and Unit A

Question 1

_______ refers to enhancing the appearance of the information

Answer 1

formatting

Question 2

the primary object you use to print database content is called a _________

Answer 2

report

Question 3

you enter and edit data in a _________ the same way you do in a ____________

Answer 3

query, table

Question 4

you use ________ to manage data that is organised into lists

Answer 4

relational database

Question 5

you use ________ view to add delete or move the fields in an existing query

Answer 5

query design

Question 6

__________ is a field that contains unique information

Answer 6

key field

Question 7

true or false: reporting in excel and access have the same feature

Answer 7

false

Question 8

true or false: a query sometimes called a logical view of data

Answer 8

true

Question 9

true or false: the field list lists the database tables and the fields they contain

Answer 9

true

Question 10

access reduces data redundancy

Answer 10

true

Question 11

a blank from scratch from form design view

Answer 11

false

Question 12

criteria syntax specifies how to enter the criteria

Answer 12

true

Question 13

what are the two important purposes of a primary key

Answer 13

-it contains data that uniquely identifies each record so that no 2 records can have the same exact entry in the primary key field
-it helps relate one table to another in a one-to-many relationship

Question 13

what is a join line

Answer 13

they are used to identify which fields are used to establish the relationship

Question 14

4 advantages of using access for database management

Answer 14

-duplicate data is minimised
-information is more accurate, reliable and consistent because duplicate data is minimised
-data entry is faster and easier with forms
-information more secure access passwords and security feature

Question 15

what is the tab stop

Answer 15

whether a control can receive the focus in the first place. by default, the tab stop property for all text and combo boxes are set to “yes”, however, some text boxes (eg. ones with expressions) will not be used for data entry

Question 16

explain two common criteria that search for blank fields

Answer 16

-is null
-is not null

Question 17

field

Answer 17

a category of infromation in a table

Question 18

datasheet

Answer 18

a spreadsheet like grid that displays fields such as columns and records as rows

Question 18

query

Answer 18

a subset of data from one or more tables

Question 18

table

Answer 18

a collection of records for a single subject

Question 19

report

Answer 19

a professional printout of database infromation

Question 20

record

Answer 20

a group of related fields for one item

Question 20

form

Answer 20

an easy to use data entry screen

Question 21

what is not a typical enefit of relational databse

Answer 21

more common than spreadsheets

Question 22

not an advantag of managing data with relational database software

Answer 22

uses a single table to store all data

Question 23

when you create a new databse, which object is created first

Answer 23

table