Asking for help on Tables design

Hi, i’m trying to move my excel asset database to access. So far i have come with this two options for my tables. https://imgur.com/a/fKO0MVp Could you advice me on what changes can i do to my tables to improve them? Thx. submitted by /u/arkangelshadow007 [link] [comments]

Asking for help on Tables design

Hi, i’m trying to move my excel asset database to access. So far i have come with this two options for my tables. https://imgur.com/a/fKO0MVp Could you advice me on what changes can i do to my tables to improve them? Thx. submitted by /u/arkangelshadow007 [link] [comments]

Selling a Database

So I have spent the past few years working for a larger Corporation inside a department of 3-4 hundred people at my at my location. Recorded data is stored on a shared network drive in various hard to locate directories as well as few of the data collection platforms. Inside the data collection platforms you … Read moreSelling a Database

Selling a Database

So I have spent the past few years working for a larger Corporation inside a department of 3-4 hundred people at my at my location. Recorded data is stored on a shared network drive in various hard to locate directories as well as few of the data collection platforms. Inside the data collection platforms you … Read moreSelling a Database

Need assistance generating list

Hello – and thank you. ‚Äč I’m having issues with how I anticipate an outer join working. Tables – Properties and Values. Properties includes the Property unique key, street address. Values contains a unique key for each value for each property, foreign key that joins the value to it’s property, and a foreign key for … Read moreNeed assistance generating list

How would I write VBA code that automatically fills out one form field based on inputs entered into other various fields (in real time) but have the various field inputs update said field based on a priority? (clearer example inside!)

Hello! I have a question about how to set up some VBA code on an Access form. So I want to lock a field on a form for control reasons. This field is to display the Status of the record. There are 9 other fields that are all intended to have a number in them, … Read moreHow would I write VBA code that automatically fills out one form field based on inputs entered into other various fields (in real time) but have the various field inputs update said field based on a priority? (clearer example inside!)

Set of exercises?

Heya. Does anybody know of a free Access set of exercises? I need to learn Access for an exam at the end of the school. submitted by /u/Piotr_Skrobski [link] [comments]