COMMUNICATION Janet Anderson, Anderson PC Training
Using Excel to Create a Database Great Tips on How to Organize Y
M
any of you use Excel to create budgets and crunch numbers. Did
you know that you can make a list (or database) in Excel? Excel provides a LOT of tools to help you sort, filter, color code and extract information from your list.
Creating The List First what do I mean by “list”? A data- base is a collection of infor- mation in an organized structure. In Excel you can create a database by creating a row of column headings that will be the categories or fields headings for
the information to follow. For example, you might have a field called First Name, another
called Last Name, etc. They could oc- cupy cells A1, A2, and so on.
8 ®
our Information
Below these fields, you can enter the indi- vidual records (rows) of information such as JANET under the First Name heading and ANDERSON under the Last Name heading and so on. Complete this record by entering all of the data that relates to the column headings. You might have a database of addresses so you might have fields like First Name, Last Name, Ad- dress1, Address2, City, State, and Zip.
Enter in as many records as you like, however there is a limit. Excel 2007 has 1,048,576 rows in a sheet, so you can have 1,048,575 records. If you have that many friends, relatives or clients, congrat- ulations!!! Since you cannot exceed one sheet when you create a database, that is your limit.
Now for the fun part. Don’t worry about putting them in any kind of order. Excel has great tools to help you rearrange your records in many ways.
MORE INFO Anderson PC Training
www.andersonpctraining.com 980.428.2066
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32 |
Page 33 |
Page 34 |
Page 35 |
Page 36 |
Page 37 |
Page 38 |
Page 39 |
Page 40 |
Page 41 |
Page 42