Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology
by

1 Answer

Answer :

(d) From the given options Field Name, Field Type Primary Key are the part of a table.
by

Related questions

Is it necessary to define a field type for a field in MS_Access? -Technology

Description : Is it necessary to define a field type for a field in MS_Access? -Technology

Last Answer : Yes, it is necessary to define a type of a field while entering data into a field.

What is the use of AutoNumber type field used in MS_Access? -Technology

Description : What is the use of AutoNumber type field used in MS_Access? -Technology

Last Answer : AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.

A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

What is the default extension of a MS_Access database? -Technology

Description : What is the default extension of a MS_Access database? -Technology

Last Answer : The default extension of an MS-Access database is .accdb.

Give five names of database templates used in MS_Access 2007. -Technology

Description : Give five names of database templates used in MS_Access 2007. -Technology

Last Answer : Assets, Contacts, Events, Faculty and Issues.

Give the names of five data types used in MS_Access. -Technology

Description : Give the names of five data types used in MS_Access. -Technology

Last Answer : Text, Memo, Date/Time, Yes/No and Currency.

What are the views in which fields can be deleted in MS_Access? -Technology

Description : What are the views in which fields can be deleted in MS_Access? -Technology

Last Answer : Datasheet View and Design View.

How will you create a blank database in MS_Access 2007? -Technology

Description : How will you create a blank database in MS_Access 2007? -Technology

Last Answer : Creating a Blank DatabaseTo create a new blank database, you need to perform the steps which are as follows:Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will ... in the first empty cell in the Add New Field column as shown in the following figure:

Explain MS_Access Ribbon. -Technology

Description : Explain MS_Access Ribbon. -Technology

Last Answer : The Ribbon contains a series of command tabs. In MS-Access 2007, the main command tabs are as follows: Home Create External Data Database Tools DatasheetCommand TabCommon Things You ... columns of the table.Set the data type and formatting.Create table relationships and object dependencies.

Define primary key. How do you set it in MS_Access? -Technology

Description : Define primary key. How do you set it in MS_Access? -Technology

Last Answer : Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:Step 1 Select the field that you want ... 2 Click Primary Key button from the Design tab.orRight click on the selected field and select Primary Key.

In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.

The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.

When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Description : When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Last Answer : False Because ribbon appears on the top of the window.

What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Last Answer : (b) Number data type should be chosen for a zip code field in a table.

To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Description : To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Last Answer : To store object like image, you need to create a field in a table, having field type as OLE Object.

Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);

Write SQL query to create a table “Registration” with the following structure: -Technology

Description : Write SQL query to create a table “Registration” with the following structure: -Technology

Last Answer : Create table Registration(Reg_Id Integer(2) Primary Key,Name varchar(20),Course varchar(10),Join_Dt date);

Write SQL query to create a table Inventory with the following structure : -Technology

Description : Write SQL query to create a table Inventory with the following structure : -Technology

Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :

Write SQL query to create a table Player with the following structure : -Technology

Description : Write SQL query to create a table Player with the following structure : -Technology

Last Answer : CREATE TABLE Player(};

Distinguish between a record and a field in a table, with an example. -Technology

Description : Distinguish between a record and a field in a table, with an example. -Technology

Last Answer : Distinguish between a record and a field in a table are as follows:RecordFieldIt is a collection of data items, which represent a complete unit of information about a thing or a person.It is an ... called a record.e.g. if Employeeis a table, then empId, empName, department, salary arethe fields.

Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Description : Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Last Answer : (b) Date of birth is the most appropriate data field in the context of the employee table.

A field in a table is also called as ………………… . -Technology

Description : A field in a table is also called as ………………… . -Technology

Last Answer : A field in a table is also called ascolumn.

Which field property helps in setting data validation in a table? -Technology

Description : Which field property helps in setting data validation in a table? -Technology

Last Answer : (d) Validation Rule property specifies a condition that must be met before the data is accepted into the database.

When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Description : When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Last Answer : (d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.

………….. is the smallest part of a table in which one data item can be kept. -Technology

Description : ………….. is the smallest part of a table in which one data item can be kept. -Technology

Last Answer : Fieldis the smallest part of a table in which one data item can be kept.

The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla. -Technology

Description : The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla. -Technology

Last Answer : 1. Number of fields-62. Number of records-73. If a new child joins the SummerCamp, then SummerCamp would add a record to the table.4. If a child is shifted from one group to another, then ... the SummerCamp, then SummerCamp would delete a record of that child from the table.6. Text and Date/Time.

The <thead> tag is used to specify the………..part of the table. -Technology

Description : The tag is used to specify the………..part of the table. -Technology

Last Answer : The tag is used to specify the headerpart of the table.

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

Memo data type allows you to store character type values in a table. -Technology

Description : Memo data type allows you to store character type values in a table. -Technology

Last Answer : True Memo data type allows upto 65536 characters.

Memo data type allows you to store only 255 characters in the table. -Technology

Description : Memo data type allows you to store only 255 characters in the table. -Technology

Last Answer : False Memo data type is used when character size is more than 255.

If you type <table border='2'> <tr align='center”> -Technology

Description : If you type

Last Answer : The output will look like

Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)

While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.

What happens when you enter numbers in a Text data type field? -Technology

Description : What happens when you enter numbers in a Text data type field? -Technology

Last Answer : Numbers are accepted as a text value.

What happens when text is entered in a Number type field? -Technology

Description : What happens when text is entered in a Number type field? -Technology

Last Answer : When we enter text in a Number field and press Enter or press Tab key, MS-Access displays a message that “The value you entered does not match the Number data type in this column.”

For which type of field, “Default Value” property is not applicable? -Technology

Description : For which type of field, “Default Value” property is not applicable? -Technology

Last Answer : Attachment, AutoNumber, OLE Object.

If the data type of a field is set to Text, what will be its number range? -Technology

Description : If the data type of a field is set to Text, what will be its number range? -Technology

Last Answer : Its range will be 0 to 255.

When Memo data type is preferred over Text type for a field? -Technology

Description : When Memo data type is preferred over Text type for a field? -Technology

Last Answer : When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length cannot be more than 255 characters so, Memo data type is preferred over the Text data type.

Write one example of each field, for which you would use 1. Text data type -Technology

Description : Write one example of each field, for which you would use 1. Text data type -Technology

Last Answer : 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don't require calculations such as phone number. This data type allows maximum 255 characters ... Description will be of Memo data type, because the length of description of employee may be large.

Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Description : Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Last Answer : Distinguishing between Number and AutoNumber dataNumberAutoNumberIt holds numeric values whichare used for calculations.It allows to store numbers thatare automatically generatedfor each record.The field ... for every newcustomer, this field willautomatically increase and willprovide a new number.

The default data type for a field is (a) Number (b) AutoNumber -Technology

Description : The default data type for a field is (a) Number (b) AutoNumber -Technology

Last Answer : (d) The default data type for a field is Text.

For storing lengthy information in a field ………….. data type is used. -Technology

Description : For storing lengthy information in a field ………….. data type is used. -Technology

Last Answer : For storing lengthy information in a field Memodata type is used.

In a Text type data field, we can enter a maximum of ………….. characters. -Technology

Description : In a Text type data field, we can enter a maximum of ………….. characters. -Technology

Last Answer : In a Text type data field, we can enter a maximum of 255characters.

Write the relationship between a database and a table. -Technology

Description : Write the relationship between a database and a table. -Technology

Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.

Name two possible primary keys for an Employee table. -Technology

Description : Name two possible primary keys for an Employee table. -Technology

Last Answer : Possible primary keys for an Employee table are emp code, emp phone number.

How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Description : How are fields, record and a table related to each other? Explain with the help of an example. -Technology

Last Answer : Fields are one type of information. A record contains logically related fields. A table Emp name contains logically related records.Emp NoNameSalary1.Shridhar200002.Raghav40000Here EmpNo, Name, and Salary are three different fields. 1, Shridhar, 20000 represents one complete record.

What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Description : What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Last Answer : Distinguish between data and information are as follows:DataInformationIt is a raw fact.It is a process form of data.It considers facts symbols, images for reference or analysis.It considers knowledge derived from study, experience or instruction.e.g. 23 is data.e.g age = 23 is information

A table named School (containing data of students of the whole school) is created -Technology

Description : A table named School (containing data of students of the whole school) is created -Technology

Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.

Consider the following table: Employee EmpNo EmpName Designation -Technology

Description : Consider the following table: Employee EmpNo EmpName Designation -Technology

Last Answer : 1. EmpNo can be selected as a primary key.2. EmpName is having unique values, but there is no guarantee that if more employees are included then there would not be multiple people with similar names.So, in future, its values may be duplicate. Thus, it cannot be made as a primary key.

Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Description : Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Last Answer : Primary key AccountNoCandidate key AccountNo and PAN NumberAlternate key PAN Number