TOP MS ACCESS Questions and Answers 2. MICROSOFT ACCESS Questions and Answers : -1. When a picture or other graphic image is placed in the report header section it will appear. Once in the beginning of the reportb. At the top of every pagec.

• MS Access has many built-in functions. This reference contains the string, numeric, and date functions in MS Access.
• Aggregate functions are used to compute against a.
• MS Access: DLast Function. This MSAccess tutorial explains how to use the Access DLast function with syntax and examples. Description. The Microsoft Access DLast.
• The examples in this topic demonstrate how to use the Average, Count, Max, Min, and Sum methods to query a DataSet and aggregate data using query expression syntax.
• Query Tutorials for MS Access SQL: Access Query examples for many complex SQL queries Access database programming.

Learn how to call a table function within the FROM clause of a SQL statement and have it return a result.

Every after record breakd. On the 1st and last pages of the report. Cascade delete optiona. None of above. 3. This data type allows alphanumeric characters and special symbols. None of the abovems access interview questions and answers.

Query design window has two parts. The upper part showsa.

Name of fields, field type and sizeb. Tables with fields and relationships between tablesc. Sorting check boxes. In a database table, the category of information is called .

Microsoft Access is a development environment used to create computer-based databases. To complement it, it ships with a programming language. There's also an XMLAGG function, which works on versions prior to 11.2.

SQL Tutorial SELECT Statement -- Extended Query Capabilities This subsection details the remaining features of SELECT statements. The basics are at SELECT Statement. How to count distinct records in MS Access. I was updating an Access application the other day and needed to get a distinct count of some records in an Access table.

All of above. 6. To create a new table, in which method you don’t need to specify the field type and size? Create table in Design Viewb. Create Table using wizardc.

Create Table by Entering datad. All of above. Q. What MCQ Set offers for the candidates of computer jobs exams? Downloads of MCQ Banksb. Huge collection of MCQ questionsc. Online MCQ quizd.

Subjective questions and answers. Which of the following is not a database object? Relationshipsd. In one- to- many relationship the table in . Child , Parentb. Parent , Childc. Brother , Sisterd. Father , Son. 9. The third stage in designing a database is when we analyze our tables more closely and create a .

None of these. 10. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command? Create Tabc. External Data Tabd. Database Tab. 11. This is the stage in database design where one gathers and lists all the necessary fields for the database project.

The two form layout types will display multiple records at one time are tabular and. The size of a field with Number data type can not bea. What MCQ Set offers for the candidates of computer jobs exams? Downloads of MCQ Banksb. Huge collection of MCQ questionsc. Online MCQ quizd. Subjective questions and answers.

A small button with three dots usually displayed at the right of field properties boxa. Make buttonb. Expression buttonc. Build buttond. None of above. The size of Yes No field is alwaysa. This key uniquely identifies each recorda.

The command center of access file that appears when you create or open the MS Access database file. Database Windowb.

Query Windowc. Design View Windowd. Switchboard. 18. A database language concerned with the definition of the whole database structure and schema is . All of above. 19. When creating a new table which method can be used to choose fields from standard databases and tablesa. Create table in Design Viewb. Create Table using wizardc.

Create Table by Entering datad. None of above. 20. What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table? A relationship is createdb. Edit relationship dialog box appearsc. Error occursd. Nothing happens. How can you define a field so that when entering data for that field it will display ****** instead of actual typed texta.

Input maskb. Validation Rulec. To sort records in a tablea. Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbarb. Open table, click Sort button on database toolbar, choose field based on which to sort, click OKc. Click the field heading to sort it ascending or descendingd. All of above. 23.

To create relationship between two tablesa. Any of above can be done to create relationship. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove? You need to delete the whole tabl. There is no method to remove a particular field only. Delete all the fields from third downwards and reenter the required fields again.

Select the third column in datasheet view then Deleted. Select the third row in table design view then Delete. To duplicate a controls formatting you can use. Which field type will you select when creating a new table if you require to enter long text in that field?

Hyperlink. 27. In table design view what are the first column of buttons used fora. Indicate Primary Keyb. Indicate Current Rowc.

Both of aboved. None of above. Q. What MCQ Set offers for the candidates of computer jobs exams? Downloads of MCQ Banksb. Huge collection of MCQ questionsc. Online MCQ quizd. Subjective questions and answers.

What does the show check box in query design window indicatea. It indicates whether the field is to be used or notb. It indicates whether the field is to be displayed in query result or notc. It indicates whether the field names to be displayed in query result or notd.

None of above. 29. Which of the following is not a type of relationship that can be applied in Access databasea.

One to Oneb. One to Manyc. Many to Manyd. All of above can be applied. This option allows you to build a new table by entering data directly into the datasheet. None of the above.

To create queries in Accessa. You can drag and drop fields on query buildersb. Install Msi Remote Computer Powershell.

You can use query wizard or design viewd. All of above. 32.

Following is not a database modela. Object Oriented database modeld.

In table design view, which key can be used to switch between the field names and properties panels? Which of the following is NOT a type of Microsoft Access database object? Worksheetsd. Which of the field has width 8 bytes? Hyperlink. 36. Which is not a view to display a table in Access? Datasheet Viewb. Design Viewc.

Pivot Table & Pivot Chart Viewd. None of above. 37. Which of the following database object hold data?

What MCQ Set offers for the candidates of computer jobs exams? Downloads of MCQ Banksb. Huge collection of MCQ questionsc. Online MCQ quizd.

Subjective questions and answers. Sub form sub reportb. Relationshipsc. Select objectsd. More controls. 39. The expression builder is an access tool that controls an expression. Which of the following database object produces the final result to present? The default and maximum size of text field in Accessa.

Charactersb. 8 and 1 GBc. None of above. 43. Cascade update optiona. Both of aboved. None of above.

You can set a controls border type to make the border invisible. Transparentb. Do not displayd. What MCQ Set offers for the candidates of computer jobs exams? Downloads of MCQ Banksb. Huge collection of MCQ questionsc.

Online MCQ quizd. Subjective questions and answers.

The database language that allows you to access or maintain data in a databasea. None of above. 46. Referential integrity meansa. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent tableb. Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent tablec. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child tabled.

All of above. 47. Character. 48. It is an association established between common fields of two tables. Which of the following is not a field type in Accessa. OLE Objectd. Lookup Wizard.

When entering field name, how many characters you can type in maximum? Any number of character. It is a database object to view, change, and analyze data in different waysa.

None of the above. Which of the following creates a drop down list of values to choose from a list? OLE Objectb. Lookup Wizard.

To achieve AND effect when you are entering criteria in a query design windowa. Write criteria values in same field separated with ANDd. Write criteria values in same field separated with & 5. A search value can be an exact value or it can bea.

Logical Operatorb. Relationshipc. Wild card characterd. Comparison operation. What are the columns in a Microsoft Access table called? What is a form in MS Accessa. It is a printed page where users will write their data to fill it upb.

It is an input screen designed to make the viewing and entering data easierc. This is an important part of database used by analysts to draw conclusionsd.

Aggregate function in SQL WHERE- Clause. You haven't mentioned the DBMS. Assuming you are using MS SQL- Server, I've found a T- SQL Error message that is self- explanatory: . The next one is more close. I guess it has to do with that the field customerid, GROUPed BY and used in the query- subquery join is in the first case PRIMARY KEY of the outer table and in the second case it's not.

Show all customer ids and number of orders for those who have 5 or more orders (and NULL for others): SELECT o. SELECT COUNT( o. customerid ). FROM account a. WHERE a. AND COUNT( o. customerid ) > = 5. GROUP BY o. customerid .