Computer/Query of MS Access MCQS Part 1 Sample Test,Sample questions

Question:
 In the form wizard dialog box the fields from the selected table are displayed in this list box.

1.All fields

2.All records

3.Available records

4.Available fields

Posted Date:-2021-02-19 08:33:39


Question:
 In the form wizard dialog box the fields from the selected table are displayed in this list box.

1.All fields

2.All records

3.Available records

4.Available fields

Posted Date:-2021-02-19 08:33:39


Question:
 It is a query that when run displays its own dialog box prompting you for information such as

1.Select

2.Crosstab

3.Parameter

4.Append

Posted Date:-2021-02-19 08:33:39


Question:
 Saving a database in access is done

1. At the beginning of the database

2.The first time you save data

3.When closing the application

4.During auto save

Posted Date:-2021-02-19 08:33:39


Question:
 This is not one of the sections of the form design window

1.Form footer

2. Form content

3.Form header

4.Form detail

Posted Date:-2021-02-19 08:33:39


Question:
 To set a password for the database select ____________ in the Microsoft Access open window.

1. Open read only

2. Open write only

3.Open explicit

4.Open exclusive

Posted Date:-2021-02-19 08:33:39


Question:
 Which of the following database object is created first before any other created?

1.Table

2.Form

3.Report

4.Query

Posted Date:-2021-02-19 08:33:39


Question:
 Which of the following is not one of the methods available in the new query dialog box to create queries?

1.Design view

2. Crosstab query wizard

3.Simple query wizard

4.Datasheet view

Posted Date:-2021-02-19 08:33:39


Question:
A collection of related records in database is known as a

1.Table

2.Database

3.File

4. None of above

Posted Date:-2021-02-19 08:33:39


Question:
A part of database that stores complete information about an entity such as employee sales orders etc.

1.File

2.Record

3.Field

4.Query

Posted Date:-2021-02-19 08:33:39


Question:
A query that uses information from two or more tables to get the results is called a(n)

1.Informal query.

2.Optional query.

3.Complex query.

4.Multitable query.

Posted Date:-2021-02-19 08:33:39


Question:
A(n) _____ is an association that is created in a query between a field in one table or query and a field of the same data type in another table or query.

1.Join

2.Link

3.Connector

4.Identifier

Posted Date:-2021-02-19 08:33:39


Question:
Changing the order of this in the query datasheet does not affect the field order in the table.

1.Record

2.Row

3.Column

4.Sort

Posted Date:-2021-02-19 08:33:39


Question:
Database access levels are specified so as to define who can access what in a database. It is identified through

1.User id

2.Password

3.Status

4. None of above

Posted Date:-2021-02-19 08:33:39


Question:
If you make an invalid entry in the input mask wizard dialog box this will display to advise you that the entry is not correct

1.Text error

2.Validation error

3. Literal error

4.Entry error

Posted Date:-2021-02-19 08:33:39


Question:
If you write “Like Su*” in criteria cell of FirstName field it will display

1.All the names that are like Su such as Bunu Kunal Purna

2.All the names that begin with Su such as Suresh Sunita Sumit

3.Blank recordset

4.Error message

Posted Date:-2021-02-19 08:33:39


Question:
In a query when you have multiple conditions and each of them must satisfy to return the result use

1.AND

2.OR

3.NOT

4.XOR

Posted Date:-2021-02-19 08:33:39


Question:
In access this displays the results of a calculation in a query

1.Lookup field

2. Calculated field

3. Source field

4.Child field

Posted Date:-2021-02-19 08:33:39


Question:
In access this operation copies a backup file from the storage medium back onto the computer 

1.Recreate

2.Restore

3.Copy

4.Structure

Posted Date:-2021-02-19 08:33:39


Question:
In access this view is used to create and modify the structure of a form.

1.Normal

2.Datasheet

3. Form design

4.Control

Posted Date:-2021-02-19 08:33:39


Question:
In MS Access query which of the fields is derived field? Query: SELECT product.qty AS Quantity product.rate AS Rate product.qty*product.rate AS Amount FROM product

1. Quantity

2.Rate

3.Amount

4.Product

Posted Date:-2021-02-19 08:33:39


Question:
In the second subform wizard dialog box you specify the table to use as the data source and the. 

1.Records from the selected form

2.Form from the selected table

3. Fields from the selected table

4.Content from the selected form

Posted Date:-2021-02-19 08:33:39


Question:
In this form a single record may appear in multiple rows in the form window in order to fully display the field name label and data.

1.Datasheet

2.Tabular

3.Justified

4.Columnar

Posted Date:-2021-02-19 08:33:39


Question:
It is a sign or symbol that specifies operator and values that produce a result

1.Operator

2.Query

3.Expression

4.None of the above

Posted Date:-2021-02-19 08:33:39


Question:
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum

1.Parameter

2.Select

3.Crosstab

4.Append

Posted Date:-2021-02-19 08:33:39


Question:
 Which statement does not hold true?

1.A relationship establishes the association between common fields in two tables.

2.An AutoNumber field can be related to a field of either type AutoNumber or type Text.

3.Joins specify that each pair of rows that satisfy the join conditions will be combined in the results to form a single row.

4.Access will automatically create a join only if the field names in both tables are the same.

Posted Date:-2021-02-19 08:33:39


Question:
Microsoft Access uses Jet Query Engine which uses

1.MS SQL Server

2.Full fledged SQL

3.Dialect of SQL

4.None of above

Posted Date:-2021-02-19 08:33:39


Question:
Queries are based on this allowing you to use a query as the source for forms and reports

1.Filters

2.Tables

3.Records

4.Fields

Posted Date:-2021-02-19 08:33:39


Question:
Some rules are set in databases to check and permit only correct values. What is this feature called?

1.Data verification

2.Auditing

3.Data filtering

4. Data validation

Posted Date:-2021-02-19 08:33:39


Question:
The ascending order of data hierarchy is?

1.Bit – byte – field – record – file – databse

2.Bit – byte – record – field – file – database

3.Byte – bit – field – record – file – database

4.Bit – byte – field – record – database – file

Posted Date:-2021-02-19 08:33:39


Question:
The ‘filter by selection’ allows you to filter those records

1.That match the selected field

2.That match the criteria specified

3.That meet any of several criteria specified

4. All of above

Posted Date:-2021-02-19 08:33:39


Question:
The operation of checking input data against specified criteria is known as?

1.Data verification

2. Data validation

3.Cross check

4.Data control

Posted Date:-2021-02-19 08:33:39


Question:
The quickest way to add a field to the selected fields list is to double-click its field name in this list.

1.Find fields

2.Search fields

3. Search record

4.Available fields

Posted Date:-2021-02-19 08:33:39


Question:
The result of a query is displayed in a

1.Record

2. Query datasheet

3.Query table

4.Forms

Posted Date:-2021-02-19 08:33:39


Question:
This form displays multiple records one per row in the form window

1.Datasheet

2.Tabular

3.Columnar

4.Justified

Posted Date:-2021-02-19 08:33:39


Question:
This form displays the field name labels down the left side of the column with the data for each field just to the right of its corresponding label.

1.Tabular

2.Justified

3.Columnar

4.Datasheet

Posted Date:-2021-02-19 08:33:39


Question:
This query wizard will create a select query.

1.Crosstab

2.Find duplicates

3.Simple

4.Design view

Posted Date:-2021-02-19 08:33:39


Question:
This type of database contains multiple tables that are connected to produce combined output from all tables.

1.Bound

2.Linked

3.Relational

4.Joined

Posted Date:-2021-02-19 08:33:39


Question:
This type of query summarizes large amounts of data in easy-to-read row-and-column format.

1.Crosstab

2.Columnar

3.Select

4.Action

Posted Date:-2021-02-19 08:33:39


Question:
To create this you enter an expression in the design grid that instructs access to perform a calculation using the current field values.

1.Formulated field

2. Numeric field

3. Formula field

4.Calculated field

Posted Date:-2021-02-19 08:33:39


Question:
To enter the input mask wizard

1.Click on the three dots to the right of the caption entry field

2.Click on the three dots to the right of the format entry field

3.Click on the input mask toolbar

4.Click on the three dots to the right of the input mask entry field

Posted Date:-2021-02-19 08:33:39


Question:
What it is called to present information in a particular order based on numeric or alphabetical value?

1.Sorting

2.Searching

3. Arranging

4.Cropping

Posted Date:-2021-02-19 08:33:39


Question:
When you need to restrict the records that meets certain conditions you can mention them in

1.Filter cell

2.Sort cell

3.Show cell

4.Criteria cell

Posted Date:-2021-02-19 08:33:39


Question:
When you select this control its associated text control is also selected and the two controls will act as one when manipulated.

1.Text

2.Form

3.Label

4.Field

Posted Date:-2021-02-19 08:33:39


Question:
Which of the following database object can be used if you need to mail the invoice to customers?

1. A form

2.A query

3.A report

4.A table

Posted Date:-2021-02-19 08:33:39


Question:
Which of the following is not a form style available in the form wizard dialog box. 

1.Blends

2.Standard

3.Stone

4.Highlights

Posted Date:-2021-02-19 08:33:39


Question:
Which of the following SQL query deletes Product table from Store database?

1.DEL Product FROM Store

2.DROP Product

3. DROP TABLE Product

4.Any of b or c

Posted Date:-2021-02-19 08:33:39


Question:
You can enclose the prompt within square braces in criteria to create

1.Parameter query

2. Select query

3.Action query

4.Crosstab query

Posted Date:-2021-02-19 08:33:39


Question:
You can move between fields in a form by using any of these keys except

1.Tab

2.Enter

3.Shift+tab

4.Page up

Posted Date:-2021-02-19 08:33:39


More MCQS

  1. Computer fundamentals
  2. Computer Basic MCQS
  3. CCC MCQ Sample Paper 1
  4. CCC Exams MCQS Sample Paper Test 2
  5. Computer Basics MCQS Paper 1
  6. Computer Basics MCQS Paper 2
  7. FUNDAMENTALS OF COMPUTERS MCQs PART 2
  8. FUNDAMENTALS OF COMPUTERS MCQs PART 1
  9. FUNDAMENTALS OF COMPUTERS MCQs PART 3
  10. Computer mcqs smaple paper 1
  11. Computer mcqs smaple paper 2
  12. Computer mcqs smaple paper 3
  13. Fundamentals of Computers
  14. Fundamentals of Computers (New) Part 1
  15. Fundamentals of Computers (New) Part 2
  16. Computer Networks MCQ Questions
  17. Computer Networks Transition from IPV4 to IPV6
  18. Computer Fundamentals (New) Part 1
  19. Computer Fundamentals (New) Part 2
  20. Computer Fundamentals (New) Part 3
  21. Computer Fundamentals (New) Part 4
  22. Computer Fundamentals (New) Part 5
  23. Computer Fundamentals (New) Part 6
  24. Computer Fundamentals (New) Part 7
  25. Computer Fundamentals (New) Part 8
  26. Operating Systems MCQs Part 1
  27. Operating Systems MCQs Part 2
  28. OS(Computer Operating Systems) Part 1
  29. OS(Computer Operating Systems) Part 2
  30. OS(Computer Operating Systems) Part 3
  31. OS(Computer Operating Systems) Part 4
  32. OS - Computer Operating Systems Part 5
  33. OS - Computer Operating Systems Part 6
  34. OS - Computer Operating Systems Part 7
  35. MS Word MCQ Questions Part 1
  36. MS Word MCQ Questions Part 2
  37. MS Word MCQ Questions Part 3
  38. MS Word MCQ Questions Part 4
  39. MS Word MCQ Questions Part 5
  40. MS Word MCQ Questions Part 7
  41. MS Word MCQ Questions Part 6
  42. Microsoft Excel MCQ Questions Part 1
  43. Microsoft Excel MCQ Questions Part 2
  44. Microsoft Excel MCQ Questions Part 3
  45. Microsoft Excel MCQ Questions Part 4
  46. Microsoft Excel MCQ Questions Part 5
  47. Microsoft Excel MCQ Questions Part 6
  48. Microsoft Excel MCQ Questions Part 7
  49. MS PowerPoint MCQ Questions PART 1
  50. MS PowerPoint MCQ Questions PART 2
  51. MS PowerPoint MCQ Questions PART 3
  52. MS PowerPoint MCQ Questions PART 4
  53. MS PowerPoint MCQ Questions PART 5
  54. MS PowerPoint MCQ Questions PART 6
  55. MS PowerPoint MCQ Questions PART 7
  56. MS Access MCQ Questions Part 1
  57. MS Access MCQ Questions Part 2
  58. MS Access MCQ Questions Part 3
  59. MS Access MCQ Questions Part 4
  60. MS Access MCQ Questions Part 5
  61. MS Access MCQ Questions Part 6
  62. MS Access MCQ Questions Part 7
  63. MS Access MCQ Questions Part 8
  64. Query of MS Access MCQS Part 1
  65. Query of MS Access MCQS Part 2
  66. Data Structures and algorithms MCQ Questions
  67. Computer Communication and Networking Quiz
  68. Computer Graphics MCQ Quiz Questions and Answers
  69. Computer Basics Quiz Questions
  70. Computer Quiz Questions with Answers
  71. Computer Hardware MCQS Quiz
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!