Recent content by Opcode

Thanks for the answers. I know that Access is limited, but that is what we are using in class. Actually, I was hoping to use my new Access skills in the Web programming class. At this point, though, this has become such a time suck that I had best do something else. My assignment is due tomorrow...

In addition to my Intro to Access class, I am taking a Web Programming class, which has the same general assignment, but for Web pages, instead of an Access database; create at least 3 pages, 1 each for financial data, customer relations and product/service info. I would like to create a small...

I have a tblCustomer table to track customer information. One field is for flights the customer books. I expect that a customer might book more than one flight, which should affect what he owes. (My tblFlights table includes fields for the cost of each flight.) How should I make the Flight field...

I've described my class project in previous posts. Briefly, I chose to create a fictional airline. I have to include a way of relating financial info. I want to take values from various tables, perform calculations on them and use those values in other tables. In particular, I want to use the...

Wow, thanks wmphoto! I appreciate all that input!

I was going to ask a similar question for my project. Should I create a new thread for my question?

I suspected that Lookup Fields should be limited to simple tables with only a few options. But, how do I link a tblCertifications table to tblEmployee? I think I want to use the certifications to determine who is qualified to do various jobs for the airline, so I would probably want to do...

I am working on my final project for school, and attempting to fulfill the criteria that states, "Use as many Access tools as possible in your database." I created a table for employees of a fictional airline. I want to track their certifications. Of course, employees could have many roles...

Oh, that's a good start, but it raises more questions, too. Access told me that I had to set the fields in both tables to the same type; originally, one of them was a text field, and the other an autonumber field. So, I changed them both to autonumber. The thread you linked also mentioned...

I created a database with 10 tables and 8 relationships. Then, I learned about the Autonumber field type and decided that I wanted that to be the primary key of one of my existing tables, for a field that was already linked to 2 other tables. I had to delete the relationships and the original...

Hi, I'm taking a college class in MS Access 2010. Our class projects are due next Wednesday (5 days from now), so I'm working on my project. This is the only thing I've done in the class that is not explicitly planned in the textbook, and I'm suddenly discovering that lots of things don't work...