|
| | |
|
Home > Advanced Features > Select Data to copy to Excel
Select Data to copy to Excel
The two database options available are Microsoft Access and SQL. Both can be connected to by Microsoft Excel and data can be accessed directly.
The simplest way to access data in Excel is to copy it from a table in VisitorRego and paste it into Excel.
As an example - to find the duration over an extended period a person is onsite for can be shown in VisitorRego, copied and pasted into Excel.
Filter the data. Select company of the person who is to be report on. From reception mode, select 'File'; 'Visitor Company'
Please refer to 'Visitors Company' and 'Visitors Company - navigating'
The screen shot belows shows all the companies beginning with 'V' (there only being one).
The button to the right labeld 'Visitors' shows all visitors for the company. Clicking on the button to the right labeld 'Regos' shows all registrations for the company as below.
To select a range of records click on the record selector (grey button far left) of the first record to be copied; hold the the <shift> key; click the record selector of the last recor to be copied. The selected range of records is highlighted blue.
The key combination <Ctrl> <C> will copy the selected records to the paste buffer.
|
|
| Article Details | Created:5/10/2010 3:10:59 p.m.
Modified:5/10/2010 5:23:33 p.m.
Author:Admin
Views:19
| |
| Related Articles |
| |
 |
To add links, place the cursor in the box above and then click 'Link Page' on the toolbar.
| File Attachments |
| |
|
To upload and insert attachments, place the cursor in the box above and then click 'Document Manager' on the toolbar.
|
|
| |
|
|
Page URL: