Search results

I have a student database (Access 2007) and on the student information form I have it filtered so that only the active students are shown. The filter is on the "Data" tab on the property sheet. Although I could filter this out on a query, I do it this way because I sometimes want to have...

I'm trying to create a report that contains data from a table but I want to include different records for the same userID. I created a subreport to display some marks, linked the userID fields and it seems to work, but I also want to be able to format it in a specific way as it creates a long...

I'm not even sure where to begin with this question, but I would really like to know what's involved i. creating an online database. Details: I already created an Access Student Database which works well (for the most part) but know I've been asked to create a database which can be accessed...

I created a simple query which used two separate tables and was able to filter the results that I wanted. However, I want to be able to edit the results in a form, so of course I can't used a query to do this. I was wondering if it's possible to create a form that filters the form based on a...

Perhaps this is the wrong forum for posting this, so I apologize in advance if that's the case. I'm a novice Access user (for a few years now) and I'm wondering if there is a better alternative database program for what I have in mind. I'm actually very happy with how easy Access has been for...

I'm trying to create a report from 10 different sub-reports, but I'm running into a formatting problem. I tried inserting the reports by using the subreport wizard as well as just dragging them into a blank report. The first sub-report looks fine, but the ones following start overlapping. I...

I'm using a simple query to enter data into a table and I was wondering how I could sort data that's coming from another table so that when I select the data it's easy to find. I know that I could use the wizard tool to do this within the table, but I don't want to do this because I've had...

I'm not sure what to title this one, but I'm looking for a solution to calculate dates depending on certain criteria. First the background. I'm creating a birthday list for students. Each student attends class once a week on a specific weekday (Monday to Friday). I need to figure out a way to...

Is it possible to use multiple tables in a tab control? I don't mean using inserting subforms, but rather a different table entirely. For example, I have a form where you can enter in Student information, and I want to put Class information on a tab form so that the user can quickly tab over...

I've been trying to learn Access 2007 for awhile and one item that I have run across a few times is the lookup function. On the surface, it seems like a wonderful feature because instead of looking at number IDs, you are looking at meaningful data. However, I have noticed that many people...

Does anyone have any idea on how to go about creating a report that lists a traditional style class schedule? I would like the times on the X axis and the days of the week along the Y axis. Ideally, the name of the class and student list would be included. I have all this information in a...

I created a list that grades students and I would like to be able to print out a report on a particular student that shows those grades in more of a graphical representation. I originally used word to do this and all I did was create a heading that listed the marks along the top and the...

I'm trying to create a simple chart in Access but I can't seem to do it. I can create it very easily in Excel. It's just a simple posting of values that I want to give a report on with every record. I'm including an example of what I would like to do...(but with ACCESS, not Excel) It's...

I'm really new to making databases, so I apologize if I say something really ... stupid. I know that you're supposed to normalize your database, but I was wondering how far you should go. For example: If I make a school database and in the student table I create a field called "Address"...

Hello! I'm a new member and I have started to learn Access because I want to create a database for the school I'm working at. I've been watching a lot of videos to get started right, and was directed to this site from one of the videos. :D I was very excited to learn that there is a site that...