Searching the Time and Attendance Plus Database |
| Contents Product Page Buy Time and Attendance Plus Now! |
You run arbitrary searches against the Time and Attendance Plus database using the Search Database options of the Tools & Optiops menu. This screen includes a query building system that will allow you build your own simple searches. If you have some knowledge of SQL you can also enter free form SQL queries on this screen. Special care should be taken when running any UPDATE or DELETE queries.
| Simple Single Table Search | A simple single table query can be run by selecting this option. |
| Search Table | Select the database table you wish to run your single table query against here. |
| Return All Records | To return all records in the chosen table chose this option. |
| Search For | To search for something specific select this option and enter something to search for in the text box. As an example, to return all employees with the name 'Black' select the employee table and enter jones into the search box. |
| Exactly | To match the search criteria exactly select this option. For example, if you are searching for the name 'black' then only people with the name 'jones' will be returned. |
| Like | To loosely match the search criteria select this option. So, in out example of searching for 'jones', any records with 'blacktown','blacksmith' and son on will be returned. |
| Any Field | This option should be selected if you want to match your criteria against any field in the table being searched. |
| Selected Field | This option should be selected if you want to match your criteria against a particular field in the table being searched. |
| SQL Search | To enter your own SQL search statement in the SQL Search Text box select this item. |
| SQL Search Text | Your freeform SQL search statment can be entered here. Queries generated by the query builder will output their SQL text to here. |
| Open Query | To open a previously saved query click the open query (with the yellow folder icon) button. |
| Save Query | Click the save query button (with the green disk button) to save the current query to a file for later use. |
| Execute Search | To execute a search click this button. If there are any results from the query they will be output to a new search results window that can then be exported to Microsoft Excel. |
| Exit | Click this button to exit. |