A database is a file that stores all of the data used in On-Screen Takeoff such as: Takeoff, Employees, Styles and Style Sets, and links to image files along with all of the Projects created.  Creating a database is the essential first step to working with the On-Screen Takeoff.  There are two databases included with On-Screen Takeoff - one includes example projects, the other is a blank database where you can start creating Bids.

 

Some clients create a database for each employee, while others use one for each different geographic location, each office, or even a separate database for each Project.  Keeping your databases organized makes it easier to apply the default settings that match the needs of a particular project.

 

Whatever method used to manage databases, you need to understand:

The following articles detail these concepts.

 

There are two types of databases: Microsoft Access® and Microsoft SQL Server®.  The default is Microsoft Access - this type of database is suitable for a single user who stores their databases on their local computer.  To share a database among multiple users or store a database on a network, you will need to use Microsoft SQL.  Determine which type of database suits the needs of your organization and follow the directions provided in the following articles for creating that type of database.

 

Review the following Frequently Asked Questions for more information about database types and suggestions on use:

 

Creating a new Microsoft Access database

 

Creating a new Microsoft SQL database

 

Opening an Existing Database