database design

So I have a certain table-list, which will have data populated or deleted sometimes. I also have queried raw data. I want it to add 1 more column when 1 more record gets added to table-list and delete 1 column if 1 record from table-list gets deleted (it doesn't have to be certain place where...

Hello, I work for a the doctors' HR department in a hospital. This fall, we will have to review our systems and make a lot of changes. I was wondering if we should consider changing our database made in an Ecxel spreadsheet to Ms Access. Ultimately, we would like to be able to keep data on...

I am trying to build a database for my customers, where I can sort by very detailed info. I might have a customer (name - contact - address) all identical, entered 20 times, with one column (product) different in each row. I need to be able to sort the database by product - so as far as I can...

Hi Community, I am working on a database for about a week. This database is of a company which deals with creation of auto parts. Main needs of database are to record the date and project wise expenses which are (daily wages of labor, cost of machinery, and cost of material used materials are...

Hi there, thanks in advance for reading this. I have inherited a spreadsheet showing daily turnover that records the data and totals and displays it all in one sheet. It's a nightmare to try and make useful just because there are so many figures - 365 days with 8 departments, each comparing...

Hello All, I am new to Access, and I am starting to figure things out, working up to designing a database for my company. I am wondering if I am going in the right direction, or if it is plainly obvious to someone more experienced, that I will have problems down the road. Here is a screenshot...