• Personal tools
  • Log in
• Navigation
  • Main Page
  • Resources
  • Recent changes
  • Random page
• Toolbox
  • What links here
  • Related changes
  • Special pages

Tables and fields

From GTwM

In a database, information is stored in tables. To be able to store data, create a table and add some fields as follows:

1. Create the new table
   1. Click on the 'Tables' section in pane 1 (the left of the screen) to open it up
   2. Click the 'create a new table' link and wait a couple of seconds for the table to be made
   3. To call the table something of your choice, click the Manage tab at the bottom right of the screen and type in a new name, e.g. 'stock prices'. The name will update as you type
2. Next, set up some fields
   1. Click the Fields tab just to the left of the Manage tab.
   2. Type in a name for the first field, e.g. 'company' and choose a type from those given, e.g. 'Text'. A description is optional. There are some field options listed which you can choose but don't worry about those for now. Click the Create Field button and your field will be added
   3. Add another couple of fields, e.g. Stock code and stock price, which would be a number
3. When happy with the list of fields, you can start adding data
   1. Click the Edit tab at the bottom of the screen, then click the green 'New' button at the top left of the screen to add a new record.
   2. Type away in the edit tab and data will be saved as you go. You should see it being saved in pane 2. Click the New button again to add more records

That's it, you've started using a simple table. You could now set up other users and give them access to it using the Administration section in pane 1, or look at creating more complex structures.