4. Ms-Access – Working with Data Type Properties (Creation and Working with the Table – Part – II)

About this tutorial:

Video duration: 00:32:37
This video will help you to know, how to work with the data type properties provided by Ms-Access and importance of Data Validation in order to have proper data entry. In this Video Learn,
• Views in Ms-Access
• Validation – Field Level and Record Level
• Number data – Roll_Number should be greater than 0, the Mobile number should be of length ten digits and the First digit of Mobile should be 7 or 8 or 9
• Validating Text – Min. number of character, Not null, Converting Text into Upper or Lower, Email
• Validating Date
• Inserting Default values for the field like City,…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads