Creating Databases With Microsoft Access

It is easy and even fun to create a database in Microsoft Access, and there is also little to no programming involved.

In fact, the only programming that I’ve found is a SQL view in which you can write SQL code. You start by opening Microsoft Access. Afterwards, you click on New at the top and then you click on New Blank Database. Then you save your database with any name you choose. You can even keep the name they give you – db1. Next you double click on Create a Table in Design View and you have to write the fields (the table’s columns), their data type, and description. You also have to assign a Primary Key by Right clicking on the Field Name and selecting Primary Key. After that you enter the data. For example, if you created the fields: Customer ID, Customer Name, Address, City, State, and Zip – then you would have to enter data for those fields.