ICT - DataBase

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

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

=)

  1. 👍 0
  2. 👎 0
  3. 👁 104
asked by Sasha

Respond to this Question

First Name

Your Response

Similar Questions

  1. Maths

    5x / x^2+1 less then or equal to x. Please someone help help been stuck on it for a while and I have an exam tommorrow. Any help is greatly appreciated

    asked by Fred on March 17, 2018
  2. geography

    Kso, my geography exam is tommorrow. I can't remember the steps to finding the adiabatic rates. Anyone know ?

    asked by Kameron on June 20, 2010
  3. *****Help Statistic

    Imagine taking a 10-question true or false exam. You randomly guess at each question. Don't do any calculations, just tell me your first impressions a). Is this a binomial setting? b) How many question do you think you would get

    asked by Helen on March 26, 2014
  4. Algebra

    Does anyone have a study guide i can use so i can study before my algebra 1B semester exam tommorrow i looked all over the school website but i can ot find the one she recomended

    asked by hi on April 16, 2018
  5. Analytic Geometry

    Solve then sketch the graph of y=x^2(4-x) (kindly answer it step by step please. Needed for my studies tonight. Final exam for tommorrow. Really need your help maam/sir.). this is on algebraic curves. Thankyou !

    asked by Earl John on May 10, 2016
  6. statistics

    Answer the question(s) based on the following situation: 150 students in a math class take the final exam. The scores on the exam have an approximately normal distribution with center ì = 65 and standard deviation ó = 10.The

    asked by Whitney on March 17, 2010
  7. Science

    Hey I need the answer by tommorrow so can you plzzzzzzz help? Well my question is... Is the space pen still around in the markets?? Thank you soooooooooooooooooooo much if you can help. :)

    asked by Aimee on October 22, 2008
  8. math

    I need help figuring the grade for two students I keep getting a big number. *Note Final can replace a low exam grade 𝐺𝑅𝐴𝐷𝐸 = .15 ∗ (𝐷𝑎𝑖𝑙𝑦 𝑎𝑣𝑔) + .65 ∗ (𝐸𝑥𝑎𝑚 1 +

    asked by chris on August 29, 2016
  9. math

    you are given an exam with only 9 questions. if each question has 4 choices, how many different possible answers can you have for the entire exam?

    asked by Kennedy on January 18, 2009
  10. Math

    An exam consists of six true-or-false questions. Assuming that every question is answered, in how many different ways can a student complete the exam? In how many ways may the exam be completed if a penalty is imposed for each

    asked by Anonymous on September 14, 2014
  11. math

    what is the difference btwn 5^3 and (5)^3? When ever they have a question in which they have a a number squared and then they have another question right after it asking the difference between the same question in parenthesis..is

    asked by Samantha on November 23, 2012

More Similar Questions