Summary | Learning Modules

The Accubid Database Management training lab was designed to equip database custodians with the skills and knowledge to competently manage their company databases efficiently and effectively. The instructional method is unique in that it is conducted privately either on a one-to-one or one-to-many basis with a dedicated trainer via the internet. This unique web-based approach offers tremendous advantage in its flexibility and relevance to participants. The course is comprised of five modules in its entirety. Participants who wish to acquire basic skills need only take the first three modules. The remaining two modules comprise the power substitution option and should be taken by those participants that wish to cover power substitutions in greater depth.

Participants are encouraged to use their company databases during instruction to afford them maximum benefits.

Learning Objectives-Database Fundamentals (Modules 1 -3)

Upon successful completion of training, participants will be able to:

• Understand the structure of the item database, common assembly database, designation, and specialized takeoff libraries.
• Effectively create and modify items, common assemblies, and takeoff libraries.
• Competently create, save, and run database queries.
• Create, save, and apply screen styles.
• Effectively create, save, modify, and assign sort codes to items.
• Describe and demonstrate methods for updating material pricing in databases.

Learning Objectives-Power Substitution (Modules 4 - 5)

Upon successful completion of training, participants will be able to:

• Effectively plan, create, and modify power substitution tables.
• Understand the task of re-synchronizing and copying the database.

Summary | Learning Modules

Module 1 - Database Management Principles

• Database Manager
• Copying a database
• Item database structure
• Item database fields
• Item database modifications
• Common assembly structure
• Common assembly modifications
• Managing database directories
• Protecting databases through backups

Module 2 - Advanced Database Management

• Modifying designation and specialized takeoff libraries
• Quick update
• Multiple adjustment columns
• Database utilities
• Screen styles
• Database queries
• Sort codes

Module 3 - Managing Database Pricing

• Price update
• Price updating methods
• Updating prices using CSV files

Module 4 - Power Substitution, Part 1

• Defining power substitution
• Planning, creating, and modifying power substitution tables
• Power substitution log

Module 5 - Power Substitution, Part 2

• Creating substitution tables
• Testing substitution tables
• Re-synchronizing and copying tables