10th Class Computers Science Microsoft Access Question Bank

done Working With MS-Access 2013 Total Questions - 10

• question_answer1)
  Microsoft Access 2013 is a:
  A)
   word processing software package done clear
  B)
   slideshow presentation software package done clear
  C)
   spreadsheet software package done clear
  D)
   relational database management software package done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer2)
  Read the following Statements:

  Statement 1: Sorting allows you to arrange the records in a table for manipulation and retrieval.

  Statement 2: Filtering allows you to filter the records in a table for particular manipulation and retrieval.

  Statement 3: A table is a set of data elements (Values) using a model of vertical columns horizontal rows the cell being the unit where a row and column intersect.

   
  A)
   Statement 1 is correct done clear
  B)
   Statement 2 is correct done clear
  C)
   Statement 3 is correct done clear
  D)
   All are Correct done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer3)
  When designing a database in Access, what is the first thing you need to determine in order to begin?
  A)
   The number of tables needed done clear
  B)
   The purpose of the database done clear
  C)
   The name of the tables done clear
  D)
   The number of fields needed done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer4)
  MS Access enables a list of data types which can be used to represent different types of records. Which of the following data types is/are available in MS Access?
  A)
   Text                done clear
  B)
   Date done clear
  C)
   Number                        done clear
  D)
   All of these done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer5)
  Read the following statements:

  Statement 1: A tuple represents an object and information about that object.

  Statement 2: A cell is the intersection of rows and columns that are used to enter data.

  Statement 3: A rows are horizontal lines and columns are vertical columns.

  Which one of the following is correct with respect to the above statements?
  A)
   Statement 1 is correct             done clear
  B)
   Statement 2 is correct done clear
  C)
   Statement 3 is correct             done clear
  D)
   All statement are correct done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer6)
  Which one of the following describes the set of possible values for a given attribute?
  A)
   Domain                        done clear
  B)
   Attributes done clear
  C)
   Tuple                         done clear
  D)
   All of these done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer7)
  MS Access is an RDBMS that allows creating relationship between more than one table. Which one of the following keys is used to create relationship between tables?
  A)
   Primary key                  done clear
  B)
   Unique key done clear
  C)
   Foreign key                   done clear
  D)
   All of these done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer8)
  When you set up a filter, you are telling Access to look for records that match a specific _____ that you set.
  A)
   number limit                  done clear
  B)
   command done clear
  C)
   total                             done clear
  D)
   criteria done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer9)
  DBMS is a program which retrieves, modifies and stores the data in database on request. Which one of the following is the correct expanded form of DBMS?
  A)
   Data Maintaining System done clear
  B)
   Database Maintaining Software done clear
  C)
   Data Management System done clear
  D)
   Database Management System done clear
  E)
   None of these done clear
  View Solution play_arrow

• question_answer10)
  Match the following:

  S. NO	A	S. NO	B
  1.	Cardinality	[A]	Cannot contain null value.
  2.	Unique key	[B]	Ensures that data in the database is valid and correct.
  3.	Data integrity	[C]	Has eligibility to make primary key.
  4.	Candidate key	[D]	The number of tuples in a relation.
  		[E]	Can contain null value.

  A)
   1\[\to \]D, 2\[\to \]E, 3\[\to \]B, 4-\[\to \]C done clear
  B)
   1\[\to \]D, 2\[\to \]E, 3\[\to \]A, 4\[\to \]B done clear
  C)
   1\[\to \]B, 2\[\to \]C, 3\[\to \]D, 4\[\to \]E done clear
  D)
   1\[\to \]C, 2\[\to \]E, 3\[\to \]B, 4\[\to \]B done clear
  E)
   None of these done clear
  View Solution play_arrow