Simple database setup

%3CLINGO-SUB%20id%3D%22lingo-sub-1786868%22%20slang%3D%22en-US%22%3ESimple%20database%20setup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786868%22%20slang%3D%22en-US%22%3EHi%20all%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20new%20to%20Access%20and%20have%20watched%20A%20LOT%20of%20tutorials%20on%20YouTube.%3CBR%20%2F%3E%3CBR%20%2F%3EIm%20hoping%20there%20is%20someone%20out%20there%20that%20is%20willing%20to%20help%20me%20create%20my%20first%20database%20and%20get%20it%20up%20and%20running%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99m%20trying%20to%20achieve%20a%20plant%20and%20truck%20hire%20database%2C%20where%20I%E2%80%99ll%20keep%20a%20record%20of%20(tables)%3A%3CBR%20%2F%3E-%20Site%20Supervisors%20(employees)%3B%3CBR%20%2F%3E-%20Contractors%20(suppliers)%3CBR%20%2F%3E-%20Contractors%20plant%20and%20trucks%20(inventory)%3B%3CBR%20%2F%3E-%20plant%20and%20trucks%20master%20classification%20(each%20product%20is%20classed%20into%20a%20specific%20group)%2C%20eg%20machine%20capacity%3B%3CBR%20%2F%3E-%20Contractor%20insurances%3B%3CBR%20%2F%3E-%20plant%20and%20trucks%20attachments%3B%3CBR%20%2F%3E-%20Confirmation%20orders%20(effectively%2C%20what%20has%20been%20hired%2C%20by%20who%2C%20for%20how%20much%20etc).%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99m%20struggling%20with%20linking%20the%20tables%20correctly%20and%20then%20understanding%20where%20I%20actually%20enter%20new%20data%2C%20from%20what%20I%20understand%2C%20I%20am%20best%20to%20create%20forms%3F%20Eg.%20One%20to%20create%20a%20supervisor%2C%20another%20to%20add%20a%20new%20attachment%20to%20a%20piece%20of%20Plant%20and%20so%20on.%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20in%20terms%20of%20reports%2C%20I%E2%80%99m%20looking%20at%20what%20insurances%20are%20coming%20up%20for%20renewal%2C%20viewing%20what%20orders%20have%20been%20issued%20and%20whether%20we%E2%80%99ve%20received%20the%20required%20documentation%20prior%20to%20finalising%20the%20order%20eg%20timesheet%2C%20invoice%20etc.%3CBR%20%2F%3E%3CBR%20%2F%3EHappy%20to%20discuss%20in%20further%20detail%20%3A)%3C%2Fimg%3E%20thanks%20for%20reading%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1786868%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1788226%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20database%20setup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1788226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834575%22%20target%3D%22_blank%22%3E%40Aaron1040%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20this%20is%20NOT%20a%20%22simple%22%20relational%20database%20application%2C%20so%20you%20need%20to%20adjust%20your%20expectations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%2C%20ALL%20good%20relational%20database%20applications%20start%20with%20a%20proper%20table%20design%2C%20based%20on%20the%20principles%20of%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Faccess%2Fdatabase-normalization-description%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ENormalization%3C%2FA%3E.%20So%2C%20your%20video%20research%20should%20focus%20on%20that%20in%20the%20beginning.%26nbsp%3B%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20finally%2C%20asking%20someone%20to%20take%20this%20on%20as%20a%20volunteer%20might%20not%20attract%20a%20lot%20of%20competent%20offers.%20Professional%20developers%20must%20make%20their%20living%20doing%20that%2C%20and%20amateurs%2C%20who%20might%20offer%20to%20do%20it%20for%20the%20experience%2C%20might%20not%20be%20that%20capable.%26nbsp%3BTo%20be%20honest%2C%20if%20this%20is%20a%20tool%20you%20intend%20to%20use%20to%20support%20a%20real%20business%2C%20I%20think%20you'd%20be%20far%20ahead%20to%20hire%20a%20competent%20Access%20developer%20and%20pay%20them%20for%20their%20expertise%20from%20the%20start.%20If%20this%20is%20a%20hobby%20or%20practice%20or%20school%20project%2C%20of%20course%2C%20investing%20your%20time%20in%20learning%20how%20relational%20database%20applications%20work%26nbsp%3B%20is%20a%20good%20way%20to%20get%20started.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20searched%20for%20samples%20or%20templates%20to%20help%20you%20get%20started%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hi all

I am new to Access and have watched A LOT of tutorials on YouTube.

Im hoping there is someone out there that is willing to help me create my first database and get it up and running :)

I’m trying to achieve a plant and truck hire database, where I’ll keep a record of (tables):
- Site Supervisors (employees);
- Contractors (suppliers)
- Contractors plant and trucks (inventory);
- plant and trucks master classification (each product is classed into a specific group), eg machine capacity;
- Contractor insurances;
- plant and trucks attachments;
- Confirmation orders (effectively, what has been hired, by who, for how much etc).

I’m struggling with linking the tables correctly and then understanding where I actually enter new data, from what I understand, I am best to create forms? Eg. One to create a supervisor, another to add a new attachment to a piece of Plant and so on.

Then in terms of reports, I’m looking at what insurances are coming up for renewal, viewing what orders have been issued and whether we’ve received the required documentation prior to finalising the order eg timesheet, invoice etc.

Happy to discuss in further detail :) thanks for reading
3 Replies
Highlighted

@Aaron1040 

First, this is NOT a "simple" relational database application, so you need to adjust your expectations.

 

Second, ALL good relational database applications start with a proper table design, based on the principles of Normalization. So, your video research should focus on that in the beginning. 
 

And finally, asking someone to take this on as a volunteer might not attract a lot of competent offers. Professional developers must make their living doing that, and amateurs, who might offer to do it for the experience, might not be that capable. To be honest, if this is a tool you intend to use to support a real business, I think you'd be far ahead to hire a competent Access developer and pay them for their expertise from the start. If this is a hobby or practice or school project, of course, investing your time in learning how relational database applications work  is a good way to get started.

 

Have you searched for samples or templates to help you get started?

Highlighted
Thanks for the response and link.

Just using this as a learning experience to build my own knowledge and foundation, I’ll continue with the tuts.
Highlighted
I haven’t found a template that quite suits but have applied techniques similar to what I’m trying to achieve