Tuesday, 18 November 2014

Learning Outcome 2: Be able to select and use software to handle data

Creating Databases

'Flat File' Databases
When you first set up your database, you can choose to make a 'flat-file' database in the options it gives you. This must however be saved in the correct file type (csv.) when you choose your save options.

To enter new data to files, all you have to do is double click on the box you want to use before entering your data. This is the same or editing data but instead of clicking twice you click three times to put the cursor in the part of the characters you want to edit. To delete, you highlight the box(es) and press the backspace key.

To sort the table, you can press the button that looks like:[A-Z] to sort alphabetically and [Z-A] to inverse. To query a single table you can 'Auto Filter', 'Standard Filter' and 'Advanced Filter'. With the Auto Filter, you highlight the data you want to filter and press the option (under the data drop-down menu). This then gives you small drop down menus on the headers of each column so you can filter them accordingly as shown below.


The standard filter is a little more complicated than this; when you click the option you get a popup that looks like this:
                               
Here is where you can choose the criteria of search in what column (like the auto filter but with more control). Then you enter how you want to search based on the column headings and how they need to be sorted. For example, I chose Initials beginning with K, this is what I got as a result from the database:


For the advanced search, it is even more complex due to having to make the search criteria yourself instead of choosing from various valid search options like the others. Here is what it looks like:




No comments:

Post a Comment