Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
You can either
Info

This page outlines how to create a brand new database from scratch

(the most common starting point) or, if available, open a pre-loaded database design.

Create a new database from scratch

. Alternately, you can clone an existing database and modify its design to meet your needs.

  1. Use one of these methods to open the Create Database window:

    • Click the Phocas menu button > Databases > New Database.

    • Click the Phocas menu button > Administration > Databases > Create.

  2. Enter a name for the database. This name should be user-friendly, as this is name that displays in Phocas. You can change this name later. The real, underlying database name is generated automatically and will be something like company name, an underscore and a number. This can't be changed and is not displayed to typical Phocas users.

  3. If you are creating a financial database, select the Financial Database checkbox*. Please read the Design a finance database for important information.

  4. Click Save. The  

    Image Added

    The Design screen opens on the Design tab, where you can proceed to add the data and ‘design’ the database. See Take a tour of designer to get an overview of this screen.

    Image Removed

Open a pre-loaded design (if available)

Some Phocas sites will have one or more 'empty' database designs pre-loaded. These designs provide a typical basic structure, into which you simply drag your data. To open a design, click the name. This opens a summary screen, shown below, where you can change the title, or display name. 

Select Design to start designing your database.

View file
nameInvalid file id - 58c9e484-7dc0-4acb-9b1b-113d9c2b10c7
tip
  1. Image Added

Info

*This option is only available if you have the Financial Statements license.

Related pages

Panel
bgColor#E3FCEF

Next step in the design a database process:

Set up the database.

On this page

Table of Contents
minLevel1
maxLevel2
outlinefalse
typelist
printablefalse
Panel
bgColor#E3FCEF

Video

Design your own
Add (connect) data to the database