Fill in the blanks:
- The DBMS software involves creating, modifying, deleting, and adding data in a database.
- Primary key is a column whose value uniquely identifies every row in a table.
- The commands available in FILE menu are Info, New, Open, Save, Save As, etc.
- To do mathematical calculations, click Totals in the Records group on the HOME tab.
- To remove a filter, click Toggle Filter in the Sort & Filter group on the HOME tab.
State whether True or False. Correct the false statement(s):
- You can create a database either using a template or from scratch. (True)
- The extension of a database file in Access is .accdb. (True)
- The first field in a new table is the ID field, which is a primary key. (True)
- A database can have only one table. (False) (We can have multiple tables in a database)
- Once filtering is applied, you cannot remove it. (False) (We can remove it by selecting the Select All option)
Choose the correct option:
Q1. The columns in an Access table are also known as:
Q2. Which of the following is not a database object?
Q3. What is the maximum length of the Short Text data type?
Q4. When you create a blank database, it has ________ table(s) by default.
Q5. In the Datasheet View, which of the following is possible?
a) Freezing/Unfreezing fields
b) Hiding/Unhiding fields
c) Moving fields
d) All of these
Answer the following:
Q1. What is a database? Name any one database management software.
A database is an organized collection of information or data. Example: MySQL.
Q2. How are records different from fields?
A record is information about an entity stored in a row.
A field is a column in a table that contains a specific information about the record.
Q3. Explain any two functions of a DBMS.
a) DBMS helps in reduction or elimination of data redundancy. Data redundancy means duplication of data.
b) DBMS provides data security.
Q4. What is a primary key?
Primary key is the field that uniquely identifies every record in a table.
Q5. What are the rules for naming a field?
a) A field can be from 1 to 64 characters long.
b) A field name can include letters, numbers, and some special characters (like underscore).
c) A field name cannot have a period, an exclamation mark, brackets or accent grave.
d) A field name cannot start with a blank space.
e) A field name can be in upper, lower, or mixed case.
Q6. List the various data types available in Access 2013.
Short Text, Long Text, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment, Calculated are the various data types present in Access 2013.
Q7. Name the various database objects.
Table, Form, Query, Report, Macro and Module are the various database objects.
Q8. What is the difference between hiding a field and freezing it?
Freezing a table makes it easier to see the entire set of fields in a table when scrolling right. Hiding a field allows us to temporarily hides a field in a given table.