working with base objects Flashcards
a___ is a database object that help you to retrieve and view information from one or more database tables that meet a specific condition.
query
In a query,the ____ is used to set the condition on the basis of which the records are filtered.
criterion
You can set multiple criteria in a query using the_______.
or property
The ________ property is used to filter the data either in an ascending or descending order.
sort
The bottom pain of the query window displace the _____.
design grid
a ______ is an effective way to organise and summarise data in a printed form.
report
True or false- forms help you to retrieve information from one or more tables that meet a specific condition.
false
True or false- the Sort property is used to filter the data only in descending order.
false
True or false - a relationship works by matching a field with the same name in two tables
true
True or false - once a relationship is set, it cannot be deleted.
false
True or false - a static report generates the result of the report from the current table data.
true
Which wild card character matches any single alphabetic character when used anywhere in a character string
?
Which property allows the user to specify the user- defined name for any column?
alias
Which button is used to run a query without saving it?
run query
In how many ways can a form be generated?
2
Which wild card character matches any single character with is given in brackets?
[ ]
Swati’s class teacher has to extract all the records of the students who have either obtained for French or German. Which property in design grade should she use?
criterion ,or property has to be used
Johnson and Johnson company has a huge database of employees. In the privacy of each employee and has instructed the computer operators to update each record, time. Database object should they used to perform this task?
form has to
