Question

Filter method to filter records based on criterion you specify?

• A. Filter by selection
• B. Filter by criterion
• C. Filter by data
• D. Filter by form

Answer 1

Answer:

D. Filter by form

Relationship

• A relationship is an associate between Access tables or queries that use related fields
• Mechanism developed to enforce users to enter data in required format is : Input mask
• The raw facts and figures are: Data
• The feature that database allows to access only certain records in database is: Queries
• Filter method which allows us filter the records that match the selected field : Filter by selection
• Filter method to filter records based on criterion you specify? Filter by form
• We can find Sort & Filter group of commands in – Home ribbon
• Advanced filter method is not available in Access.
• By Grouped Report you understand

               Type of report that displays data grouped by fields you specified

• The text we typed in Description column in Table Design View is displayed on 

               Status bar while entering data

• The maximum allowed field size for Boolean (Yes/No) fields : 1
• The size of Date & time field type : 8 bytes