The fastest way to understand any Application is to use it.
It is important to understand that DanceScore can be run with the very minimum of data. Although not desirable for large or fast moving competitions it is theoretically possible to walk into a competition (preferably a small competition) with a laptop and printer and start scrutineering within minutes. The only information you need to do this is the names of the Adjudicators and even these could be altered during the competition.
Of course with no competitor names entered in the database the results will simply show the Back Numbers. Names can be added at any time and when this is done the system will pick these up when a result is reprinted.
For the Quick Start exercise it is assumed that you have downloaded the DanceScore Scrutineering Module and have a suitable version of Microsoft Access installed on your computer.
To keep things simple create a folder on your desktop and place the DanceScore.mde file into that folder. Once this is done double click the file to run the application. Don't run the .mde file directly on the desktop, at runtime the application will create several folders and sub-folders, these are used during processing.
It is possible to run the DanceScore.mde from any location (including a usb stick but this will be very slow) and for the Quick Start exercise we will use the desktop … however when using DanceScore in a network environment it is necessary to run the 'Server DanceScore.mde' in a folder on the Server's C: drive called 'dancescore' (lowercase).
As with all other Microsoft programs, Access has multiple levels of security. This is to stop hackers, (people with way too much time on their hands), from writing malicious code that could infect your computer and damage your data. However if you are only using your Microsoft Access for running DanceScore, which most of us are, you can turn down the Macro Security level and stop those annoying and sometimes confusing security messages.
Users of Access 2007 and beyond can set up ‘Trusted Locations’, these are directories on your hard drive or network that Microsoft Access will consider safe and run any programs from that location. Clicking on the Office icon, upper left corner of the screen, will open the main menu of Access 2007, you will then see a button at the bottom of this menu called ‘Access Options’, click on this. Navigate to the ‘Trust Center’ button and click, this will open the Trust Center security page.
Now click on the ‘Trust Center Settings’ button and in the new screen select ‘Trusted Locations’. This screen allows you to set locations that Access will run programs from without asking security questions. In the same location as the above ‘Trust Center’ settings you will find the security setting for Macros, this is basically the same for all versions and if you are only using Access for running DanceScore then you can choose the bottom setting – ‘Enable all Macros’.
NOTE: Security settings cannot be changed for Access Runtime versions.
During this Quick Start exercise we will process a Semi (recall event) and then the Final.
As said previously the only information required in a 'bare bones setup' to process an item is the names of the Adjudicators, therefore the first task is the adding a few Adjudicators to the Adjudicator database.
With an empty DanceScore.mde file there is no data in any of the databases except the Dance Names these are supplied by default but you can easily create and save your own list for your local requirements.
Click on the Adjudicators button to open the Adjudicator Database.
Here you see an empty database table that will be populated by our adjudicator information. for the exercise we will type in 3 names, their ID number and where they are from … like this:
Ignore the other data fields. The Language & PIN fields are used for the Adjudicator Tablets and the Licence field is only need if you have a requirement to record your judge's licence numbers.
Now we will place these 3 Adjudicators into a Judging Panel, this is simply a convenient way to group Adjudicators so we can insert them in to the Running Order for display when we process the competition.
For our exercise we will put our 3 Adjudicators into a Latin Panel and we will assign this with the letter 'L' … like this:
A competition's Running Order is divided into ITEMS, those Items are placed sequentially into the Running Order database which will contain all the necessary information to run the competition.
Each field in the Running Order database controls an aspect of how Items are processed or displayed in reports aor on the Adjudicator's Tablets. For our exercise we will keep it simple and add 2 Items which will be a Semi Final and then the Final of the same Event … we will call this 'Beginner Latin'.
Add the data as shown below (high-lighted in yellow), no other data is required for the exercise. This event will be the Beginner Latin, CCC with the Adjudicating Panel 'L', the semi will be recall 6 couples over 1 heat.
There is no need to add identifiers to the Item Name (Description), identifiers such as Round, Semi and Final are automatically added by the system. Exit the Running Order (click the Database or Main Meu buttons) and then reopen the Running Order … now you will see that the system has detected multiple Items of the same name and has assigned their type.
During an actual competition you can add Items to the Running Order at anytime, you may also insert Items using 'Letters' for example '1A' would insert between Items 1 and 2.
We have now done all that is required to jump in to the first part of the exercise and that is to process the Beginner Latin Semi Final…