|
Type keyword or phrase to search:
My Articles...
Resources
I have other resource websites and social networking sites for you to browse...
Blog, articles, video tutorials
Access Database
Tutorial Blog
Contact me on Twitter
@benbeitler
|
Multiple queries in access?
I have created a table in access. Within that table I have a number of columns with info in each. This is being done for a dance school to categorise which students take what classes. In the colume named Term 1 i have abbreviated class name to initials such as SC, then i have created a query matching that abbreviation so it will show me what students take the SC class. HOWEVER, what happens when a student takes more than one class and i have to put in more than one abbreviation? I tried separating them with comas but it didn't work, any suggestions please?Thanks, but can you explain that in plainer english for the idiot in me Where exactly do i put the ? i put it in the column where i have the abbreviated class but it didn't do anything.
How do I make a query using calculations from another query in access 2007?
I need to find an OR query but the information is from another query and it doesn't run properly. Help?The query uses info from my main table and another query used for calculations.. if I run it as an AND query it's correct but whenever i try to do an OR query it doesn't recognize the command?
How to make a parameter query in access to find all customers with a birthday in any given month?
How to make a parameter query in access to find all customers with a birthday in any given month? it must be able to find those who live in a particular area.
To have a query in Access 2003?
In access i have made table which contains a lot of records. Now what i want is to have a search query which asks me about which name i need to have detail information...
What is a database query in Access?
In Microsoft Access, what is the basic definition of a database query? I'm sorta new to learning it at school so dont go technical.....
Why don't any results show up when I run my query in Access?
I have a computer class assignment to create a hotel database using access. It doesn't have to be accurate info. I'm just making up things that might be in a hotel database. So I have four tables including Customer Information, Reservations, Hotel Locations, and Rooms. I've established relationships between all four tables. I created my query with query design. I used the customer info and reservations table and used the customer name, check in date, check out date, and room number feilds. Everything seems fine. I press " run" and it seems to work but then I have just the names of the fields and no data in the chart. Yes, I do have information in those fields already entered. So I don't understand why nothing shows up when i run the query, Help???
Querying in Access! Please Help!!?
How do you query a column so that it shows the count of numbers in one column that are ranked higher than ones in another column? I have the table made for me and the question reads, " How many banks are ranked higher in 1984 than in 1983?" How do you do this? Please help
How could I set up automatic update queries in Access 2003?
I am trying to build an Inventory database. One query, an inventory list, will contain the items that have been received as sorted by name as the primary key, along with quantity, unit price and extension price. Another query, a receiving query, will then be used to update it. When I update this other query with an ItemID, name of the item, the quantity, the unit price, and the extension price, I want this quantity and extension price to be added to the quantity and extension price fields within the original query. The original query will then calculate the unit price, which should be simple enough extension price quantity in the original table . Another query, a delivery query, will do the opposite of this. Instead of adding quantity and extension price when the record is added to this table, the quantity and extension price will be subtracted.For instance, if I buy 1 pen, I ll enter the name, quantity, and extension price on the receiving query. A record on the inventory list query will then be updated with this information. Next, if I buy 2 pens for $3.00 each, with a total price of $6.00, then the inventory list will update to show that I now have 3 pens, with a total extension price of $11.00 and a unit price of approximately $3.67. Now, if I were to update the delivery query with a new record, where I take away 1 pen that costs $3.67, the quantity of the Pens will be reduced to 2, their total extension price to $7.36 and the unit price to $3.68. I hope that s a clear example it s hard to describe it well without diagrams.Is something like this even possible? How could I go about doing this? Would I have to use VBA SQL? I really don t know what to refer to in trying to find self help for this situation. Any help on the matter would be greatly appreciated.
Pre Filter Queries in Access?
I have an Access database that requires an user ID and password for each of the users. I have various reports that are based on queries that currently shows records grouped by user name. I would like to pre filter those queries with the user id the user uses to log in in order to only returns records that are associated to that user only.Thanks for your help..
How do i setup this if statement for my query in Access 2007?
I am setting up a formula for a late fee for a book which is returned late. My if statment looks like this. IIf ReturnedDate> DueDate ," ReturnedDate DueDate 0.75 and IIf ReturnedDate DueDate ," No Late fee" Please help me to put in a format that it should work in my query. I am have argument problems. Please help
How do i create 2 input query in Access 2007?
I have the follwing Fields CoursePrefix, CourseSection , Phone , Student ID , Last Name , First Name , CurrciCode. I want to be able to ask user for Course Prefix and Course section and and then display related info in the result.Please let me know if you need any other information.
|
Books
The following books are my personal recommendations for all levels of Access database users and developers.
Enjoy!
Access 2007
- Dummies
This is a great book for beginners. It takes you through from the very beginning without too much jargon 'computer' talk and adds a little humour to your learning.
This is one of my favourites and is a starter recommendation for my students.
Access 2010 Bible
Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology.
You’ll want to keep this soup-to-nuts Access reference close at hand!
Access 2007 VBA
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object–oriented programming and ADO. Two comprehensive case studies presents you with the hands–on experience in building real–world solutions using the concepts covered in the book.
It's the one I use as a reference for VBA students!
|
