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

Related MCQs

• The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
• In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
• You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
• If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
• How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
• What is the type of query that extracts data from a table and puts them into separate table?
• This option allows you to build a new table by entering data directly into the datasheet.
• In Datasheet View, new records are added to a table ____.
• A query prompts a user for a data and then displays only records that contain the specified date. The type of of query is this
• A query summarizes information in a grid, organized by regions and months. Which type of query is this?