I've recently taken over the job of technician for a small restaurant franchise company. I support 13 Micros 3700 systems, and 6 Micros 2700 systems. We do a lot of our daily and weekly accounting by hand, using numbers generated by the End of Day and End of Week reports. I'm currently developing a group of Microsoft Excel spreadsheets to streamline the process, and I would like to get it to import some of the data directly from the POS database.
My problem is, I don't have any formal training on the system, and I don't have any idea how the database is structured, or even what the password might be. I have a little experience with SQL, but I don't know what tables I should start looking in.
Any help would be great.
My problem is, I don't have any formal training on the system, and I don't have any idea how the database is structured, or even what the password might be. I have a little experience with SQL, but I don't know what tables I should start looking in.
Any help would be great.