Act Base is the database component of the Act KPI Core solution.
Data is received into a centralised MS Access database on a computer via WiFi links from multiple Act Collect tablets. The WiFi links need not be connected to the Internet so data is secure. If a WiFi link is interrupted, the Act Collect tablets store the data until the connection is restored and the information will be automatically downloaded. Using MS Access, the data can be maintained and viewed in table format. If necessary, the data can be amended by supervisors before being analysed. Data is accessible to other computer systems via SQL (Structured Query Language) including MS Excel and MS Office products.
Information from other systems, such as standard costing, estimating and customer details (if available in CSV or SQL accessible formats) can be combined in Access or Excel to provide cost variance, on-time delivery and any other useful reports.
Act Base includes ready to use database files and application programs but does not include WiFi equipment, personal computer or MS Windows or MS Access.
All data is stored in a centralised MS Access database on a personal computer via WiFi links.
The WiFi links need not be conntected to the Internet so your data is totally secure. If the WiFi link is interrupted, the Act Collect tablets will store the data until the connection is restored. When the link becomes available again, the data will be uploaded.
Open data formats
All data is stored in open, well supported file formats allowing easy querying by using SQL (Structured Query Language)