You are here:
- Home
- Computing/Technology
- Oracle
- Data Management & Storage
Data Management & Storage/Questions
| Subject | Date Asked | Expert |
| POS and Accounting | 1/27/2012 | ScottGem |
| Q: I have an idea from creating a cloud based accounting software, Very similar to the intuit ... A: The cost to create such software depends on whether you will write it yourself or not. If you can, ... | ||
| query cost | 1/12/2012 | ScottGem |
| Q: I want to calculate the cost of the query without its execution from the information like how many ... A: First, what platform are you working in? Some database management platforms have tools to determine ... | ||
| Re:database | 1/7/2012 | ScottGem |
| Q: I would be very pleased if you could give me some suggestion as I am a student and I am very ... A: You could run your own server locally that is accessible from the Internet, but I don't recommend ... | ||
| POS software | 1/7/2012 | ScottGem |
| Q: I am not a computer egineer or any programmer. recently i was looking at some POS for my business ... A: POS software is basically a database application. You are recording your sales as transactions in ... | ||
| recover data due to system error | 12/12/2011 | ScottGem |
| Q: My friend set his computer to restore at an earlier date due to some problems he was experiencing. ... A: It does not sound like your friend did a system restore but a system recovery. A System Recovery ... | ||
| Entity Relationship Diagram question | 11/2/2011 | ScottGem |
| Q: I just want to ask you a question about the ER diagram. I am not sure if the part of sub type ... A: Doesn't look right to me. The Entity is crew, attributes of crew are job title or function (ex: ... | ||
| How to collate data from multiple to sources and where to locate this data? | 9/26/2011 | ScottGem |
| Q: I like to look at market statistic for a variety of things, from salaries to house markets, from one ... A: I gave you some tools you can use to combine multiple sources. I don't know of any free ones that ... | ||
| How to collate data from multiple to sources and where to locate this data? | 9/25/2011 | ScottGem |
| Q: I like to look at market statistic for a variety of things, from salaries to house markets, from one ... A: There are firms that sell lists of data. There are also web sites that have feeds that you can ... | ||
| Creating a small database for a charity | 8/2/2011 | ScottGem |
| Q: but are a small charity with just 4 part time staff. We're looking for the best/easiest database ... A: If its a simple matter of organizing contacts, then Outlook would be the tool of choice. But if you ... | ||
| work with more than two databases | 7/8/2011 | ScottGem |
| Q: I want to know how can i work with more than one databases at same time. Is it possible and if its ... A: You need to define this more fully. It is certainly possible to work with two databases at the same ... | ||
| MS Access VBA Programming | 6/21/2011 | ScottGem |
| Q: Hopefully you can help me. I do a lot of VBA programming in both Excel and Access but wouldn't ... A: "As for the dialog form issue, I am convinced that there is some way to make code pause until values ... | ||
| MS Access VBA Programming | 6/18/2011 | ScottGem |
| Q: Hopefully you can help me. I do a lot of VBA programming in both Excel and Access but wouldn't ... A: Well part of the answer is you have to stop thinking spreadsheet when dealing with Access. Access is ... | ||
| Data base integration | 6/16/2011 | ScottGem |
| Q: I work for a company that use a few data bases management programs. Vtiger for salesperson, Quick ... A: I know of no application that specifically works with all those. A lot depends on what engines they ... | ||
| Concatenate rows | 5/25/2011 | ScottGem |
| Q: This is a follow up question. I put a Debug.Print SQL before the line throwing the error. I'm ... A: you have to replace Conc with the name of the new function, and Jerry's code doesn't take as many ... | ||
| Concatenate rows | 5/24/2011 | ScottGem |
| Q: This is a follow up question. I put a Debug.Print SQL before the line throwing the error. I'm ... A: Hmm, First if you copied and pasted that there is a problem because there are no spaces. However, ... | ||
| Concatenate rows | 5/23/2011 | ScottGem |
| Q: This is a follow up question. I put a Debug.Print SQL before the line throwing the error. I'm ... A: Dalia, You didn't provide what I needed. Again, the Format expression in the function call converts ... | ||
| Access VBA issue | 5/23/2011 | ScottGem |
| Q: I am running vba that updates a large amount of records in Access '07 but in '03 format. Been a ... A: Is the database split?. I think what may be happening is you need to do a Compact and Repair between ... | ||
| Change in code for 'Date' field | 5/20/2011 | ScottGem |
| Q: Scott, you always helped me with my access questions. Thank you. I'm using the following code which ... A: Are you using the Format function within the function call? The Format function is converting the ... | ||
| Change in code for 'Date' field | 5/18/2011 | ScottGem |
| Q: Scott, you always helped me with my access questions. Thank you. I'm using the following code which ... A: No, you don't want to change the function, you want to change the data that goes into the function. ... | ||
| Change in code for 'Date' field | 5/17/2011 | ScottGem |
| Q: Scott, you always helped me with my access questions. Thank you. I'm using the following code which ... A: First, DATE is a reserved word in Access so should not be used as an object name. So you should ... | ||
| I am a caseworker for a contract company. I have a supervisor and then it is just me. I create my own way of doing things and as long as I'm doing my job, that's all that matters. Whatever works for me, I do. So, what I want to do is create my own website | 5/3/2011 | ScottGem |
| Q: I am a caseworker for a contract company. I have a supervisor and then it is just me. I create my ... A: First, since you are the only one accessing this, there is no need for a website. The major purpose ... | ||
| Data Mining | 3/23/2011 | ScottGem |
| Q: Scott, I work for a small company that collects a lot of data for certain manufactured goods, from ... A: The value of data has become more and more recognized in recent years. Even less than 20 years ago ... | ||
| Normalizing data | 2/17/2011 | ScottGem |
| Q: I need to normalize vehicle maintenance data from 1 large table and break it up into multiple ... A: What database platform will you be using? Once you have setup the database, you will be using list ... | ||
| Normalizing data | 2/17/2011 | ScottGem |
| Q: I need to normalize vehicle maintenance data from 1 large table and break it up into multiple ... A: Definitely normalize your data! But instead of trying to convert the existing data into a normalized ... | ||
| Lost Files | 1/12/2011 | ScottGem |
| Q: (I do not know much about computers, so excuse me if I use weird phrases and words) The other day, I ... A: You need to log in as an Administrator to first see if the files are there. Your new user account is ... | ||
| BKP Files | 12/20/2010 | ScottGem |
| Q: I have a folder In C:\ titled "C:\File Cache." The files are all .BKP files. There are 5,836 of ... A: Do you have a backup program running that is making automatic backups? Most likely that is what's ... | ||
| Data Architecture | 12/2/2010 | ScottGem |
| Q: My father worked with an insurance company for 25 years as a data analyst and architect before he ... A: I'm afraid I'm not that familiar with resources on those tools. Books from Que and Worx are ... | ||
| Data Architecture | 12/2/2010 | ScottGem |
| Q: My father worked with an insurance company for 25 years as a data analyst and architect before he ... A: Not too much has changed in architecture. Oracle and SQL Server have become even more dominant. But ... | ||
| Beyond MS Access | 9/19/2010 | ScottGem |
| Q: I have been a MS Access developer for several years. Many organizations seem to be using ... A: It all depends on needs. Access has always been looked down on by IT departments because of its lack ... | ||
| data transfer | 9/12/2010 | ScottGem |
| Q: I want to copy Word and Excel files from my old Dell Dimension 4700 computer that has a CD R/W ... A: CDs come in two types CD/R and CD/RW. CD/Rs are write once, CD/EWs are rewriteable. They work ... | ||
| data transfer | 9/12/2010 | Mehmet Orun |
| Q: I am buying a new computer and want to copy some Word and also Excel files to a CD disk and then ... A: You shouldn't have any concerns accessing files on a CD from one computer or another. This standard ... | ||
| oracle sql developer data modeler 2.0.0 and mysql | 8/18/2010 | Mehmet Orun |
| Q: Sir, I have installed oracle sql developer data modeler 2.0.0 on centos 5.0 . I want use this tool ... A: Can you provide more information? I understand you are on Linux and are using the Oracle tool. ... | ||
| Imaging and backup of hard drive | 7/29/2010 | Mehmet Orun |
| Q: To whom it may concern, I have above average experience with computers and run several at home and ... A: The easiest way of having a low downtime backup of a hard disk if another dies is to have RAID or ... | ||
| Transferring files from computer to computer | 6/7/2010 | ScottGem |
| Q: I'm finishing up my home schooling online program, and my school computer I need to return has about ... A: There are several ways to do this. You could burn to CD, copy them to a Flash Drive, copy to an ... | ||
| Have a btn that opens a form using a query filter, if the query filter returns no records then i do not want to display the form | 4/18/2010 | ScottGem |
| Q: I have a button on a Client form that opens a form with a query as filter. If the query filters no ... A: Sorry, but you are off the mark here. Yes, a -1 does indicate a True value. But you aren't using a ... | ||
| MS Excel | 4/5/2010 | Krishna Prasad |
| Q: I am setting up a database of customer names and email addresses for my small business. I exported ... A: Chad, In Excel, if you select the rows, at the bottom you will see the line that says how many ... | ||
| Normalization | 4/5/2010 | ScottGem |
| Q: I'm trying to normalize a group of tables to 3NF, but I'm having trouble figuring out the functional ... A: If you were not given a specific prupose for the database, then you had to select one of your own. ... | ||
| Normalization | 4/4/2010 | ScottGem |
| Q: I'm trying to normalize a group of tables to 3NF, but I'm having trouble figuring out the functional ... A: You still haven't explained what the tables are used for. pID is not a foreign key in either ... | ||
| Normalization | 4/4/2010 | ScottGem |
| Q: I'm trying to normalize a group of tables to 3NF, but I'm having trouble figuring out the functional ... A: Well your first problem is that you have no foreign keys. There is no relationships between tables. ... | ||
| opening transfered files | 3/21/2010 | ScottGem |
| Q: i have transfered all my files from my old windowsxp computer to my new hp touchsmart windows 7 ,my ... A: Probably. Data files from a proprietary program cannot be opened in another program. You need to ... | ||
ScottGem
Top Expert on this page
Expertise
I have been an IT professional for over 16 years. During that time I have accumulated a large store of knowledge and experience. This allows me to assist with a large variety of technology issues. My specialty is Database design primarily with MS Access. However, I can answer questions on many different IT related topics.
Experience
I have worked in IT support for over 16 years. I have also helped people in cyberspace for a good portion of that time. I have been a volunteer staffer on Prodigy and AOL. I was the #2 ranked expert at AskMe.com (#1 in Technology) and am currently ranked at or near the top at Answerway.com and PointAsk.com.
©2012 About.com, a part of The New York Times Company. All rights reserved.