MS Access Basics
Test
Model Test
Ebook
Index
Microsoft Access Home
MS Access Basics
135
Database and Tables
6
Schools
Ebook
Question:
To insert unique and sequential data automatically which data type can we use?
A
OLE
B
Attachment
C
Text
D
AutoNumber
Note:
Not available
Show answer
Show Note
Report
Question:
Which of the following is the primary data repository in Access database?
A
Queries
B
Form
C
Table
D
Report
Note:
Not available
Show answer
Show Note
Report
Question:
What do you mean by "*" symbol?
A
It represents the column currently selected.
B
It represents the row previously selected.Z
C
It represents the row currently selected
D
None
Note:
Not available
Show answer
Show Note
Report
Question:
What do you mean by this query expression >=#1/1/1999 And <#1/1/2000?
A
The entry must be a date from 1999 to 2000
B
The entry must be a date in 1999
C
Both
D
None
Note:
Not available
Show answer
Show Note
Report
Question:
To locate a particular record which of the following options of the navigation bar we can use?
A
First
B
Specific
C
Next
D
Last
Note:
Not available
Show answer
Show Note
Report
Question:
Null value is allowed in ______
A
Unique key field
B
Primary key field
C
Foreign key field
D
ALL
Note:
Null value is allowed in foreign key if there is no referential integrity applied
Show answer
Show Note
Report
Question:
An index is automatically created on ______
A
Primary key field
B
Foreign key field
C
Id Number
D
All
Note:
Not available
Show answer
Show Note
Report
Question:
If we set the "Required" field property to "YES" then what happens?
A
Data cannot be deleted
B
This prevents it from being left blank
C
Data can be edited
D
All
Note:
Not available
Show answer
Show Note
Report
Question:
What do you mean by Like "A????"
A
Entry must be four characters and begin with the letter A
B
Entry must be five characters and begin with the letter A
C
Entry must be five characters and begin with any letter.
D
None
Note:
Not available
Show answer
Show Note
Report
Question:
In the memo data type you can insert data up to ______ characters
A
350
B
Unlimited
C
10000
D
65536
Note:
Not available
Show answer
Show Note
Report
First
Prev
10
11
12
13
14
Next
Last
/14
Go
Schools
Whiteboard
Blogs
Quiz
Test
Apply Course
Games
Freelancers
Professionals
Newspapers
Terms
Privacy
Copyright © 2024. Powered by
Intellect Software Ltd