Week 5 (Data Types and Field Properties)

Week 5.... I've learned the different data types.

• Text - you may type alphabetical/numerical data maximum of 255 characters.
• Memo - you can have 64 000 characters and no specific format.
• Number - only contains digit 0-9, calculated
• Date/Time - just like am/pm
• Currency - used for money and will auto-format to contain the dollar sign and commas.
• Auto Number - automatically number, consecutive, never been duplicated.
• Yes/No - one or two possibilities(yes/no, true/false, on/off), checkmark or checkbox
• Hyperlinks - clickable links
• OLE - Object Linking and Embedding, use to insert pictures, sounds, etc.

                         
                                                                                                              
I've also learned about the Field Properties

• Field Size - is set to 225 but you can make this larger or smaller.

                                                       

• Format

                                                                           

• Input Mask - field property that determines display format and limits the type of data that can be entered. The number entered is automatically punctuated and displayed properly.

                                                                                               

•  Default Value - Access will enter a value in a new record automatically.

                                                               

• Validation Rule - field property that limits or conditions on the data that can be entered on the field.

                                                        

• Validation Text - a custom message that's displayed if invalid data is entered in a field.