Select cells A2 to F12 from the spreadsheet.Once you are done with inputting the data, it should be converted into a better visualisation table. The column headings are called Field Names. See the below screenshot for your reference:Įvery Column is a Field in Excel DatabaseĮvery column is called Field in the Excel database. Every single row we create/add is called as a Record in the database. It is a kind of basic knowledge we should have about the database we are creating. All the Rows are called Record in Excel Database. It’s not the start column of a new database. It is misleading, as the column after the blank column is a part of your original database. Excel considers that a blank column is a separator for two databases. Which causes Excel to think there is a split of data. On similar lines, you should not leave any blank column in the database.Īs you can see, column F is left blank. 12 ( second last row of the dataset) and added one new row, which is not recommended. See screenshot given below:Īs you can see, there is one row left blank after row no. Suppose you have added a correct entry, but at the 2 nd row after the last row (i.e. you have mentioned Designation under Last Name and Last Name under Designation, which is a serious drop-back when you are thinking of this as a master employee data for your organization. Suppose,uy as shown in the image above, you wrongly interchanged the column inputs. It’s also important to make the right input to the right column. If you don’t have any information available with you, prefer to put NA over a blank cell. Try to the utmost that no data cells are blank. When I say no other blanks, it covers the column cells, which are not blank as well. Make sure there is no space in your data. It is always good to enter the correct data. Make sure the Salary column format is applied to all the cells in the column (Otherwise, this database may cause an error while using). Filthis informationon in cells manually as per your details. Say D01, D02, D03 and then dragged the remaining till row 12 using Fill Handle. Column second onwards contains the general employee information like First Name, Last Name, Designation, and Salary. I have added the first few Employee ID’s. Suppose this is the data thatq1 you are going to use as an employee database.
Excel student database download#
You can download this Create Database Excel Template here – Create Database Excel Template Data Entering to Create Excel Databaseĭata entering is the main aspect while you are trying to create a database in Excel.