The Input Mask Wizard is a feature of Microsoft Access that helps you create an input mask.
An input mask allows you to specify exactly how data should be entered into the database. It’s an expression that specifies certain rules about how the data should be formatted as it is entered into the system.
Here’s an example of an input mask:
This specifies the format that a phone number must be entered. The number 9 indicates an optional character. The number 0 specifies a mandatory one. So in this example, the area code is optional.
When trying to decide which one to use, a side-by-side comparison of the technical specifications of each system can help greatly. Below is a side-by-side comparison of some of the technical limitations of each system.
Microsoft Access is a relational database management system (RDBMS) developed by Microsoft. It’s part of the Microsoft Office suite, included in the Professional and higher editions or sold separately.
Microsoft Access provides a quick and easy way to develop databases and is particularly well suited for individuals and small business. Access is the most popular desktop database on the market.
In Access, most tasks can be performed via the graphical user interface (GUI), but more advanced users can also develop applications using Visual Basic for Applications (VBA) code. Advanced users can also use SQL code to write or modify queries.