1 / 6

Verify your data entry

Verify your data entry. validation rules in Access. You could use data types and field properties for adding any validation on your date: EX: Data type: number : allow the user to insert just numbers.

jkrick
Download Presentation

Verify your data entry

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Verify your data entry validation rules in Access You could use data types and fieldproperties for adding any validation on your date: EX: Data type: number : allow the user to insert just numbers. Field property such as field size : allow the user to insert characters or numbers with limited size.

  2. Verify your data entry *validation rules in excel: 1. Highlight cells which you want to add rules for them 2. Select the data menu then validation …this will open the data validation window. 3. The rule is set in the setting tab

  3. Verify your data entry 4. Use drop down menu in the allow: how to select the type of data to allow. for example: if you are going to enter numbers between 0.8 and 2.5 select the decimal from this menu 5. Select between from data: drop down menu if it is not already visible. 6. Set the minimum value to 0.8 by typing this value 7. Set the maximum value to 2.5 by typing this value 8. If you wish to give the user information about the data to be entered in this cell, use the input message.

  4. Verify your data entry 9. To enter an error alert, if the user enters the wrong data, select the error alert tab. 10. Enter stop as a validation style this will prevent invalid data being entered into these cells. 11. Eneter the title for this error message. 12. Enter the contents of the error message 13. Click on ok to enter these setting for validation

  5. Verify your data entry **how to protect parts of the spreadsheet: 1. Highlight this part (cells) 2. Select the format menu then cells …this will open the format cells window 3. Select protection tab. 4. Tick the locked check box then press ok **how to protect worksheet Select the tools menu followed by protection then protectsheet…then tick the check box to add any votes.

  6. how to protect database From main menu select tools then from Security select set database password then write your password

More Related