1 If we set the “Required” field property to “YES” then what happens?
A.   Data can not be deleted
B.  This prevents it from being left blank
C.  Data can be edited
D.  All of the above
2 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
3 Which one of the following is the extension of MS-Access 2007 database?
A.   .mdb
B.  .accdb
C.  .xlsx
D.  None
4 Which one of the following statements is not correct related to Primary key?
A.     A primary key is used as unique identifier for each column
B.  A primary key field can never be left empty
C.      When working with related tables, the primary key field in one table can be used as foreign key field in another table.
D.  Both B & C
5 What do you mean by * symbol ?
A.   It represents the column currently selected.
B.  It represents the row previously selected.
C.  It represents the row currently selected
D.  None of the above
6 Which of the following is the primary data repository in Access database?
A.   Queries
B.  Form
C.  Table
D.  Report
7 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 a & b
D.  None
8 To configure the properties of an object in MS-Access 2007, which of the following can we use?
A.   Datasheet view
B.  Design view
C.  Table view
 Print preview
9 Which one of the following statements is not correct related to Index?
A.      An index stores the location of records.
B.      Index may speed up searches, it can also slow the process of updating data within table.
C.       You can set index on a field which is seldom used
D.   You can set index on any fields except OLE objects or attachment fields.
10 To locate a particular record which of the following options of the navigation bar can we use ?
A.       First
B.      Specific
C.    Next
D.       Last
1 Which is not related to relationship?
A.   Avoid duplicate data
B.  Data can be entered into or viewed from one or more tables
C.  create inconsistency of data
D.  None
2 How can you get ‘Simple query wizard’ tool?
A.   Database tool > Query Wizard > Simple Query Wizard
B.  Create tab > Query Wizard > Simple Query Wizard
C.  Create tab > Query design > Simple Query Wizard
D.   None
3 Which of the following presents data in a way similar to an Excel spreadsheet.
A.   Datasheet view
B.  Design view
C.  Print preview
D.  Layout preview
5 Why do we use Filter?
A.   To find more specific record
B.  Sorting field in different direction
C.  Filtering out records that we don’t want
D.  All of the above
6 How can you export a table or query output as an excel spreadsheet?
A.         Open an access databaseàopen file queriesàClick external data tabàclick Export to XML icon.
B.  Open an access databaseàopen file queriesàClick external data tabàclick Export to Excel Spreadsheet icon
C.          Open an access databaseàopen file queriesàClick external data tabàSaved import icon
D.  None
9 Access 2007 supports which of the following relationships?
A.   Many to Many
B.  One to One
C.  One to Many
D.   All
10 Access 2007 supports which type of database system?
A.   DBMS
B.   RDBMS
C.   Flat file system
D.   ORDBMS
4 In which row of query design grid do we set conditions?
A.   Field
B.  sort
C.  criteria
D.  show
1 To insert unique and sequential data automatically which data type can we use?
 A.   OLE
 B.        Attachment
 C.       Text
 D.  AutoNumber
2 An index is automatically created on
 A.   Primary key field
 B.  Foreign key field
 C.  Id Number
 D.  All of them
1 Getting data from a cell located in a different sheet is called …
A.   Accessing
B.  Referencing
C.  Updating
D.  Functioning
3 Which one of the following is not the form view?
A.   Form view
B.  Datasheet view
C.  Layout view
D.  Design view

\

3 To create a relationship what should you do?
A.   Click Insert menu and then click Relationship
B.  Click Database Tools tab and click Relationship button
C.  Click Edit menu and then click Relationship
D.  Press Ctrl + Shift + P
10 Updating all tables that are dependent upon a main or master table is called
A.   Cascade delete
B.  Cascade update
C.  Referential integrity
D.  None
10 Which one is correct regarding relationships?
A.   You can not edit or delete relationship.
B.  Many to Many relationship between tables is considered as an ideal relationship.
C.  You can not edit table after establishing relationship
D.  None

3 Which of the following symbol is used before a number to make it a label?

A.   “ (quote)
B.  = (equal)
C.  _ (underscore)
D.  ‘ (apostrophe)
Advertisements