Search results

Hi there, I am getting an error when i try to make an MDE file I have a database that is split into forms and back end tables. I get an error that i have too many forms or modules( i only have around 30 forms) , is there a limitation to the number of forms or module you can have in order to...

Hi there, I have a table, where the PK is an autonumber, but i also want to put a unique constrain on a combination of two columns to ensure that someone doesn't input the value(combination of the two columns) that all ready exist in the table , is this possible in access? Cheers

Hi Everyone, I have this sales tracking dB where i track sales and return for the ee's , I am trying to write a query where i would take the total sales for the month and the total returns(returns categorized by electronics and non electronics) and work out a %(i.e. in the dB employee DBOS has...

Hi All,:confused: Can anyone please help me understand out of the two schema's which one is correct or are they both correct, which one will be easier to write SQL queries against, i tried writing an SQL query against Schema1 that would give me the CAR ID, Service Initiated By's first, last...

Hi there, I am practicing database design , and i have come across a situation in a practice database that i am designing where i have 3 tables , EMPLOYEES, TEAM_MANAGER, SALES and i have a report for total sales for each team manager for each month. Initially i had one to many relationship...

Hi there, I am developing a new dB and i am trying to link a table from an existing database, my problem is that the table in the existing database is not normalized, so i am trying to normalize the table in the new database and link fields from the existing table, is there any way that access...