timothybard

Hi all; I’m a newbie here and it looks as if I might be able to get a bit of advice on what I think should be a fairly simple project that would actually have some value in my real world if I managed to get it working. I have …

Hi there, I am a complete newbie and need help with normalization and ER diagram. here is the case study: a college specializes in providing foreign language courses at various levels to the general public. it consists of several local centers in and around the city. at present, course enquiries …

I am tasked with designing a dating site in asp.net with VB using sql server 2005 as the database platform. I have not had a lot of advanced database design experience so I am hoping someone can help me out with this one.... For each user there is a profile …

Hi I have made lots of Access databases over the years but it seems I have fogotton lots of basic principles since I have not used it for ages. One thing I want to do is: For instance when you send an email using Yahoo or similar webmail if you …

Can anyone help me with the database structure of a personal finance application?

"Good Day.. Its my very first database project and I am really excited about it, trying to make for myself… I am an insurance manager and also learning access through free resources like training videos on youtube etc.. kindly help me on my problem Two Tables, tblContributionRegister & tblAgentDetails. tblContributionRegister …

Don't know if this is right place for my question, but Does anyone know if it is possible to have multiple forms visible at the same time while developing an application with Access in "Form View" mode? If so, how does one tell Access to do this? This applies to …

Hi, i've googled and found out that the max storage of MS Access 2007 is ~2GB. My database suppport attachment, so hypothetically, if the attachments after insert >2GB, how can I allocate more storage to the db? is there a way?

I wish to design a timetable for a school department. The timetable will have rooms (various), times (various), lecturers and subjects. There must not be a clash in rooms whereby a room cannot be booked at the same time as it is already booked. Can anyone help? Many thanks in …

Hi, I need help bad, im trying to make an E-R diagram from the following: The City House Service (CHS) is an onoprofit service that advocates the development and inprovement of low-income housing. The CHS operates in a metropolitan area of approx. 2.2 million people in a mid-west city. The …

I have a database set up in Access. Currently I have 12 exact copies so individuals can enter data. We use the data to fill in multiple forms. I know that VB can be used to allow everyone to access one database. Does anyone have this as a runtime module …

I am in a car club. We have a LOT of people and even more cars that they own (or have owned):icon_rolleyes:. I would like to make a database of each members car, year, make, model, body style, date purchased, date sold, member information. So...... I am stuck :$(why, of …

hi i am a new access user and i have been asked to create a database for students in our college. well i never knew i would need to to alot of work but clearly i can barely start. i need to put student details i.e name, age , class, …

imaginary language into java. I have everything down except for the symbol table. I am currently making ERD diagram for a library . The entities are below: Entity Attributes Member memId, memName, memAddress, memMaxbooks Book isbn, bName, datePublished, pubId*, ageLower ageUpper, value Copy cId, isbn*, dateAcquired, dateDestroyed Loan memId*, memId*, …

Hey, i am trying to convert a 2D array to a 1D array and also the reverse. Not sure if i am doing it right so does anyone know how it can be done. below is the code i have for 2D to 1D but now how do i do …

I would like find out is it advisable for me to have the city and province on a seperate table and then link them to the country table. This is because a city is govern by a mayor where else a province is govern by a governor. [B][U]country [/U][/B] - …

I am starting on a next to impossible journey to build a database with many records and with relational databases at a later date possibly. The primary database I am going to build will have approximately 10 million records in it. Each record will have 75 - 100 items of …

In defining MS Access tables where a 1 to many relation exists what is the best way to define a table containing the “many” records. For example, a database with orders and line-items might have the “line item” table with an order-number and a line-number which would define a unique …

Hello I'm designing a database for my Computing Science department and I am having some trouble with the ER Diagram. Any help would be great appreciated. What I have so far is: Each course has a ID Code, title, is taken by one or more students and is taught by …

I face the below error message, when I attempt to mount an Access database "Microsoft Access has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to Database Utilities and click Compact and Repair …

Hey guys, I'd like to create an access database for a vaccine clinic I am managing in a large slum here in South Asia. So basically I want to create a form that auto-populates. Say a baby comes in: I open a new form, assign a unique id (probably the …

I am fairly new to mysql and wanted to practice making a database and tables. As well as filling the tables with made up data and then practicing queries. I wanted to emulate a real life database project. So I decided to make a database for a Car Dealership. the …

Hi I am sitting with an flat db file, and need it converted to 3NF Example: ProductID Published Title Authors 1 2000 Car Mech. Bill Meyer, Peter Daniels I have split this structure in 3 tables: Book Author Author_Book In Book I have the following fields: (PrimaryKey)ProductID, Producttitle, Published. In …

Hi all, I'm just starting to dabble in databases and I'm a little lost. I have a couple of questions: I have two excel spreadsheets containing employee records & equipment records respectively. For MS Access, I simply import these spreadsheets into MS Access. Is this the way to do it …

I have a problem with creating this database. I want to create the student record system. I have a table containing Individual information and using of ID as primary key. For registering grades I use another table for grades. But here is the problem. Here we have 6 or more …

hello , i have the following accessdatabase access database name = surya table name = collection field 1=id field 2=date field 3=customer field 4= amount i want an asp code were i will input from date to date to search the table collection and to display all records in between …

Hi, I am new to Access 2007. I have two columns in my table, Make and Model. The Make column is a lookup from a Makes table which has different makes of computer (Dell, Toshiba, etc...) in it. I also have a Model column adjacent to it which is set …

hi friends, i have created a table in ms-access. it contain 7 fields. in it 1st field is customer_id which is set as autonumber type. now i have a doubt of how to provide the value to this table. i dont want to overwrite the autonumber field as well as …

I Have a access data base, and have a field "Card No" if we think starting no is 1 and ending no will be 20. some times some numbers are missing and some are not in this range, ex. 21 How can I make a missing no report?

I am new to databases, this is my first attempt at one. I coach a girls softball team and I am trying to put together some useful stats from the tables that I have made. I have several tables of data, 4 or 5 quries, 3 or 4 reports and …