To create queries in Access
You can drag and drop fields on query builders
you can type the SQL command in SQL view
You can use query wizard or design view
All of above
Also checkout these categories
Adobe Flash MCQ Fungi and Lichens MCQ Photo-Chemistry MCQ Course of Action MCQ Strength of Materials MCQ IBPS Common Written Exam (PO/MT) Main 2016 Solved Paper MCQ Botany MCQ Motion MCQ Compound Interest MCQ Reproductive System MCQ Thermo Electricity MCQ Kidney cysts and tumors MCQ
- Which is not a view to display a table in Access?
- After entering all fields required for a table, if you realize that the third field is not needed, how…
- The task of arranging data in order is called
- While creating relationship, when you drag a field of a field to drop into another table the mouse pointer…
- If I create Student field in Fees table to store student_id of Students table, then this Student field…
- Which of the following is not a database object?
- An Access database object that is used to enter, view or edit records
- A composite key is
- To create primary key for a table when in design view
- When creating a new table which method can be used to choose fields from standard databases and tables
- Collection of related records in a database is known as
- Which of the following creates a drop down list of values to choose from a list?
- In table design view, which key can be used to switch between the field names and properties panels?
- We can remove a relationship defined between two tables by
- It is a database object to view, change, and analyze data in different ways
- Which of the following database object hold data?
- Queries in Access can be used as
- In one-to-many relationship the table in one side is called _______ and on many side is called _______
- A __ name must be unique within a database
- You can set a controls border type to make the border invisible.
- To create relationship between two tables
- Each record is constituted by a number of individual data items which are called
- The size of a field with Number data type can not be
- You can automatically include all of the field in a table in a query by___ a strike that appear list…
- Which of the field has width 8 bytes?
- Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…
- We can remove a relationship defined between two tables by
- To create queries in Access
- Which of the following is a method to create a new table in MS Access?
- Which of the following may not be a database?