How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology
by

1 Answer

Answer :

NUMBER data type contains numeric values, while DATE/TIME type field contains date and time values.
by

Related questions

Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Description : Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Last Answer : (b) From the given options, the data field can not be set as a primary key because it can’t be fixed for an object.

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.

A ……… is a group of related fields. -Technology

Description : A ……… is a group of related fields. -Technology

Last Answer : A databaseis a group of related fields.

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.

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.

Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code. -Technology

Description : Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code. -Technology

Last Answer : (i) GREEN WORLD, CLEAN WORLD76 more characters can be entered(ii)length(),toUpperCase()

Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Description : Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Last Answer : This is because the column commission contains a NULL value and the aggregate functions do not take into account NULL values. Thus Command1 returns the total number of records in the table whereas Command2 returns the total number of non NULL values in the column commission.

What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Description : What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Last Answer : A template is a complete tracking application with predefined tables, forms, reports, queries, macros, and relationships. Each template creates a complete end-to-end solution that you can use ... to create a projects tracking database to track multiple projects and assign tasks to different people.

Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Description : Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Last Answer : Field PropertiesAfter you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality.Some ... control.Text, Memo, Number,Date/Time, Currency,AutoNumber, Yes/No, OLEObject, Hyperlink.

Define the AutoNumber data type in MS_ Access. -Technology

Description : Define the AutoNumber data type 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.

Which of the following is not a data type? (a) Picture/Graphic (b) Date/Time -Technology

Description : Which of the following is not a data type? (a) Picture/Graphic (b) Date/Time -Technology

Last Answer : (a) From the given options Date/Time, Text and Number are the data types.

When camping how much civilization or technology should one have access to before it is no longer camping?

Description : When camping how much civilization or technology should one have access to before it is no longer camping?

Last Answer : I swear I was at a campground once where a pizza was delivered to one of the campsites.

In Random Access Memory if current will be interrupted, data will not lost. -Technology

Description : In Random Access Memory if current will be interrupted, data will not lost. -Technology

Last Answer : FalseRandom Access Memory (RAM) is a volatile memory, if current is interrupted, data will lost.

A magnetic tape is a direct access storage device. -Technology

Description : A magnetic tape is a direct access storage device. -Technology

Last Answer : FalseIt is a non-volatile memory hence, it is not direcdy accessible by the CPU.

Microsoft Access is an example of (a) Computer -Technology

Description : Microsoft Access is an example of (a) Computer -Technology

Last Answer : (b) MS-Access is the DataBase Management System (DBMS) found in the Microsoft Office suite.

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.

Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Description : Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Last Answer : Microsoft Office Access 2007 includes a set of database templates which are designed for specific business needs.

Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Description : Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Last Answer : (c) From the given options, Notepad is useful program to write HTML code.

……… is not covered under file management. (a) Secure files (b) Easy access to files (c) Schedule processes (d) Keep backup of files -Technology

Description : ……… is not covered under file management. (a) Secure files (b) Easy access to files (c) Schedule processes (d) Keep backup of files -Technology

Last Answer : (c) Because schedule processes comes under processor management.

………….. is a visual desktop experience which provides an easy way to access desktop. -Technology

Description : ………….. is a visual desktop experience which provides an easy way to access desktop. -Technology

Last Answer : Aero is a visual desktop experience which provides an easy way to access desktop.

A good way to safeguard access to your computer is to protect it. (a) Deadbolt -Technology

Description : A good way to safeguard access to your computer is to protect it. (a) Deadbolt -Technology

Last Answer : (d) Password is a good way to safeguard access to your computer to protect it.

Making backups, keeping passwords and having access control are used for ………….. (a) Data security -Technology

Description : Making backups, keeping passwords and having access control are used for ………….. (a) Data security -Technology

Last Answer : (a) Backups, access authorised are the techniques to secure data from damage and getting lost.

A good way to safeguard access to your computer is to _________ protect it. -Technology

Description : A good way to safeguard access to your computer is to _________ protect it. -Technology

Last Answer : A good way to safeguard access to your computer isPasswordto protect it.

Random Access Memory and Read Only Memory are examples of ____________. -Technology

Description : Random Access Memory and Read Only Memory are examples of ____________. -Technology

Last Answer : Random Access Memory and Read Only Memory are examples ofPrimary Memory.

To prevent unauthorized access to and / or from the network, a system known as ......., can be implemented -Technology

Description : To prevent unauthorized access to and / or from the network, a system known as ......., can be implemented -Technology

Last Answer : To prevent unauthorized access to and / or from the network, a system known as Firewall, can be implemented by hardware and / or software.

In the <td> tag, td stands for (a) Table Data (b) Table Time and Date -Technology

Description : In the tag, td stands for (a) Table Data (b) Table Time and Date -Technology

Last Answer : (a) td stands for Table Data.

Date and Time are the part of (a) Tool Bar (b) Icon (c) Taskbar (d) Status Bar -Technology

Description : Date and Time are the part of (a) Tool Bar (b) Icon (c) Taskbar (d) Status Bar -Technology

Last Answer : (c) Date and Time are the part of taskbar which is found at the bottom of the screen.

We cannot enter the date/time in a cell. -Technology

Description : We cannot enter the date/time in a cell. -Technology

Last Answer : False Date/time can be added to an Excel cell.

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology

Description : Consider the following database: Product Code Product Name Date of sale QtySold Customer Name Amount -Technology

Last Answer : 1. Qty Sold and Amount fields2. ProductCode field3. Date/Time data type4. ProductCode, ProductName and CustomerName fields5. 6 fields and 5 records6. Validation Rule

The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Description : The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Last Answer : (d)Aggregate Function

Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology

Description : Consider a table SALESMAN with the following data: SNO SNAME SALARY BONUS DATE OF JOIN A01 Beena Mehta 30000 45.23 29_10_2019 A02 K. L. -Technology

Last Answer : alternative answer

Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Description : Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Last Answer : (i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)

What information should be recorded as a minimum, on a completed production weld? a) Size and type of electrode and b) Welding supervisor’s name c) Welder’s Identification, date and weld number d) Welding inspectors name

Description : What information should be recorded as a minimum, on a completed production weld? a) Size and type of electrode and b) Welding supervisor’s name c) Welder’s Identification, date and weld number d) Welding inspectors name

Last Answer : c) Welder’s Identification, date and weld number

What is multiple cropping? (a) When seeds are sown on a piece of land and then seedings are transplanted in different fields (b) Dividing a field in two or more parts and then sowing different crops in each part (c) Raising in succession only one type of crop in the same piece of land (d) Raising two or more crops in succession in a year on the same land

Description : What is multiple cropping? (a) When seeds are sown on a piece of land and then seedings are transplanted in different fields (b) Dividing a field in two or more parts and then sowing different crops in ... same piece of land (d) Raising two or more crops in succession in a year on the same land

Last Answer : Ans: (b)

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.

Medicine technology have applications in the fields of i) Pharmacy ii) Prosthetics iii) Both A & B iv) None of these

Description : Medicine technology have applications in the fields of i) Pharmacy ii) Prosthetics iii) Both A & B iv) None of these

Last Answer : iii) Both A & B

Give any one difference between freezing a field and hiding a field. -Technology

Description : Give any one difference between freezing a field and hiding a field. -Technology

Last Answer : When you freeze a field, then no matter how far you scroll down in a datasheet, you will always see the frozen field. But, when you hide a field, then it means that the field is not displayed on the screen.

A ………………. is a box with a dotted outline, designed for the placement of different type of content on the slide. -Technology

Description : A ………………. is a box with a dotted outline, designed for the placement of different type of content on the slide. -Technology

Last Answer : A Placeholderis a box with a dotted outline, designed for the placement of different type of content on the slide.

Which of the following sites provide free access to the date sites?

Description : Which of the following sites provide free access to the date sites?

Last Answer : There are many websites that you can try for free. Have a look at match.com and lava life. Here are some additional sites for you: www.loveaccess.com/

Where can I see a list of thesis papers in different fields?

Description : Where can I see a list of thesis papers in different fields?

Last Answer : answer:I spend a lot of time on JSTOR. I can access it with my library card. Academia.edu is fun, too.

What are different fields of Human Geography? -Geography

Description : What are different fields of Human Geography? -Geography

Last Answer : Fields under Human Geography include: Social Geography, Urban Geography, Political Geography, Population Geography, Settlement Geography and Economic Geography.

How many different academicg career fields are represented PSATS my road resource?

Description : How many different academicg career fields are represented PSATS my road resource?

Last Answer : Need answer

What are the different fields in chemistry?

Description : What are the different fields in chemistry?

Last Answer : Different fields in chemistry are: biochemistry, inorganic chemistry, photochemistry, electrochemistry, thermochemistry, mecanochemistry, etc.

What different fields of jobs does the UN provide on their main career website?

Description : What different fields of jobs does the UN provide on their main career website?

Last Answer : There are many different kinds of jobs that UN offers. There are desk jobs where do paper work for the company and there are field jobs where you go outside of the office and sometimes to other countries.

A flat coil and solenoid has A. different fields B. same physical properties C. same fields D. same chemical properties

Description : A flat coil and solenoid has A. different fields B. same physical properties C. same fields D. same chemical properties

Last Answer : same fields

At all the points the uniform fields have A. different strength B. same strength C. zero strength D. infinite strength

Description : At all the points the uniform fields have A. different strength B. same strength C. zero strength D. infinite strength

Last Answer : same strength

Subschema can be used to A. create very different, personalized views of the samedata B. present information in different formats C. hide sensitive informationby omitting fields from thesub¬schema's description D. All of theabove E. None of the above

Description : Subschema can be used to A. create very different, personalized views of the samedata B. present information in different formats C. hide sensitive informationby omitting fields from thesub¬schema's description D. All of theabove E. None of the above

Last Answer : All of theabove

tillage utilizes two or more different types of tools to simplify fields a) combined b) basic c) strip d) rotary

Description : tillage utilizes two or more different types of tools to simplify fields a) combined b) basic c) strip d) rotary

Last Answer : combined

What are the different fields in pseudo header?

Description : What are the different fields in pseudo header?

Last Answer : ∙ Protocol number ∙ Source IP address ∙ Destination IP addresses.