FINAL EXAM ACCESS

Submit

2. It is important to assign appropriate data types to a field since they specify what type of data can be entered into a field.

True

False

3. Table- The central framework of a database that stores data in fields (columns) and records (rows).

True

False

4.
Which is the valid data type in Access?

Number

Text

Currency

All of the above

5.
Which is the valid data type in Access?

Number

Text

Currency

All of the above

6.
Which leads you through the process of creating a table?

Wizard

Assistant

Relation

Coach

7. There are three types of relationships in Microsoft Access: One-to-many Many-to-many One-to-one

True

False

8. Is [your statement here] true or false?

True

False

9. Table, Query, Form, Report, Macro and Module are the objects in Ms Access

True

False

10.
What is an intersection of a row and a column?

Form

Cursor

Cell

Record

11.
Which of the following is not a valid Data Type in MS Access?

Memo

Picture

Currency

AutoNumber

12.
Which of the following is not a view for interacting with a form object?

Datasheet view

Design view

Form view

Layout view

13. A report is graphical interface used for data entry.

True

False

14.
Which data type is better to use for storing the price of an item?

Text

AutoNumber

Number

Currency

15.
In MS Access "Hyperlink" Data Type can store

Web Address

Email Address

Path of a file

All of the above

16. Which of the following is not a view for interacting with a form object?

Datasheet view

Design view

Form view

Layout view

17. Match the following

Record

Field

Value

Submit

18. Which object is used to create a form?

Tables and Queries

Tables only

Tables and reports

Queries and reports

19.
What determines a table's sort order?

Primary key

Field order

Index field

AutoNumber field

20.
How to make a date field DOB store the dates like "2002/10/17" ?

By setting the input mask property to “yyyy/mm/dd”

By setting the format property to “yyyy/mm/dd”

By entering dates in yyyy, mm, dd order

None of the above

21.
In MS Access, AutoNumber Data Type

Can be Sequential

Can be Random

Can be Edited

Only A & B

22. Which of the following views enables you to enter values in to a table?

Design

Datasheet

Database

Layout

23.
Which criteria return only those addresses beginning with the letter "K"?

Address = “K”

Address = “K*”

Address = “K?”

Address = “K#”

24. Which data type is better to use for storing phone number in the following format "977-1-1234567"?

Text

AutoNumber

Number

Currency

25. Ms Access is a software to manage data to produce information which is called Database Management System or DBMS

True

False

Final Exam Access

1. ________________________________ are used to create a new report

2.

What first name or nickname would you like us to use?

2. It is important to assign appropriate data types to a field since they specify what type of data can be entered into a field.

3. Table- The central framework of a database that stores data in fields (columns) and records (rows).

4.
Which is the valid data type in Access?

5.
Which is the valid data type in Access?

6.
Which leads you through the process of creating a table?

7. There are three types of relationships in Microsoft Access: One-to-many Many-to-many One-to-one

8. Is [your statement here] true or false?

9. Table, Query, Form, Report, Macro and Module are the objects in Ms Access

10.
What is an intersection of a row and a column?

11.
Which of the following is not a valid Data Type in MS Access?

12.
Which of the following is not a view for interacting with a form object?

13. A report is graphical interface used for data entry.

14.
Which data type is better to use for storing the price of an item?

15.
In MS Access "Hyperlink" Data Type can store

16. Which of the following is not a view for interacting with a form object?

17. Match the following

18. Which object is used to create a form?

19.
What determines a table's sort order?

20.
How to make a date field DOB store the dates like "2002/10/17" ?

21.
In MS Access, AutoNumber Data Type

22. Which of the following views enables you to enter values in to a table?

23.
Which criteria return only those addresses beginning with the letter "K"?

24. Which data type is better to use for storing phone number in the following format "977-1-1234567"?

25. Ms Access is a software to manage data to produce information which is called Database Management System or DBMS

Final Exam Access

1. ________________________________ are used to create a new report

2.

What first name or nickname would you like us to use?

2. It is important to assign appropriate data types to a field since they specify what type of data can be entered into a field.

3. Table- The central framework of a database that stores data in fields (columns) and records (rows).

4. Which is the valid data type in Access?

5. Which is the valid data type in Access?

6. Which leads you through the process of creating a table?

7. There are three types of relationships in Microsoft Access: One-to-many Many-to-many One-to-one

8. Is [your statement here] true or false?

9. Table, Query, Form, Report, Macro and Module are the objects in Ms Access

10. What is an intersection of a row and a column?

11. Which of the following is not a valid Data Type in MS Access?

12. Which of the following is not a view for interacting with a form object?

13. A report is graphical interface used for data entry.

14. Which data type is better to use for storing the price of an item?

15. In MS Access "Hyperlink" Data Type can store

16. Which of the following is not a view for interacting with a form object?

17. Match the following

18. Which object is used to create a form?

19. What determines a table's sort order?

20. How to make a date field DOB store the dates like "2002/10/17" ?

21. In MS Access, AutoNumber Data Type

22. Which of the following views enables you to enter values in to a table?

23. Which criteria return only those addresses beginning with the letter "K"?

24. Which data type is better to use for storing phone number in the following format "977-1-1234567"?

25. Ms Access is a software to manage data to produce information which is called Database Management System or DBMS

4.
Which is the valid data type in Access?

5.
Which is the valid data type in Access?

6.
Which leads you through the process of creating a table?

10.
What is an intersection of a row and a column?

11.
Which of the following is not a valid Data Type in MS Access?

12.
Which of the following is not a view for interacting with a form object?

14.
Which data type is better to use for storing the price of an item?

15.
In MS Access "Hyperlink" Data Type can store

19.
What determines a table's sort order?

20.
How to make a date field DOB store the dates like "2002/10/17" ?

21.
In MS Access, AutoNumber Data Type

23.
Which criteria return only those addresses beginning with the letter "K"?