Short answer type questions.
(1)How would you add a field in Design view of a table?
(2)After entering all fields required for a table, if you realise that the there is a field not required, how will you remove it?
(3)What is Sorting of data? How is it done in Access?
(4) How can you navigate through different records in a table?
(5) How can you search for those names in the table that have "Kumar" anywhere in their names?
(6)How can you display only the records of students who can vote, i.e., those who have an age field value of 18 or above?
(7)How can you display the list of employees whose salary is greater than ₹50,000?
(8) What is a filter? How is it applied on a field in a table?
(9) What is Criteria of a query? Explain with the help of two examples.
Answers
1. On the Home tab, in the Views group, click View, and then click Design View. In the table design grid, select the field or fields that you want to use as the primary key. To select one field, click the row selector for the field that you want.
2. Delete all the fields from third downwards and reenter the required fields again.
3. When you sort records, you are putting them into a logical order, with similar data grouped together. As a result, sorted data is often simpler to read and understand than unsorted data. By default, Access sorts records by their ID numbers.
4. To navigate through records in a table, you can use the up and down arrow keys, scroll up and down, or use the arrows in the Record Navigation bar located at the bottom of your table. You can create a new record with the new (blank) record command on the Record Navigation bar.
5. Syntax (When we have only single database): Select * from schema_name.table_name.
Syntax (When we have multiple databases): Select * from database_name.schema_name.table_name.
Example: SELECT * FROM INFORMATION_SCHEMA.TABLES.
WHERE.
INFORMATION_SCHEMA. ...
Output:
6.Critics of giving citizens under 18 the right to vote argue that such teenagers lack the ability and motivation to participate effectively in elections. If this argument is true, lowering the voting age would have negative consequences for the quality of democracy. We test the argument using survey data from Austria, the only European country with a voting age of 16 in nation-wide elections. While the turnout levels of young people under 18 are relatively low, their failure to vote cannot be explained by a lower ability or motivation to participate. In addition, the quality of these citizens' choices is similar to that of older voters, so they do cast votes in ways that enable their interests to be represented equally well. These results are encouraging for supporters of a lower voting age.
7. this article, we will discuss the overview of SQL query and our main focus will be on how to Find an Employee whose salary is equal to or greater than a specific number in SQL with the help of examples. Let’s discuss it one by one.
8. Use filters to temporarily hide some of the data in a table, so you can focus on the data you want to see. ...
9. A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query.