how long does it take to make a database? (1 Viewer)
- Thread starter wasd
- Start date
swagmeister
Active Member
- Joined
- Oct 4, 2014
- Messages
- 524
- Gender
- Male
- HSC
- 2015
Lol no, not unless you have made a few before. Database work is tedious and normalisation takes quite a while.
Speed6
Retired '16
- Joined
- Jul 31, 2014
- Messages
- 2,949
- Gender
- Male
- HSC
- N/A
How old is your teacher?
obliviousninja
(╯°□°）╯━︵ ┻━┻ - - - -
Schema will probs take a while. Rest is pretty straight forward
Totally agree with sweigmaster. Database making is super tedious and long. You probably wouldn't think it is (cos I didn't lol) since it's just punching in some random details, but entry takes a while. Especially since you've got different stuff linked together and yuh.
Having said that, data-entry usually takes the longest (I'm assuming you're creating a make-believe database for IPT) as you need to consider the various fields an actual organisation will take.
Creating queries/reports are not that bad if you're OK with the standard types. If you're inserting banners/ customised headings etc, formatting also takes a while. If you're using Access, it's better if you can export it to a third-party software to manually code it (if you're good with that sort of thing) because then you can do tons of things with it.
Access does the schema for you automatically, as long as you're entering relationships correctly. (Pretty sure it's just toggling another view).
OH and if you're using Access but haven't used it before, it takes a while to get used to it. (for me, at least).
Having said that, data-entry usually takes the longest (I'm assuming you're creating a make-believe database for IPT) as you need to consider the various fields an actual organisation will take.
Creating queries/reports are not that bad if you're OK with the standard types. If you're inserting banners/ customised headings etc, formatting also takes a while. If you're using Access, it's better if you can export it to a third-party software to manually code it (if you're good with that sort of thing) because then you can do tons of things with it.
Access does the schema for you automatically, as long as you're entering relationships correctly. (Pretty sure it's just toggling another view).
OH and if you're using Access but haven't used it before, it takes a while to get used to it. (for me, at least).
It really depends on how large the database is, but I dont think two days is nearly enough even with Access. You need to really plan it out well, because it's the type of thing where if you dont think ahead, you're going to have to redo quite a few things, which can be super time consuming. I should note that I'm not IT trained nor have I done IPT (I did do a unit in uni though), but I have built a HRIS (i.e. HR database) for a mid-size government department (800ish staff with around 70+ fields of data). To give you an idea, it's taken me about 40 man hours to build and I'm still modifying it at the moment.
The most difficult thing is probably importing all the data into the program, because you need to ensure data quality and consistency. Also, building forms is quite tedious, especially if you want to make changes afterwards. To be honest though, this is hard to avoid, because some things you just dont really realise until you are actually using the database.
The most difficult thing is probably importing all the data into the program, because you need to ensure data quality and consistency. Also, building forms is quite tedious, especially if you want to make changes afterwards. To be honest though, this is hard to avoid, because some things you just dont really realise until you are actually using the database.