Database Management and Training
A database is a computer program (software) that stores and manages data. It allows you to be able to sort through data quickly and view it in different ways.
Databases come in different types. Flatfile databases (not the most efficient) and relational being the most common. Databases consist of one or more table into which data is added. Tables can be linked to make your database more efficient.
Usually databases come with different views, table view (which looks a bit like an spreadsheet) and form view (which shows you one or multiple records at a time).
There are different things to consider when creating your database.
- Data is held in fields in a table
- What the fields are called
- What data type the field is i.e. does it act like a character or does it act like a number
- How much data a filed can hold. If you make all fields large the database has to reserve that space for every record regardless of if there is any data in a record for that field. This make the database large in size.
- Can there be more than one instance of the same data in that field on another record
- Does the field need to be formatted in a particular way
FourThinking can help you to understand all these issues and help you to construct your database so that is works in the most efficient way. We can also help you construct a large database and teach you how to develop this yourself
Different types of database programme training
FourThinking can provide consultation and training in Microsoft Access, Sage ACT! and mysql. For more information on Sage ACT! click here.