Which one of these is the most common type of query that retrieves records from one or more tables and then displays the result in tabular form ? December 25, 2021December 25, 2021 administrator A. Tabular QueryB. Crosstab QueryC. Select QueryD. Pivot Query Share the Post Share the Post
When creating a new table which method can be used to choose fields from standard databases and tables December 25, 2021December 25, 2021 administrator A. CreateTable In Design ViewB. CreateTable Using WizardC. CreateTable by entering dataD. None of Above Share the Post Share the Post
Which of the following database object hold data? December 25, 2021December 25, 2021 administrator A. FormsB. ReportsC. QueriesD. Tables Share the Post Share the Post
Which data type should we use if we are planning to store a couple of paragraph or detailed description in a field? December 25, 2021December 25, 2021 administrator A. TextB. ParaC. MemoD. Desc Share the Post Share the Post
Which field type can store photos? December 25, 2021December 25, 2021 administrator A. HyperlinkB. OLE ObjectC. Both can be usedD. It is not possible Share the Post Share the Post
What is the shortcut key to switch between the field names and properties panels in table design view? December 25, 2021December 25, 2021 administrator A. F3 KeyB. F4 KeyC. F5 KeyD. F6 Key Share the Post Share the Post
Which option allows us to build a new table by entering data directly into a tabular grid ? December 25, 2021December 25, 2021 administrator A. Datasheet ViewB. Design ViewC. LinkedTableD. Grid View Share the Post Share the Post
How can we create a query in Microsoft Access ? December 25, 2021December 25, 2021 administrator A. Drag and drop fieldsB. Type the SQLC. Use query wizardD. All of above Share the Post Share the Post
If you write criteria values one in a row in query design window, that means you are specifying _____ December 25, 2021December 25, 2021 administrator A. OR conditionsB. AND conditionsC. NOT conditionD. ALL conditions Share the Post Share the Post
Which of the following is a method to create a new table in MS Access? December 25, 2021December 25, 2021 administrator A. Using Design ViewB. CreateTable WizardC. Directly Entering DataD. All of Above Share the Post Share the Post