What is a database in Microsoft Excel?

Answer 1

Excel's database capability is rather limited compared to a relational database program.

As an example you could have a list of stock items and their prices on one worksheet, a list of customers on another worksheet and you could use a third one to prepare invoices, using the VLOOKUP function to draw stock and customer information from the other two worksheets.

Answer 2

MS Excel is a spreadsheet, not a database program. It has a limited capability to do some databases in it. A database in Excel would therefore consist of columns of data with headings, like fields in a true database. On each row of the block of data you would have the equivalent of records.

Answer 3

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

Answer 4

You just need to lay out your data in a structured format. In each column you would put a different set of data. So in one column you would have firstnames; in another surnames; in another dates of birth; and so on. They would be like fields in a database. At the top of each column you would have a heading that would act as the field name. Then in each row you would put the data for each individual, like records in a database. If you have it laid out like that, then it is effectively a database. Excel then has loads of facilities to manipulate the data like a database. You can use Filters, sort the data, create forms and many other things. There are also lots of functions specially for databases in Excel. For a simple flat file database, you could do it in Excel. If you want something more complex, like a relational database, then you are better to use another application, like Access.

Answer 5

You would use Microsoft Access mainly, although you can build some in Excel and even Word has minimal database capabilities. The actual procedure for creating a database in Access is detailed, so not really practical to explain here. You would need someone to actually show you how it is done, or buy a book or read a tutorial on it.

Answer 6

Most data in a spreadsheet is entered in a structured format in rows and columns. In that way it is already a database. You may need to rearrange you data to make it into a database if it is not well structured. As Excel is a spreadsheet application, it does things that a database does not do or does some things differently, though there are many things that both can do equally well. Excel has some built-in features to take data that you have and treat it as a database, including things like creating lists, filtering, sorting and many functions.

Answer 7

Use different sheets as the different tables of a relational database. It will be much more cumbersome than using a real relational database program, but it can be done.