Microsoft Access Flashcards

1
Q

Table Rows are called

A

Records

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

Which application saves data automatically as it is entered

A

MS Access

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

A computerized record keeping system is called a

A

Database Management System(DBS)

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

Where do you configure the field properties of a table

A

Design View

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

Which of the following is the correct definition of a record

A

All information about a single entity

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

Each item from this list is classified as…
Name
Birthdate
Social Security No.
Street
City
State
Zip

A

Field/Attribute Name

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

The best data type to choose for a postcode would be

A

Text

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

Which view of table is used to insert a field name in table

A

Design View

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

Which datatype will be used to generate numbers automatically while inserting data?

A

Auto number

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

Fields in database are similar to _____________ in tables

A

Columns

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

The _________________ field is exactly like number fields, but formatted to display decimal places and a currency symbol.

A

Currency

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

Microsoft’s version of a Database Management System

A

Access

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

Everything on one row is a record

A

True

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

Which data type would be most suitable for the ‘DateofBirth’ field?

A

Date/Time

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

A list of records is a _______________

A

Table

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

Client Name is an example of a

A

Field Name

17
Q

What are the functions of a database

A

Updating
Sorting
Editing

18
Q

What kind of data type do you use when entering a Client Number

A

Short Text

19
Q

The default extension of Ms-Access file is

A

.accdb

20
Q

Table Columns are called

A

Fields