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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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