Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Info Tech > Database > Flashcards

Database Flashcards

1
Q

What is a database?

A

A database is a collection of related data or information.

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

Give five examples of commonly used databases.

A

Address banks, dictionaries, encyclopedias, library card catalogs, record of stock, customers data, patient data, student data, employee data, telephone directories.

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

What are the two types of databases?

A

Manual and electronic databases

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

What is the difference between the two types of databases?

A

In a manual database information is usually stored on paper which is stored in filing cabinets and in an electronic database information is stored in an electronic format and that data can be accessed using a computer.

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

What is another name for database software?

A

Database management system.

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

Disadvantages of manual databases?

A

1) large amounts of storage space are needed for filing cabinets
2) Folders can easily be misplaced
3) Information cannot be accessed from a remote site
4) Data may unnecessarily be duplicated in more than one file
5) Difficulty in cross-referencing data retrieval of information is slow

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

Advantages of Database Management Software?

A

1) easy to retrieve and update data
2) data can be shared by authorized users of the organization
3) it is useful for storing, updating and preserving data
4) they provide a standardized interfaced for working with tables, queries and reports
5) users can create reports very easily and quickly
6) There is no duplication of data

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

Steps in starting Microsoft Access?

A

1) Click on the start button
2) Go to ‘All Programs’
3) Press ‘Microsoft Office’
4) Click ‘Microsoft Access’ or double click on the ‘Access’ icon

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

True or False: A Microsoft Access database consists of one or more objects

A

true

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

What is an object?

A

an object is an option you can select and manipulate

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

Give four examples of database objects and define them

A

1) Tables- a table is a collection of information about a specific subject or purpose

2) Query- a query asks a question of data in a table and finds records matching the specified criteria

3) Form- a form displays or accepts entry of data one record at a time

4) Report- a report summaries of information in a table

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

What is a table in a database?

A

a grid that stores related data in rows and columns

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

What is a field?

A

a field is an area reserved for one piece of individual data in a table

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

What is a field name?

A

the title assigned to a field

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

What is a record?

A

a group of related fields pertaining to one person, place or thing

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

What is a file?

A

the collection of related records

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

What are the columns in a database table called?

A

fields

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

What are the rows in a database table called?

A

records

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

Name all the data types and what they’re used for?

A

1) Text- words, symbols & numbers that don’t require mathematical calculations
2) Number- numeric data used in calculations
3) Memo- large amount of text
4) Currency- numeric data with a dollar sign
5) Date/Time- date and time values
6) Auto Number-
7) Yes/No- two or more possible values
8) OLE object- items such as a word document or picture linked
9) Hyperlink- text used as link

20
Q

Define relationship

A

a relationship is a link/connection made between two or more tables

21
Q

Reasons for establishing relationships between databases?

A

1) they help avoid duplication
2) They make queries easier to created
3) they allow data to be accessed faster
4) they help you create informative and useful reports

22
Q

Define ‘Primary key’ and give one example

A

a primary key is an attribute that is unique to each record
eg. an id number

23
Q

Name the four types of relationships

A

one to one
one to many
many to many
many to one

24
Q

Define ‘query’ as a verb

A

the action of retrieving data from your database

25
Q

What are two other names for a query?

A

a filter/ search

26
Q

Reasons for using a query?

A

Makes it easier:
1) View, add, delete or change data in your Access database
2) Find specific data quickly by filtering on specific criteria
3) Calculate or summarize data
4)Automate data management tasks

27
Q

What are the four types of queries?

A

1) Select query
2) Delete query
3) Update query
4) Append query

28
Q

What does a select query do?

A

this type of query is used to find out and display a subset of data

29
Q

What does a delete query do?

A

it is used to delete a record or sets of records

30
Q

What does an update query do?

A

it is used to edit or update the data in a group of records

31
Q

What does an append query do?

A

used to run a query and insert the results at the end

32
Q

A select query can later be converted to an ______ query

A

action

33
Q

Name the two types of query designs

A

Design View & Simple Query Wizard

34
Q

Which type of query design allows you to only choose a table and fields

A

the simple query wizard

35
Q

If you wish to add criteria or sort , you will need to go to which query design?

A

Design View

36
Q

A query can be sorted in two orders, name them

A

ascending or descending order

37
Q

What allows you to add fields to the grid?

A

the Show Checkbox

38
Q

Which data type should be used with a store ID?

A

auto number

39
Q

Which data type should be used with your first or last name?

A

text

40
Q

Which data type should be used with your address

A

text

41
Q

Which data type should be used with your city

A

text

42
Q

Which data type should be used with a phone number

A

text

43
Q

Which data type should be used with a DOB

A

date/time

44
Q

Which data type should be used with a ID pictures

A

OLE object

45
Q

Which data type should be used with a Instagram link

A

hyperlink

46
Q

Which data type should be used with stock prices

A

currency

Info Tech (11 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions