Working on the Access file ASSET.MDB
  • Purpose

This file has linked tables to database PARADIGM on lofty. It contains additional information on assets (features like processor, memory etc…). As well the sequence number for bulk import.
Additionally it has the forms for printing the necessary documents with barcodes. For using this feature they installation of the correct font is required.
  • Tables & Queries
    • AssetF            Table
    • Gen_res          Table
    • Man           Table
    • Manmod         Table
    • Model             Table
    • Paradigm_gen_res     Linked table
    • Paradigm_man Linked table
    • Paradigm_man_mod  Linked table
    • Paradigm_mdl_com   Linked table
    • Paradigm_net_res Linked table
    • Paradigm_resfam  Linked table
    • Paradigm_vnd_prov  Linked table
    • Sequence        Table
    • Vendor            Table
    • CPU               Query
    • Make_gen_res          Make query
    • Make_man      Make query
    • Make_model        Make query
    • Make_vendors          Make query
    • Printer             Query
    • Screen             Query
    • Vendors          Query
See related topics and documents
Tables
AssetF
graphic
Gen_Res
graphic
Man
graphic
ManMod
graphic
Model
graphic
Sequence
graphic
Vendor
graphic
Queries
CPU
graphic
Make_Gen_Res
graphic
Make_Man
graphic
Make_Model
graphic
Make_Vendors
graphic
Man_Mod
graphic
Printer
graphic
Vendors
graphic
Screen layouts and their usages
When you launch the program you will get they following screen :
graphic
Menu items :
  • Barcode Reports :    Through this item you can go to the overview of reports created for barcode printing.
  • Asset Features :   Through this item you can update the features for computers. (Those features are only used by importing through hand scanners in combination with barcodes).
  • Update tables :    When new items are created in the DB, you must select this item for updating the database in the access file.
  • Maintenance : Only needed if some great changes are done and you want to rebuild the database in the access file.
Barcode Reports
graphic
Menu items :
  • List of computers : This report represent an overview of all ‘active’ computers and their corresponding barcode.
  • List of printers : This report represent an overview of all ‘active’ printers and their corresponding barcode.
  • Rest of assets :  This report represent an overview of all ‘active’ assets, not mentioned in both previous points, and their corresponding barcode.
  • All Models : This report represent an overview of all ‘active’ assets
  • List of vendors :     This report represent an overview of all ‘active’ vendors
Asset features
graphic
Update asset features
graphic
Maintenance
graphic
Menu items :
  • Sequence :       Sequence number for bulk import
  • Creation Tables :  (Re-)create the tables in access file
graphic
graphic