1-Forms are used to a provide a more user-friendly way to work with data in tabl
ID: 669429 • Letter: 1
Question
1-Forms are used to a provide a more user-friendly way to work with data in tables
a)True
b)false
2-Which of the following is NOT a reserved word in Access:
a) pixel b) data c) left d) name
3-The following type of Access form allows to see multiple records in an Excel-like arrangement of data fields:
a) split form b) data sheet c) multiple items
4-If you want to display information from a database to someone who is not a user of the database, you will have to use:
a)forms b) reports
5-To keep track of whether a particular customer, as of today, can buy on credit, one needs to create a field named "IsCreditApproved" that has the following data type:
a) integer b) yes/no c)long text d) date/time d) short text f) long integer
6-When deciding whether to use "Text" or "Number" for a particular field, all of the following considerations should be used EXCEPT:
a)Whether arithmetic operations are to be peroformed on this field
b)Whether a field can possibly "0" as the first digit
c) How you want the field to be sorted
d) Whether value of a field is alway a number or can be text sometimes
e)Whether a field contains a number
7-If you want to store information about email addresses, you need the following data type:
a)Email
b)Hyperlink
c)Long Text
d)Short Text
e)URL
8-OLE data types:
a)Make the database faster
b)Make the database larger and slower
c)Have no impact on the database
d)Make the database larger, but they don't slow down the overall performance of the database
9-Which of the following is NOT true about "Long Text" data type in Access?
a) It is usually used for storing long text fields
b) It has the same supported functionality as the "Short Text" data type fields
c) It supports formatted text
d) It is usually used for storing long text fields
10-Which of the following field naming convention is the best?
a)CustomerFirstName
b)Name
c)customerfirstname
d)Customer Name
11-One should avoid sketching database forms if one doesn't have an artistic talent
a)True
b)False
12-It's better to create tables just by starting typing in the data that you want the table to store. There is no need to name fields and specify their data types first
Explanation / Answer
1 a) true (entering data can be made easier and less prone to error)
2 a) pixel is not a reserved word (DATA IS NOT A RESERVED WORD NEITHERBUT, DATABASE, AND DATE ARE RESERVED WORDS)
3) B) DATASHEET
4) b) Reports
5) b) yes/no
6) e)Whether a field contains a number
7) b)Hyperlink (email type doesn't exist)
8) b)Make the database larger and slower
9) b) It has the same supported functionality as the "Short Text" data type fields
10) a)CustomerFirstName
11) b) false
12) b) false
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.