Which Of The Following Database Objects Automates Repetitive Tasks

• What is the program that enables you to create, access and manage a database called?

  A)

  Database done clear

  B)

  Data structure done clear

  C)

  Operating system done clear

  D)

  Database Management System done clear

  View Solution play_arrow

• Which of the following is a popular software that supports DBMS?

  A)

  MS-Access done clear

  B)

  MS-Word done clear

  C)

  MS-Excel done clear

  D)

  MS-Paint done clear

  View Solution play_arrow

• What was the initial code name of MS-Access?

  A)

  Omega done clear

  B)

  Cirrus done clear

  C)

  Deco done clear

  D)

  Boston done clear

  View Solution play_arrow

• When an Access file is saved, what file format does it take?

  A)

  .MDB done clear

  B)

  .PST done clear

  C)

  .RLS done clear

  D)

  .ODP done clear

  View Solution play_arrow

• In MS-Access, what do the rows in. a table represent?

  A)

  fields done clear

  B)

  records done clear

  C)

  data done clear

  D)

  tables done clear

  View Solution play_arrow

• In MS-Access, what defines the information of each type of detail in a record?

  A)

  Tables done clear

  B)

  Files done clear

  C)

  Documents done clear

  D)

  Fields done clear

  View Solution play_arrow

• In MS-Access, what is the function of the primary key?

  A)

  To identify each row of a table. done clear

  B)

  To relate tables to each other using a foreign key. done clear

  C)

  "To maintain reference and referential integrity. done clear

  D)

  All of the above done clear

  View Solution play_arrow

• What is the correct path to start MS-Access?

  A)

  Start\[\to \]Programs\[\to \]Microsoft Office\[\to \] MS\[\to \]Access done clear

  B)

  Start\[\to \]Programs\[\to \]Accessories\[\to \]MS-Access done clear

  C)

  Start \[\to \] Run \[\to \]MS-Access done clear

  D)

  Start\[\to \] Accessories\[\to \]Microsoft Office\[\to \] MS-Access done clear

  View Solution play_arrow

• What is the maximum characters a field name can contain in MS- Access?

  A)

  32 done clear

  B)

  64 done clear

  C)

  255 done clear

  D)

  100 done clear

  View Solution play_arrow

• Which program in MS-Access is used to automate a repetitive task?

  A)

  Reports done clear

  B)

  Forms done clear

  C)

  Macros done clear

  D)

  Pages done clear

  View Solution play_arrow

• Which shortcut key will open the task pane in MS-Access?

  A)

  Ctrl + F1 done clear

  B)

  Ctrl + F5 done clear

  C)

  Shift + F1 done clear

  D)

  Shift + F5 done clear

  View Solution play_arrow

• What is the shortcut key that helps you insert the current date in access?

  A)

  Ctrl + semicolon done clear

  B)

  Alt + semicolon done clear

  C)

  Shift + semicolon done clear

  D)

  Semicolon done clear

  View Solution play_arrow

• What is the DEFAULT SIZE of text data type in MS-Access?

  A)

  20 done clear

  B)

  255 done clear

  C)

  50 done clear

  D)

  256 done clear

  View Solution play_arrow

• Which of the following characters cannot be used while naming a file in MS-Access?

  A)

  [] done clear

  B)

  ? done clear

  C)

  - (dash) done clear

  D)

  , (comma) done clear

  View Solution play_arrow

• Which one of the following is NOT a valid MS-Access field data type?

  A)

  Number done clear

  B)

  Memo done clear

  C)

  Text done clear

  D)

  Character done clear

  View Solution play_arrow

• Which of the following data types is used for lengthy text and numbers?

  A)

  Text done clear

  B)

  Memo done clear

  C)

  Currency done clear

  D)

  Numbers done clear

  View Solution play_arrow

• What does the given window represent?

  A)

  Design view done clear

  B)

  Datasheet view done clear

  C)

  Database window done clear

  D)

  File task pane window done clear

  View Solution play_arrow

• Which view gives more control over the table or query?

  A)

  Design view done clear

  B)

  Datasheet view done clear

  C)

  Both (a) and (b) done clear

  D)

  Neither (a) nor (b) done clear

  View Solution play_arrow

• ___ creates tables, modifies and organizes bulk data.

  A)

  Word processor done clear

  B)

  Presentation software done clear

  C)

  Animation software done clear

  D)

  Data Base Management System (DBMS) done clear

  View Solution play_arrow

• The  icon of the field indicates that r

  A)

  this field is the primary key with a unique value. done clear

  B)

  you are currently entering data into this row or field. done clear

  C)

  you are deleting the field. done clear

  D)

  you are inserting a new column into the table. done clear

  View Solution play_arrow

• The Iconindicates that

  A)

  this field is the primary key with a unique value. done clear

  B)

  you are currently entering data into this row or field. done clear

  C)

  you are deleting the field. done clear

  D)

  you are inserting a new column into the table. done clear

  View Solution play_arrow

• ___ uniquely identifies a record of the table.

  A)

  Data view sheet done clear

  B)

  Design view done clear

  C)

  Primary key done clear

  D)

  Forms done clear

  View Solution play_arrow

• Which of these icons will help you enter the data into a table?

  A)

  Data sheet view sheet done clear

  B)

  Design view done clear

  C)

  Primary key done clear

  D)

  Forms done clear

  View Solution play_arrow

• Which of the following options will you choose to design the format of your table and the data types?

  A)

  Data view sheet done clear

  B)

  Design view done clear

  C)

  Primary key done clear

  D)

  Forms done clear

  View Solution play_arrow

• Which of these is/are DBMS?

  A)

  MS Access done clear

  B)

  Oracle done clear

  C)

  Fox pro done clear

  D)

  All of these done clear

  View Solution play_arrow

• When you right click on any field of the table, you will find a menu. What is it called?

  A)

  Shortcut menu done clear

  B)

  Edit menu done clear

  C)

  File menu done clear

  D)

  Help menu done clear

  View Solution play_arrow

• Which of these menu options must be chosen to set the primary key using the menu bar?

  A)

  Shortcut menu done clear

  B)

  Edit menu done clear

  C)

  File menu done clear

  D)

  Help menu done clear

  View Solution play_arrow

• Two or more columns which are set as primary keys are called _­­­_________ primary keys.

  A)

  unique done clear

  B)

  report done clear

  C)

  form done clear

  D)

  composite done clear

  View Solution play_arrow

• Which of these objects provides the accessibility of data through internet?

  A)

  Reports done clear

  B)

  Macros done clear

  C)

  Pages done clear

  D)

  Query done clear

  View Solution play_arrow

• Which objects of MS Access interconnects two or more tables of Access?

  A)

  Reports done clear

  B)

  Macros done clear

  C)

  Pages done clear

  D)

  Query done clear

  View Solution play_arrow

• The printouts of the Access database are called ________.

  A)

  pages done clear

  B)

  reports done clear

  C)

  forms done clear

  D)

  tables done clear

  View Solution play_arrow

• Which of the following statements is/are false?

  A)

  Macros are small, user - written programs to automate repetitive tasks. done clear

  B)

  Forms are the printouts of the Access files. done clear

  C)

  Queries interrelates two or more tables. done clear

  D)

  All of these done clear

  View Solution play_arrow

• Which of the following windows represents the last step in the creation of a table?

  A)

  done clear

  B)

  done clear

  C)

  done clear

  D)

  done clear

  View Solution play_arrow

• Which of the following displays sample tables?

  A)

  Blank Access database done clear

  B)

  Table wizard done clear

  C)

  Both (a) and done clear

  D)

  Neither (b) nor done clear

  View Solution play_arrow

• Which of these icons will you click to insert a new column?

  A)

  done clear

  B)

  done clear

  C)

  done clear

  D)

  done clear

  View Solution play_arrow

• Which icon will you choose to delete a row from a table?

  A)

  done clear

  B)

  done clear

  C)

  done clear

  D)

  done clear

  View Solution play_arrow

• The ___ icon helps you insert a new row into the table.

  A)

  done clear

  B)

  done clear

  C)

  done clear

  D)

  done clear

  View Solution play_arrow

• Which of these icons should you click to delete a column from the table?

  A)

  done clear

  B)

  done clear

  C)

  done clear

  D)

  done clear

  View Solution play_arrow

• Which icon will you click on to switch to design view from Datasheet view?

  A)

  done clear

  B)

  done clear

  C)

  done clear

  D)

  done clear

  View Solution play_arrow

• Which icon of the standard tool bar will you click, to switch on to Data sheet view from Design view?

  A)

  done clear

  B)

  done clear

  C)

  done clear

  D)

  done clear

  View Solution play_arrow

• What is the function of freeze column option?

  A)

  Inserts a new column done clear

  B)

  Inserts a new row done clear

  C)

  Deletes a row done clear

  D)

  Freezes the selected column done clear

  View Solution play_arrow

• Which of the following is NOT true about primary key?

  A)

  Primary key field can have a character value. done clear

  B)

  Primary key field helps to check redundancy of data. done clear

  C)

  Primary key field can have a null value. done clear

  D)

  Primary key field can have zero value. done clear

  View Solution play_arrow

Which Of The Following Database Objects Automates Repetitive Tasks

Source: https://www.studyadda.com/question-bank/8th-class/computers-science/microsoft-access/microsoft-access/2748

Posted by: quirogaughtmed.blogspot.com

Share this post