MS Access MCQ

1.       What is the maximum length of text field  can be ? a)       120      b) 255    c)       70        d) 256     2.       A record applies to data entered into  ---- row of a table. a)       single          b) double c)    multiple      d) None 3.       A relational database is able to store and manipulate data across multiple -----. a)  column      b) row c)  tables        d) None 4.       A database is defined as a collection of -----. a)  Objects   b) fields c)  columns       d) b & c 5.       Storage size limit of attachment (data type) is ------. a)  700kb   b) 800kb c)  900kb   d) 850kb 6.       AutoNumber is termed as ------. a)  Unique Number   b) Sequential Number c)  a & b                    d) Identified Number 7.       Which of the following store command to retrieve data from database? a) Forms           b) Reports c) Tables           d) Queries 8.       In which tab form is found? a)  Create   b) Database Tools c)  Home    d) None 9.       Which is not the part of Queries group? a)  Query Wizard   b) Query Design c)  Query Report    d) None 10.    A report can be sorted on one or more fields with the exceptions of ------- data type fields. a)  OLE                   b) Text c)  AutoNumber     d) Date/Time

11. Which is the type of relationship? a)    one to one        c) one to many b)       many to many d) all of the above 12. Before a relationship a database must contain ----        tables. a)       Three    b) Four c)    More    d) None 13. When using the name of a primary key field to        create a field in another table and thereby a link,        the new field is referred as ------ key. a)       Main       c) Foreign b)    Helping   d) Unique Identifier      14. Sorting arranges the data within a table into ----       Order. a)       alphabetical     c) a & b   b)       numerical         d) none `      15. ----- are used to create a link between two or more              tables within a database.               a) Forms     c) a & b               b) Queries   d) None  `      16. ----- can be used to display and maintain records              within your database                       a) Forms                 c) Query               b) Query Wizard    d) None `      17. The actual currency symbol depends upon the ----               settings of windows Control Panel.               a) Region      c) a & b               b) Language d) None `      18. Where is the record navigation bar?               a) at the bottom of screen               b) at the top of screen               c) at the top-right of screen               d) at the top left of screen `      19. Deleting a form is similar to deleting a ------.               a) table     c) record               b) field      d) None `      20. The attachment navigation arrows are most useful               when viewing ----- image attachments.               a) single              c) double               b) multiple          d) none      .