You are here:
- Home
- Industry
- Data Management
- Database Programming
Database Programming/Questions Answered by Expert Marty Landman
| Subject | Date Asked |
| Access Database Design | 2/5/2011 |
| Q: I am trying to design a database that will allow me to track my costs per workorder I complete. So ... A: Cassie, I am not experienced with MS Access, although in principle it's an SQL based database like ... | |
| Access Database Design | 2/5/2011 |
| Q: I am trying to design a database that will allow me to track my costs per workorder I complete. So ... A: Cassie, Attachments don't work on the site that I know of. However in general you would write your ... | |
| normalization | 10/29/2010 |
| Q: I've a question about normalization(up to 3nf). Could you guide me how can I normalize this table: ... A: Tina, Given the data you've shown me the only further normalization I would suggest at this point ... | |
| Database creation? | 9/22/2010 |
| Q: My name is Kenya and I am an art student that was recently hired by a dog training professional to ... A: Kenya, I suggest installing Drupal on the website and then possibly using the CCK (content creation ... | |
| Finding Information | 2/10/2010 |
| Q: Good afternoon, thanks for the help. I'm hoping you can steer me in my search. I'm not sure this is ... A: Interesting perspective. I know when my neighbor's house sold last year I just had to call the ... | |
| Finding Information | 2/10/2010 |
| Q: Good afternoon, thanks for the help. I'm hoping you can steer me in my search. I'm not sure this is ... A: Tom, I guess even though the info you need is public, it isn't all available online - if I ... | |
| database | 7/9/2009 |
| Q: can i find work in database in Brazil or USA. what is the scope of database in Brazil and USA. ... A: Saeed, Freelance work which is what I do is getting harder to find right now, because of the ... | |
| DB Form | 6/12/2009 |
| Q: We need to tick several boxes from a choice of 10 in a form. So a combo/option/checkbox/list box is ... A: Maggie, It sounds to me like a checkbox would be perfect for your user interface. Look at the ... | |
| Password | 6/4/2009 |
| Q: I'm probally in the wrong place and if I am please tell me where to go. How can I change my ... A: Shawn, If you're running windows you'd boot up in safe mode, by pressing F8 while the machine is ... | |
| Database of emails | 3/24/2009 |
| Q: I work on projects where I need to email a particular message to between 100 to 400 web site ... A: Sort of. You could use a web scraper function which would probably have to be custom built to do a ... | |
| Choosing a database program | 2/23/2009 |
| Q: I have used a simple database years ago and I am no whizz or statistician. However now, I find ... A: Chris, First, I don't know SPSS. I do know that it is a canned statistics program, probably ... | |
| POS Database | 7/14/2008 |
| Q: I'm trying to make a POS point-of-sale software. I only know using ms access for database. Is ms ... A: Jeric, Access is a fine database - your most important decision might be which platform to use ... | |
| Calculating a business day | 4/18/2008 |
| Q: Do you know a simple method of taking a date and calculting 5 business days from that date? For ... A: Jill, You didn't say which database you're using. Mysql, like the other databases has extensive ... | |
| Skip Blank Line | 4/14/2008 |
| Q: .expert, I have a report, i would like to skip blank line records, how? A: Hasmukh, It depends. What are you doing specifically? What software are you using? Can you check ... | |
| simple database | 4/11/2008 |
| Q: not sure if I've found the right expert, but, I'm looking for a simple database program that will ... A: Johnny, Have you looked at Excel? This sounds like exactly what spreadsheets are designed for. Also ... | |
| Auto select items in a list box based on a combo box | 4/9/2008 |
| Q: . i have a small form based on a query, i have one list box of all names in the list and one unbound ... A: Yankel, Selecting on the fly is only possible using: 1) javascript 2) Ajax 3) server side ... | |
| ms access | 2/29/2008 |
| Q: I have a database from which I need to export data (a query)! The data needs to be exported in a ... A: Neil, I'm not familiar with MS Access' export options, however maybe this shareware product will be ... | |
| Oracle global variable | 2/18/2008 |
| Q: I having an oracle 3 tier design, i have a hp-ux based oracle database, and windows 2003 base oracle ... A: Ali, While I don't personally have experience with this issue I found a discussion involving what ... | |
| Suggest Database Software | 2/13/2008 |
| Q: I have been looking around at some different database software, but have not committed to anything. ... A: Pat, It doesn't matter which database you use, just as it doesn't matter whether you use Snap On or ... | |
| Query optimization | 2/12/2008 |
| Q: Wanna know some of the key points by which we can optimize a big query with so many joins,running ... A: Deepa, Start with these online tutorials http://littlelink.webtrouble.com/?WMQP ... | |
| access to web | 2/11/2008 |
| Q: I have a filter tracking database on access standalone. we put in air monitoring field data. Lab in ... A: Bob, With all due respect you will either need to get a bid from a programmer like me or have ... | |
| access to web | 2/11/2008 |
| Q: I have a filter tracking database on access standalone. we put in air monitoring field data. Lab in ... A: Bob, If by easy you mean is this something a person with no web development experience can do in a ... | |
| data security | 8/7/2007 |
| Q: I want to know about ; how we can secure our data base file, so that anybody can't open it. Can we ... A: There are two basic things you can do which I am familiar with. First, have an id and password set ... | |
| Maintaining a database on the web | 8/2/2007 |
| Q: What programs are available (and what is the best) for a db that needs to be web accessible? A: There really are a wide variety of options here. From the very simplistic such as my form to ... | |
| Mail Labels | 7/14/2007 |
| Q: I have a database completed of 850 names, addresses. I wish to merge this info to mailing labels. ... A: I would approach this by writing a simple program to print the data out, and then use the newline ... | |
| Inventory Database | 7/3/2007 |
| Q: Hey Marty, I have Microsoft Access 2003 and I need to create a database that will store all of the ... A: Jay, This involves the development of an application. What I mean is that you can input the ... | |
| Building a Database | 6/18/2007 |
| Q: I am planning to manage a website that stores client data (information) through forms, and also ... A: Avneesh, You may be in luck. I have an open source product which takes form data and puts it on ... | |
| SQL | 5/30/2007 |
| Q: I am studying IT and have an exam and I know I should know this but I have only just found out there ... A: Look at http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html and you'll see 12.2.1. ... | |
| database programming | 3/16/2007 |
| Q: I am using a vb data project. the database is ms access database. the problem arises when I try to ... A: What changed to make this a problem? Or is it possible that the data in certain rows was not right ... | |
| Access | 3/14/2007 |
| Q: Goodafternoon. Could I ask you one question concerning MS Access? I have one table A table with ... A: Can you please write back with the table descriptions for the two tables? Also with an example of ... | |
| Too much data for access database | 2/17/2007 |
| Q: Good morning. I have been requested to create training db. Been given list of employee names, list ... A: Lori, I would split this into multiple tables and find relationships between them through ... | |
| SQL date query question | 2/15/2007 |
| Q: How would I then get a list like this?: TOTAL_PRICE_PER_MONTH MONTH 100 ... A: Not knowing how the table is organized can suggest the easiest way would be to collect the ... | |
| SQL date query question | 2/15/2007 |
| Q: I have a database which has a list of products, then a list of the price of each product, and then a ... A: TJ, select sum(price) from _________ where transactionDate like '__/02/____'; assuming the date is ... | |
| powerpoint slides in MS Access database | 10/10/2006 |
| Q: Marty, this is difficult to describe. I guess I need a table with slides, but do I need to convert ... A: Suggest you consider using Open Office http://www.openoffice.org/ to convert your .ppt files into ... | |
| powerpoint slides in MS Access database | 10/10/2006 |
| Q: I have a project where I have about 200 Powerpoint slides and need to put them in a database so that ... A: Phil, Sorry about the false 'can't answer' reply. My mouse has a mind of its own sometimes. Not ... | |
| transferring excel spread sheet into a searchable database | 10/4/2006 |
| Q: I am cutting and pasting information from "yell.com" on potential advertisers for my company into an ... A: Michele, The answer to the questions is a resounding "maybe". It's possible to export data from ... | |
| HR Template Database Design | 10/2/2006 |
| Q: I'm looking for a Human Resource Database Schema. I've been looking on the internet, but cannot find ... A: Louw, Here are several including an Oracle DB demo - as you can see XML is the popular methodology ... | |
| BTRIEVE LOCK FILES | 9/26/2006 |
| Q: Good research. Thanks for the tips. I have tried everthing, including DOS emulator modes. I may ... A: Ted, I'm surprised you're being left high and dry like this, especially given the info I saw about ... | |
| BTRIEVE LOCK FILES | 9/26/2006 |
| Q: Do you have BTRIEVE data engine tuning experience? I have a ten year old DOS based accounting ... A: Ted, Although I am not expert at Btrieve I can tell you that a quick search showed this ... | |
| How to write procedure? | 9/13/2006 |
| Q: I need a script for the below raised question or can you give the concept for the below question.I ... A: This sounds like a merge application. It's a common problem in computer programming. Suggest begin ... | |
Database Programming
Answers by Expert:
Marty Landman
Top Expert on this page
Expertise
Database installation, analysis & design and programming questions.
Experience
Have done application programming as well as some installation and administration mostly with MySQL for web servers and site development and also with IMS and DB2 on legacy systems in the past.
Education/Credentials
MS in computer science.
©2012 About.com, a part of The New York Times Company. All rights reserved.