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

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

1 Answer

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.”
by

Related questions

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.

Which field property sets limits on the data that is entered? -Technology

Description : Which field property sets limits on the data that is entered? -Technology

Last Answer : Fixed Field Length or Field Size property sets the limits on the data entered.

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.

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.

If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology

Description : If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology

Last Answer : False It will be treated as non-numeric data because it contains letters along with numbers.

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.

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.

If = 6 _5 *2 is entered in a cell, then what will be the cell content? -Technology

Description : If = 6 _5 *2 is entered in a cell, then what will be the cell content? -Technology

Last Answer : -4 will be contained in the cell as a result.

In a spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology

Description : In a spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology

Last Answer : Need Answer

Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology

Description : Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology

Last Answer : In Excel, every formula must start with a = (equal) sign.Since Sana has not put = sign before 49+30, thus she is not able to see the desired result will be displayed if she will use = (49 + 30) formula.

In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology

Description : In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology

Last Answer : In cell K15, enter the conditional statement as: = IF (K12 > 300, K12 *1.33, K12 * 1.5). Here, IF condition checks the value at K12, that is, if it is greater than 300, then calculate 1.33 of K12, otherwise 1.5 of K12.

In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Description : In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Last Answer : UPDATE Student SET Marks = 50 WHERE Roll number = 2;

How are field types Text and Memo different from each other? -Technology

Description : How are field types Text and Memo different from each other? -Technology

Last Answer : Distinguishing between Text and Memo are as follows:TextMemoIt is used for relatively short entries.It is used for long text paragraphs.It can storeupto255 characters only.It can storeupto65536 characters. ... number of characters.It does not use field size property.e.g. Emp_namee.g. Emp_description

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.

Write java statement to make the Net Fee text field named txtNetFee un_editable at run time. -Technology

Description : Write java statement to make the Net Fee text field named txtNetFee un_editable at run time. -Technology

Last Answer : txtNetFee.setEditable(false);

What happens, if you do not enter a caption for a field? -Technology

Description : What happens, if you do not enter a caption for a field? -Technology

Last Answer : In this case, Field Name is used as a label.

A Text data type cannot allow number entry. -Technology

Description : A Text data type cannot allow number entry. -Technology

Last Answer : False As, it can include both text as well as numbers.

Plain text (txt) E_mail messages can be read by any type of E_mail application. -Technology

Description : Plain text (txt) E_mail messages can be read by any type of E_mail application. -Technology

Last Answer : True Plain text E-mail contains plain text without any formatting options such as bold, italic, colored fonts etc., so these can be read by any type of E-mail application.

To display the text in italics, ………. tag is used and to display in type writer font, ……… tag is used. -Technology

Description : To display the text in italics, ………. tag is used and to display in type writer font, ……… tag is used. -Technology

Last Answer : To display the text in italics,tag is used and to display in typewriterfont, tag is used.

Automatic formatting that the user wants? (a) Replace text As You Type (b) AutoFormat As You Type -Technology

Description : Automatic formatting that the user wants? (a) Replace text As You Type (b) AutoFormat As You Type -Technology

Last Answer : (b) For turning Automatic formatting On or Off, AutoFormat As You Type tab under Proofing is used.

AutoFormat settings are applied in a document (a) as we type text (b) after we finish typing (c) Both (a) and (b) (d) None of the above -Technology

Description : AutoFormat settings are applied in a document (a) as we type text (b) after we finish typing (c) Both (a) and (b) (d) None of the above -Technology

Last Answer : (c) AutoFormat settings are applied in a document as we type text or after we finish typing.

Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Description : Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Last Answer : He can create a text file using Notepad or WordPad. Follow these steps to create a file using Notepad:(a) Step 1:Click Start.(b) Step 2:Choose All Programs -> Accessories -> Notepad.(c) Step 3: ... dialog box will appear.(g) Step 7:Give file name with extension.(h) Step 8: Click Save button.

What is the default alignment of number, text and formula in a spreadsheet? -Technology

Description : What is the default alignment of number, text and formula in a spreadsheet? -Technology

Last Answer : Default alignment of text or label entry is left alignment and for numbers and formula, it is right alignment.

…………. are text, number cell references enclosed within parenthesis in a formula. -Technology

Description : …………. are text, number cell references enclosed within parenthesis in a formula. -Technology

Last Answer : Argumentsare text, number cell references enclosed within parenthesis in a formula.

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.

A blog consists of (a) images (b) text (c) links (d) All of these -Technology

Description : A blog consists of (a) images (b) text (c) links (d) All of these -Technology

Last Answer : (d) A blog consists of images, text and links.

Why we cannot use a text editor as a picture editing tool? -Technology

Description : Why we cannot use a text editor as a picture editing tool? -Technology

Last Answer : Text editor is a editing program which does not support the editing of graphical images because it works only on text.

………… elements help to express emotions or feelings in E_mail or text messages. -Technology

Description : ………… elements help to express emotions or feelings in E_mail or text messages. -Technology

Last Answer : Emoticon elements help to express emotions or feelings in E-mail or text messages.

E_learning only supports text materials. -Technology

Description : E_learning only supports text materials. -Technology

Last Answer : False E-learning includes numerous types of media that deliver text, audio, images, animation and streaming videos.

Which of the following is not related to a utility software? (a) Text editor (b) Antivirus program (c) Disk compression software -Technology

Description : Which of the following is not related to a utility software? (a) Text editor (b) Antivirus program (c) Disk compression software -Technology

Last Answer : (d) Railway reservation system is an example of application software whereas, rest all are software utilities.

A text editor is used to facilitate the creation and correction of text. -Technology

Description : A text editor is used to facilitate the creation and correction of text. -Technology

Last Answer : TrueA text editor is used to create and edit the text. Text editor is a part of utility.

Encrypted data is referred as cipher text. -Technology

Description : Encrypted data is referred as cipher text. -Technology

Last Answer : TrueEncrypted data is presented in coded form. So, it is known as cipher text.

Distinguish between Text and Memo data types. -Technology

Description : Distinguish between Text and Memo data types. -Technology

Last Answer : Distinguishing between Text and Memo are as follows:TextMemoIt is used for relatively short entries.It is used for long text paragraphs.It can store upto 255 characters only.It can store upto 65536 ... the number of characters.It does not use field size property.e.g. Emp_namee.g. Emp_description

Explain the following statement: <BODY bgcolor=“yellow” text =“red” vlink=“blue”> -Technology

Description : Explain the following statement: -Technology

Last Answer : The code will set the Web page background color as yellow, text color as red and visited link color as blue.

How would you display text in the title bar of a browser? -Technology

Description : How would you display text in the title bar of a browser? -Technology

Last Answer : To display text in a title bar of a browser, use the tag inside the tag in the HTML document.e.g. HTML document

Which tag do we use to change the size and style (face) of the text of an HTML file viewed on a Web browser? -Technology

Description : Which tag do we use to change the size and style (face) of the text of an HTML file viewed on a Web browser? -Technology

Last Answer : tag is used to change the size and style (face) of the text of an HTML file displayed on a Web browser. Two attributes of tag are as follows:size: It specifies the size of the text inside a tag.Syntaxface: It specifies the font name of the text inside a tag.Syntax

Write the HTML code to set the bgcolor as pink, heading level 2, text -Technology

Description : Write the HTML code to set the bgcolor as pink, heading level 2, text -Technology

Last Answer :

Write the HTML code to create a paragraph whose text color is blue. -Technology

Description : Write the HTML code to create a paragraph whose text color is blue. -Technology

Last Answer : or

Which of the following is a component of multimedia? (a) Text (b) Images (c) Audio (d) All of these -Technology

Description : Which of the following is a component of multimedia? (a) Text (b) Images (c) Audio (d) All of these -Technology

Last Answer : (d) Text, images, audio all are the components of multimedia.

Interactive combination of text, graphics, images, audio, video etc., is known as (a) Data (b) Information (c) Multimedia (d) Internet -Technology

Description : Interactive combination of text, graphics, images, audio, video etc., is known as (a) Data (b) Information (c) Multimedia (d) Internet -Technology

Last Answer : (c) Multimedia is a interactive combination of text, animations, sounds, images etc.

The content like audio, video and animation alongwith text is called (a) Hypertext (b) Multimedia (c) Hypermedia (d) None of these -Technology

Description : The content like audio, video and animation alongwith text is called (a) Hypertext (b) Multimedia (c) Hypermedia (d) None of these -Technology

Last Answer : (c) An extension of hypertext is called hypermedia. Hypertext is based on textual links while hypermedia includes text, audio, images, sounds etc.

To create an HTML page, you need (a) text editor (b) Web browser -Technology

Description : To create an HTML page, you need (a) text editor (b) Web browser -Technology

Last Answer : (c) Because text editor is required to write HTML code and the Web browser is needed to display the page.

Tags and text that do not display directly on the page afe placed in (a) body (b) table -Technology

Description : Tags and text that do not display directly on the page afe placed in (a) body (b) table -Technology

Last Answer : (c) Information in tag is not displayed directly in the Web page. It is used to identify the matter (tags) used in a Web page.

Which section is used for text and tags that are shown directly on your Web pages? -Technology

Description : Which section is used for text and tags that are shown directly on your Web pages? -Technology

Last Answer : (c) Information in tag is directly displayed on Web pages.

Multimedia is an integration of sound, images, text, animation etc. -Technology

Description : Multimedia is an integration of sound, images, text, animation etc. -Technology

Last Answer : TrueMultimedia is a combination of several media like sound, hypertext, image and animation etc

Which of the following will give smallest size of the text? (a) <H3> -Technology

Description : Which of the following will give smallest size of the text? (a) -Technology

Last Answer : (b) From the given options, tag displays the smallest size of the heading text.

Which of the following HTML container tags do you apply to text for formatting the text as a paragraph? -Technology

Description : Which of the following HTML container tags do you apply to text for formatting the text as a paragraph? -Technology

Last Answer : (c) ……. is a container tag, which is used for formatting text.

……….. tag is used to bring the text to new line. -Technology

Description : ……….. tag is used to bring the text to new line. -Technology

Last Answer : tag is used to bring the text to new line.