MS Access Basics



  2. Question:What do the following formatting symbols mean in Format properties of fields? 
<, >, @"NULL", @"Not entered", $ 
    Answer
    < Display contents in lower case
> Display contents in upper case
@"NULL" Displays NULL if left empty
@"Not entered" Displays 'Not entered' if field is empty
$ Right aligns text in column






    1. Report

  3. Question:What is the use of Validation Rule property of a field? 
    Answer
    Validation rule property allows specifying what validation must be made for the data entered in the field. if anything is specified in the validation rule property, only the data that satisfies the condition specified can be entered, all other data is rejected.






    1. Report

  4. Question:What is 'Input Mask' field property? 
    Answer
    Input mask specifies the format in which the data must be entered. For example if phone number must be displayed as (977) 428-0628 enter the input mask property as !(999) 000-0000;;_






    1. Report

  5. Question:What is the use of Validation Text property of a field? 
    Answer
    When the data entered in a field does not confirm to the validation rule that is specified, an error message is displayed on the screen that informs the user what is wrong. Validation text is used to display custom error message instead of default error message.






    1. Report

  6. Question:How can you import a table created in another database or other file formats? 
    Answer
    Access provides facility to import tables from other database or other file formats such as excel workbook. To import a table Choose 'File > Get External Data > Import'. Alternatively, you can choose Import option on New Table dialog box.






    1. Report
First910111213Last
/18
Copyright © 2025. Powered by Intellect Software Ltd