A default value is something that is always present in a particular field whenever a new record is made. For example, if you own a company with its base of operations in New York, you can assign a default value of “New York” in all of the address fields you might use in a database. Every time you go to enter a new employee’s information or customer invoice, the city field will always be “New York” until you change it to something else.

Adding a default value is easy, simply open a table in design view, click the field you want to give a default value, and type a new default value in its field property. In our example, we will make the default number of cylinders 6: