ICT - DataBase

posted by .

Hello

I have an exam tommorrow and my question is :

What is the difference between the types of the data base text and number in the data base. My teacher tells us that a phone number is in the text column because it does not change. But in number it's changble ?

What is the difference between these two and can someone please give me an example for text and number and which one can change


thankyou

Someone will correct me if I'm wrong, but here's what I think your teacher is referring to.

The numbers that you do not want to be automatically sequential or change by means of a formula in any way are text.

The numbers you want to be automatically sequential (such as numbering down the left side of a page) or change by means of a formula (totals or quotients or ??) are the changeable ones. That is, they can be set to change automatically.

Here are three articles regarding the uses of numbers in Microsoft's database, Access:

-------------------
• How to reset an AutoNumber field value in Access
(812718) - Set the AutoNumber field of the main table to a Number data type. ... Create a new field of Number data type in the referenced table. ... For additional information, click the following article number to view ...
http://support.microsoft.com/kb/812718/en-us

• How to store, calculate, and compare Date/Time data in Microsoft Access
(210276) - Store Date/Time data Access stores the Date/Time data type as a double-precision, floating-point number up to 15 decimal places. The integer part of the double-precision number represents the date. ... Access stores dates before December 30, 1899 as negative numbers.
http://support.microsoft.com/kb/210276/en-us

• Functions for calculating and for displaying Date/Time values in Access
(210604) - Because a Date/Time value is stored as a double-precision number, you may receive incorrect formatting results when you try to manipulate Date/Time values in an expression. ... Because a Date/Time value is stored as a double-precision number, you may ...
http://support.microsoft.com/kb/210604/en-us

------------------------

=)

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. IT Information Systems Technology

    Why are database management systems important in the business community?
  2. statistics

    basically i'm at the begining of the text book doing summer work it's talking about mean and stuff asked to find the mean of a set of data and given 14 different numbers the question then goes on and tells me a fifteenth number is …
  3. Database Decision

    When deciding whether to store data in a database or in a spreadsheet, what are some of the questions you should consider?
  4. Probability and Statistics

    Can someone tell me what formula I should use?
  5. math

    Write the base 10 number 945 s a base 6 number and as a base 12 number. then, using these numbers as base 10 numbers, find the positive difference between them.
  6. math

    You are developing a data base for Army tracked combat vehicles and you are normalizing the data base to base year 2006 dollars. What number would you enter into the data base for a vehicle budgeted at $1,725,000 in the FY08 appropriation?
  7. Algebra 2

    -Explain the difference between log base b (mn) and ( log base b of m)(log base b of n). Are they equivalent?
  8. Business

    You are developing a data base for Army tracked combat vehicles and you are normalizing the data base to base year 2007 dollars. What number would you enter into the data base for a vehicle budgeted at $1,725,000 in the FY08 appropriation?
  9. Inflation Exam

    Inflation Exam 1) You are developing a data base for Army tracked combat vehicles and you are normalizing the data base to base year 2014 dollars. What number would you enter into the data base for a vehicle budgeted at $4,725,000 …
  10. Math Question from Teacher Exam

    Another crazy question on the exam. A teacher gives each child a picture card of an animal with a number. She tells the student to make the animal sound the number of times that matches the number on the card. What type of reasoning …

More Similar Questions