TSDO DEMO

The Demo is an MS Access 2010 compiled file in mde format, which you can open with MS Access 2010 or later, or with free database viewer -MS Access Runtime upgreated to Service Pack 2.

Demo version has following limitation:

- no new Subject can be created (still, you can create new Schedule).

What do you need to know in advance.

"MS Access", as member of relational database family, is very different from other "MS Office" products, and you need to know the basic concept and operations with data tables.

In general, in database you store all data in tables that are looking similar to well known "MS Excel" tables. Each cell of the "MS Excel" table has its own unique address, defined by columns and rows - it can be called as a two-coordinate system. This unique address can be easily used in any formula. "MS Access" table has one coordinate system – cell position is defined by columns only. The position of the row depends on sorting type and cannot be predefined. To get required row or set of rows, you need to make selection by some parameters of one or more columns presented in the table and then to filter all rest rows, which do not mach to selected parameters. Thus, SELECTION is the main action applicable in relational database tables to get required records.

You can refer following resources which contain MS Access lessons:

FunctionX Tutorials

http://www.functionx.com/access/Lesson01.htm

MS Access for Dummies

http://www.dummies.com/software/microsoft-office/access/?filter=OTHER&sort=TITLE

Allen Browne's Database and Training

http://allenbrowne.com/tips.html

TechOnTheNet

https://www.techonthenet.com/access/index.php

My most advisable source is:

GCFLearnFree.org

http://www.gcflearnfree.org/access2010/

And mandatory to know lesson is: Sorting and Filtering Records: http://www.gcflearnfree.org/access2010/sorting-and-filtering-records/1/

Note: since TSDO is a compiled file, it does not contain the full set of menus available in MS Access.

GENERAL RULES:

All mandatory fields have “*” symbol.

All forms are open in Datasheet view by default. To change it to Form view, you need double click following fields:

• “File As” field of CONTACTS, EQUIPMENT and SPECIFICATIONS tables;

• "Subject" field of SUBJECTS table;

• "Specification" field of STATISTICS table.

It is possible to add/edit data in both – Datasheet and Form views.

Most useful keyboard shortcuts:

[Ctrl]+[+] – create new record

[Ctrl]+[;] – enter current (system) date.

[Ctrl]+[‘] – in datasheet view copy values from upper row of the same column.

[Ctrl]+[k] – insert link, email or web address to field of “hyperlink” type.

If you are interested in buying the full version, you need to follow these steps:

1. Consider to download your TSDO file in the root directory of your documents.

2. Create MS Access "Username" - follow the linked Instruction at the bottom of the page..

Username must contain your name and surname without space between them, no more than 20 characters. If you plan to use your copy on another PC, the same MS Access Username must be created on that computer.

It is not possible to create Username under MS Access Runtime version. Instead, it will be created by me directly in your licensed copy.

3. Send me a request for the full TSDO version by email to alexander.jakhutashvili@gmail.com. Include MS ACCESS version installed at your computer and your MS ACCESS Logon Username. The Full version will work with your Username only.

You can include your comments. Some minor changes can be done in design of some Forms or Reports.

4. You will receive a payment request from PayPal and a link to demo version of your personal instance for final testing. Please test your copy carefully, as a refund is not acceptable.

5. After payment will be done, you will get link to full version.

6. Download TSDO file to your documents root directory