Skip to main content

Table Datatypes in MS Access

Field Data Types
The various data types in Microsoft Access are described below in the table:
Data TypesDescription
AutoNumber It stores an integer that increments automatically as you add records.
Text It is used to store combination of text and numbers that does not require calculations, such as address, mobile number, name, etc. The field of this data can hace a maximum of 255 character.
Memo When you have more than 255 characters to enter, then you should use this data types for entering large text. Like detailed description of a student or items or products, etc.
Number This data type is used to enter number in the column or fields.
Date/Time It stores date and time values. You can display the dates and times in various format. You can change the format from field property menu.
Currency This data type stores the currency value. It shows the value in decimal format with $ sign.
Yes/No This data type accept only one value Yes/No or Trye/False.
OLE Object This data type stores graphics or objects such as Ms Excel, Word, Power Point, etc.
Hyperlink This data type stores link of different websites or email addresses.
Attachment For fields with this data type, multiple files can be attached per record.
Calculated This is a new data which has been added in MS Access 2010. Fields with this data types stores result of the calculation.
Lookup Wizard This creates a lookup field that displays a set of values.
Field Properties
Every field in a table has its properties to define its characteristics and behaviour. The field properties let you have more control on data. Some of the field properties are:
Field PropertyDescription
Field Size The properties can be set for fields with text or number data type. It sets the maximum size for data stored in a field to accomodate text (0-255), number or autonumber data type.
Format It controls the manner in which data gets displayed.
Input Mask It makes data entry easier and controls the values which a user can enter into it.
Decimal Places It specifies the number of decimal places for numeric data.
Caption This property is used to give an alternate, more descriptive name to a field.
Default Value This property is used to specify a value that gets displayed automatically when a new record is created.
Validation Rule It is used to put conditions on the data that can be entered in a field.
Validation Text It is used to display an error message when the validation rule gets violated.
Required It forces you to enter a value if required property is set for Yes.
Allow Zero Length It accepts a blank entry if required property is set for Yes.

Labels:

Comments

Post a Comment

Students you can ask your doubts in comment section

Popular posts from this blog

Q & A Chapter 1 | Internet Basics | Class 10 CBSE | Computer Application

 Q & A of Chapter 1 Internet Basics A. Tick the correct options – 1. (b) TCP/IP 2. (a) Internet Service Provider 3. (a) URL 4. (b) HTTP 5. (a) Bridge 6. (a) home page 7. (d) All of these 8. (b) Domain Naming System 9. (b) Rules 10. (d) ARPANET B. Very Short Answer Type Questions – 1. In the URL http://www.myfirm.co.in/about.html , what do the following components depict? (a) http                                                 (b) in (a) Http represents a type of server and the protocol on the Internet (b) ‘in’ represents the domain extension of the website. 2. In the URL http://www.favmusic.com/contactus.html what does www.favmusic stand for? www.favmusic represents the domain name i.e. favmusic in www. 3. W...
Post a Comment
Read more

Bit by Bit | Chapter 6 - Graphics and Sound in QB64 | QBasic | Class 7 CBSE | Computer Application

Bit by Bit | Chapter 6 - Graphics and Sound in QB64 A. Tick the correct option. 1. (d) screen mode 0 2. (b) 640 x 350 3. (d) White 4. (a) Lower-Right 5. (c) PSET 6. (c) Generate a tone for a short duration B. Fill in the blanks. 1. CIRCLE 2. PAINT 3. PLAY 4. Graphic 5. Pixels 6. Box C. True or False. 1. True 2. False 3. False 4. True 5. True 6. True D. Answer the following questions. 1. What is the use of SCREEN statement? The SCREEN statement is used to set the screen mode for displaying graphics. There are many screen modes and each screen modes have their own number which is from SCREEN 1 to SCREEN 13. The various screen modes differ in resolution. 2. What is a pixel? How is it related to resolution? The graphics which is displaying on the computer screen is made up of thousands of dots called pixel. Pixel stands for picture element. The number of pixels in an image determines the resolution of the image. Higher the resolution, cleaner the image will appear. 3. What is the differenc...
Post a Comment
Read more

Thymeleaf function on button click with multiple parameter

how you can write the onclick attribute using Thymeleaf syntax: <button type = "button" th:onclick= "|rejectSalaryPayment(' ${response.uuid} ', ${dto.id} )|" >Reject Salary Payment</button> This assumes that the response.uuid and dto.id variables are available in the current Thymeleaf context. If they are not, you will need to provide the appropriate values or expressions to evaluate them. Also note that the onclick attribute is written using the Thymeleaf expression syntax ( |...| ), which allows you to include string literals and variable expressions within the same attribute value. 
Post a Comment
Read more