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. 👍
  2. 👎
  3. 👁

Respond to this Question

First Name

Your Response

Similar Questions

  1. Finite Math

    Two dice are rolled three times. What is the probability of getting a sum of 7 at least once?

  2. math

    In a course a student's final exam is weighted as heavily as his mid term exam.if a student receives a score of 84 on his final exam 90 on his midterm,what is the average for the course?

  3. mathematics

    Mary will be taking a 20-question, multiple-choice exam with three choices for each question. She has another important project to be submitted on the same day. If Mary guesses on each question of the exam, find the probability of

  4. 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

  1. physics

    Spaceship I, which contains students taking a physics exam, approaches Earth with a speed of 0.640 c, while spaceship II, which contains instructors proctoring the exam, moves away from Earth at 0.280 c, as in Figure P26.27. If

  2. math

    A student’s final grade in chemistry is determined by the following weights: Quizzes 5% Exam 1 20% Exam 2 20% Lab Reports 15% Research Paper 15% Final Exam 25% The student received the following grades: Lab reports: 75 80 70 75

  3. 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

  4. English

    Question 21 Select the most effective sentence. Baxter worried about his English exam when he thought about it. Baxter felt a pang of existential anxiety when he comtemplated his English exam. When Baxter thought of his English

  1. Math (Algebra 1)

    Juan’s first 3 exam scores are 85, 93, and 87. What does he need to score on his next exam to average 90 for all 4 exams? let x represent the score on his next exam (put this in a multi-step equation) PLEASE HELP

  2. Math

    here is the question: Freida must take a 4-hour exam containing 200 questions, 50 of which are math. Twice as much time should be allowed for each math ques as for each other type of question. What is the total # of minutes she

  3. statistics

    A student takes a 20-question, true/false exam and guessed on each question. Find the probability of passing if the lowest passing grade is 15 correct out of 20.

  4. Probability

    Mary took a 20 question multiple-choice exam where there are 4 choices for each question and only 1 of those choices is correct. Rather than reading the question, Mary simply puts a random choice of answer down for each question.

You can view more similar questions or ask a new question.