Bristol Enfield Central London Leatherhead Manchester Glasgow
t: 0845 370 1444 © 2008. Excitech Ltd. All Rights Reserved www.excitech.co.uk/training
COURSE DESCRIPTION
Training Course Outline
Excitech Ltd. Design Technology Centre, 8 Kinetic Crescent, Innova Business Park, Enfield, Middlesex, EN3 7XH.
PRE-REQUISITES
COURSE OBJECTIVES
This course aims at providing the basis for customising
ARCHIBUS. The course covers issues like database
configuration, altering existing tables, indexing and
importing/exporting data.
This course is designed for an experienced ARCHIBUS user.
The following prerequisites apply:- Previous attendance of an
Archibus Basic database course. Previous attendance of at
least 3 other ARCHIBUS module course. Full understanding
of AutoCAD software. Competent in the use of MS-Windows
An understanding of Facilities Management. Sound
experience of Database concepts and MSSQL. Database
Development or programming experience essential.
Upon completion of this course, the user will have an
understanding of the following:
· Understand Client/Server networks.
· Understand and use ODBC connections.
· Configure Databases.
· Create and alter new tables.
· Create new Primary and Foreign keys.
· Create and alter validation columns.
· Alter existing Primary and Foreign keys.
· Change columns attributes.
· Adding indexes to columns.
· ARCHIBUS AFM-License.xml
· Fully understand the Installation Process of ARCHIBUS
· ARCHIBUS Process and Roles
· ARCHIBUS ini Configuration
· Manipulate the Navigator Tool.
· Create new table Views.
· Manipulate table Views.
· Understand security issues.
· Enable security and create Groups.
· Understand and use the MSSQL Query Analyzer.
· Understand and Use the SQL Enterprise Manager.
· Uploading SQL MDF files.
· ARCHIBUS SQL scripts.
· Check database in