35 : MS office - Access

Home >> Computer Awareness
1234567891011121314151617181920
1).
Which of these datatypes in MS Access allows alphabets, numbers and special characters?
2).
Under which menu there is an option to export data in MS Access?
3).
Which of the following are types of MS Access Database object?
4).
What is a Macro in MS Access?
5).
Which function in MS Access gives the number of time intervals between two specified dates?
6).
Which of the following functions in MS Access is used to reverse the string?
7).
Which of the following functions returns a string that contains the value of an operating system environment variable?
8).
Which of these MS Access functions check whether the expression is a Null value?
9).
Which of these MS Access functions return the current user?
10).
What is the use of Randomize function in MS Access?
11).
What is MS Access?
12).
What is Iif function in MS Access?
13).
How many number of characters can be entered in a field name in MS Access 2010?
14).
Which of these is the extension of MS Access 2007 database file?
15).
What is the size of currency datatype?
16).
What is the shortcut key to switch between the field names and properties panels in table design view?
17).
What does OLE in MS Access stand for?
18).
Which MS Access feature is used to copy a control's formatting?
19).
What do we call the columns of a table in Microsoft Access?
20).
What is the use of Cascade Delete option in MS Access?
1. Which of these datatypes in MS Access allows alphabets, numbers and special characters?
[A] Short Text
[B] Currency
[C] Date
[D] Autonumber
2. Under which menu there is an option to export data in MS Access?
[A] External Data
[B] Database tools
[C] Home
[D] Create
3. Which of the following are types of MS Access Database object?
[A] Form
[B] Modules
[C] Tables
[D] All of the above
4. What is a Macro in MS Access?
[A] a datatype
[B] tool that allows to automate tasks
[C] a wizard that creates charts and infographs
[D] None of the above
5. Which function in MS Access gives the number of time intervals between two specified dates?
[A] DateInter()
[B] DateSub()
[C] DateDiff()
[D] DaysBetween()
6. Which of the following functions in MS Access is used to reverse the string?
[A] StrRev()
[B] StrReverse()
[C] StringRev()
[D] None of the above
7. Which of the following functions returns a string that contains the value of an operating system environment variable?
[A] Env()
[B] Environment()
[C] Environ()
[D] None of the above
8. Which of these MS Access functions check whether the expression is a Null value?
[A] Null()
[B] IsNull()
[C] Zero()
[D] IsZero()
9. Which of these MS Access functions return the current user?
[A] IsUser()
[B] AccUser()
[C] User()
[D] CurrentUser()
10. What is the use of Randomize function in MS Access?
[A] It gives a random date
[B] It initializes the Rnd function’s random-number generator
[C] It generates true or false randomly
[D] None of the above
Advertisement

Kindly help us to keep GKToday updated and error free. Use this form to report error or outdated information in questions. We shall rectify asap...