I was wondering if anyone can recommend a good book for learning more about Access?
I have basic experience with the programme, but am hoping to tackle the old 'questionnaire/survey' issue. A lot of books I can find on amazon seem to be set at such a level that I can already do (multiple tables, simple queries and reports), I need something a little more in depth. Others don't seem to tackle the specific issues I'm going to face (although I could be wrong about that!). Also, as I usually don't bother with computer manuals (I generally pick up and play with new programmes) I don't know which ones are best (e.g. Microsoft own, 'Dummies' etc)?
I was given this project and I'm not sure how to start it. I have a table (Employees) that need to receive salary increases based on their level. Their level is calculated based on their time with the company, but some are base on hours worked and some based on days worked. For example my table looks like this;
Name PSG Hire date Peter 037-30-1 06/01/2005 John 051-21-1 09/15/20005
There are different rules for the PSG, as I said earlier some calculate their level in days and some on hours worked. Example
PSG Level Rule 037-30-1 01 1st 1000 worked hrs 02 2nd 1000 worked hrs 03 3rd 1000 worked hrs 021-21-1 01 0 - 80 worked Days 02 81 - 160 worked Days 03 161 - 240 worked Days
I need to create a table or report that will populate the correct LEVEL to the employee depending on what their PSG is. Any ideas?
First of all, I had some experience many years ago with setting up a db. Nothing since, so if I am in the wrong place, please feel free to say so.
I am in charge of a very large list of people, mostly dead, for a historical society in my town, and much of the data is on paper or in Excel files. In order to get a handle on how to organize it in a db, I have been entering data from paper to Excel for some time. Gradually, I have been able to combine different things, and sort out data to fit in different tables. A person has personal info LastName, First etc, birth/death data, cemetary records, historical artifacts catalog numbers, military records (I know the height & hair/eye color of civil war vets!) of battles fought, medals awarded, ranks, etc, etc. It is obvious to me that a db would be a much better place to keep this data than in Excel, but that would require a db to be designed. I understand enough about dbs to start the process, but I still have a bit more parsing to do. (You wouldn't believe how many different kinds of information can be shoved into the Remarks field!) I have spoken with some people who work with dbs for corporations, FoxPro etc. and they agree that a db would be better.
The problem that they see (all claim to know little or nothing about Access) is something to do with the Primary Key. Let me give you an example: John Doe is a person who at present is assigned a personal ID. That ID goes everywhere with him because he is not the only John Doe. In fact I have 7 John Does, not all born in the same century, not necessarily related, hopefully with different birthdates, usually in a different grave, but sometimes the grave is unknown as with many veterans who died in prison, etc. and sometimes there is only an approximate birthdate or something like that, if I'm lucky. Also sometimes gravestones list children's names and it is unknown if the child is buried there or with their spouse. In the case of one woman, there are 4 listings as she was a daughter and married three times with a name on the stone of each husband. Of course, one can assume that she was not buried with the husbands who died earlier than the last one, BUT that is not always true, because sometimes women remarried other men for convenience but asked to be buried with their true love. See, it gets complicated sometimes and this was the reason I assigned each a PERSONAL ID. I had to find a way to reference each one to make sure that they were with the right persons.
For geneological purposes, it is important to have as many relationships as possible connected to each individual. One John Doe might have 4 children by two wives. Each wife has a husband and his ID as well as the children and their IDs listed, under the husband and son and daughter fields which include the husband, son, and daughter ID fields. My DB professionals say that that is a real problem. How do I set up a db so that I keep the correct husband with the correct wife without their respective IDs?
These IDs are a convenience to me as I enter data. They could be dispensed with once they have a Primary Key, AND are related to those other people. The trouble is, I haven't the foggiest idea of how I am going to get that accomplished when I transfer the data from Excel to Access.
And so I turn to you good people for some suggestions, even if it is to go to a different URL and bother them. Thanks in advance.
I am new to both Access and VBA. Can anyone provide any recommendations as far as good books on both Access and VBA, or either one seperately? Thanks for any help you can provide!
Recently I moved the back end of some databases I develop and maintain to a SQL Server for speed and stability purposes. Whilst this forum has been great for digging out answers to various Access problems I encounter, I persume there are some similar forums dealing with SQL. Has anyone got some recommendations ?????
Hi, I have been given an Access database to maintain and it has some performance issues. I have been looking through this forums for recommendatons regardng size etc but didn't really find anything.
It is all in one file (might consider splitting it..) and it has about 350 forms, 300 database queries, 130 database tables and 200 Macros!! Filesize something around 200 MB.
In one of the forms there is a drop down that when changed refreshes two other dropdowns. I have chyecked the queris used and they are really fast but it still takes at least 6-7 seconds for the 2 dropdowns to reload! I don't know if it is due to the way it is done, the VB code calls a macro that calls a query. Personally I wouldn't have done it like that but there has been about 2 years since I did anything complicated with access..
Or is it the size/complexity of it that makes it slow? Does anyone have experince of a similar system?
I allready looked at what was recommended in this forum - but I noticed there are only two books listed.
Are both of these books good for beginners or is the Access 97 Bible better? I have seen about a dozen of books and would like to have a few on hand to learn from and to reference as my skills increase.
I truly am after something that can give me a breakdown of the code in Access and what each line really means and the action it produces.
i'm looking for a really good access book that will help me progress my access knowledge i have an okay knowledge of access and wish to expand my knowledge futher any good books out there that can help i know their is hundreds of books but does any one have first hands experience of a gr8 book they used
DOes anyone have any examples that they are willing to post or links about how to build an appointment book in Access? I have tried google but I cant seem to find useful links.
I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc. How to do tht. thnxx
I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc. How to do tht. thnxx
I am looking for a good Access Book. At work, I have "Access for Dummies" and "Access2000 Step by Step". Are either of these good, bad, etc. What would you recommend. I am a begginner, but know some things, so I don't want something for real beginners.
In Acess 97 I have a single data base with 5 tables, Attorneys, Employers, Health Care Professionals and two others. All tables have exactly the same fields.
I am trying to create a “phone book” made up of all the records in the data base. The form for this phone book has only a few fields such as fname, lname, phone, address. It also has the autonumber field. The record source for the form is a Union Query. When I open the form it works well. I get lawyers, employers, doctors , etc. all in alphabetical order.
Here is my problem:
I have a command button labeled “View Record.” I want to be able to click on this and have it find the record in its original table and open the form for that table so the record can be modified (on exiting the record I have it requery so the phone book is updated).
I can only get this to work with one table at a time, that is, the table that is named in the event procedure code. So if I am in, say, an Attorney record and tblAttoney is named in the event procedure code, all works well. But if I am in, say, an Employer record I get a blank Attorney form opened.
How can I get it to trace the autonumber to the proper table and open the record . I assume that the autonumbers are unique ACROSS all five tables since they are in the same database.
hello, this is frazzling my brain i cannot comprhend the answer :confused: sorry werent sure were 2 post this hope this is the right place
I have an array of comics 300 they come out weekly, the first is Number: 344 this came out 26th September 1983, i have a form with a combo box were i select the comic number (344 - 700+) in this case i am selecting 344 and i press a button "command 11", i would like it to display in three text fields, date, month and year. This has well an truly killed off my brain. Any help would dearly be appreciated. Need any further information just ask. Paul
Just wondering if anyone new of any books that contain examples of code, functions, syntax, etc. I would like to have a good reference that I could go to instead of searching the internet everytime I need to try something new.
Ruralguy suggested that i made a new thread - so I'm taking his advice (H)
I've got another problem, well not problem..i want to make it more user-friendly.
Database= 21238 (Look for yourself see what i mean) (rename to .RAR if it doesn't open)
Basically, when the user adds a book, they can add it easily.. the only problem is, when ..just say i want to add a book, and I have 10 copies of this book, I have to add the book first and the go into the ADD_BOOK_COPY form and then select the book which i want to add more copies of and click add - i repeat this for the total amount of copies that i have. So if i had 10 copies of 1 book, i add, and then go into a seperate form and then click this button 9 more extra times. Which, can cause headahces!
So basically, i'm thinking of implementing a new way to do this, i was thinking about.. When i got to add a book, there's a List/Combo box with 1-20 into So i can add the book, and then select how many copies, click 'add' and this will add 20 copies of that bookm firstly by adding it to the 'book' table and then adding 20 copies to the book_copy table..
Is there anyone who would like to help with this? :' )
Hi all, Im updating my current checkbook registry database. Just want to be sure that table look ok to everyone before starting the coding process. This will be a multi user - multi account program. I have attached the relations diagram. Please give me some suggestions as to what fields i might need to add.
Hello !:) I need to make a SQL query in Microsoft Access. The database is in French but you will easily understand, if not please ask me to translate. You will find the MDB Access file inside the attached ZIP file.
The query I need to make is ::rolleyes:
We want for the next sent of books to the members of l’EST-SUD (WEST-SOUTH in English), to test the equivalences of the books.
We want to send for each book from the “genre” (theme in English) “Animaux” the most expensive equivalent book, we want to give a list with the original book, the recommended price (PrixCons in the database) and the most expensive equivalent book with his price.
-“NoLiv” is the book number in the database. -“TitreLiv” is the book name (title) in the database. -“NoGen” is the theme (genre) number in the database. -“NomGen” is the theme (genre) name in the database. -“PrixCons” is the recommended price for the book.
This is the query I tried, but it isn’t working ::confused:
SELECT DISTINCT * FROM LIVRE AS L, EQUIVALENCE AS E WHERE L.NoGen IN (SELECT G.NoGen FROM GENRE AS G WHERE G.NomGen IN ("ANIMAUX")) AND E.NoLivEq IN (SELECT LI.NoLiv FROM LIVRE AS LI WHERE LI.NoLiv IN (SELECT MAX(LIV.PrixCons) AS [Prix Max Livre Equivalent] FROM LIVRE AS LIV WHERE LIV.NoLiv=LI.NoLiv)) ORDER BY 2, 3;
SECTEUR (N°Sec, NomSec) ADHERENT (NoAdh, NomAdh, PrenomAdh, Sexe, DateNaissance, #N°AdhResp, #N°Sec) MEMBRE (NoMemb, PrenomMemb, Sexe, Age, #N°Adh) GENRE (NoGen, NomGen, Exemples) LIVRE (NoLiv, TitreLiv, ThemeLiv, PrixCons, #NoGenre) ENVOI (#NoMem, #NoLiv, DateEnvoi) ETUDE (#NoMem, #NoLiv, DateEtude, EvalEt, Commentaire) EQUIVALENCE (#NoLiv, # NoLivEq) Primary keys are underlined and foreign keys have a # before them
I have two tables. The ITEM RECD table containing the fields -- recd_invoice_ no, invoice_date,part_no,qty. The ITEM ISSUE table containing fields- issue_no, date, part_no,qty. The two tables are related by the part_no field.
How do I print a stock book type report for each item individually with all the recd item details on left side and the issued item details on the right side? All the recd & issue details for all dates need to be there in the report.
I wish to print the stock ledger from one transaction date to another with the last balance qty appearing as the first row with the “brought forward” message. The report would look like this:
TRANS <------- RECEIPT -----> <----- SALES ----> BAL DATE INV No INV Dt QTY INV NO INV Dt QTY QTY Brought forward 6 26/05/2007 ------ ------ ---- 2007/0002 25/05/2007 6 0 26/05/2007 0291 12/05/2007 27 ------ ------ ----- 27
I'm currently trying to make a simple phone book database that use queries to search through the records. I need to set the search parameters to pick up all records containing a value rather that just search for that specific value.
For instance if I type in "mic" and search I want all records containing mic to appear in results like mick and Michael.
Is there any way this can be done?
So far I have only tried the [please enter first name] method and this has been in successful.
My question is simple: I've got a database of my book collection. If i view it in a style sheet, it is something like
Author Title etc.
A 0 C 1 B 3 F 2 D 5 D 4 A 8 F 9
I would like to order the Author and Title columns (permanently). Particularly, I would like to order in alphabetical order all the authors and, if I've got the same author, order his/her book alphabetically, something like:
Is there a quick and easy (or not so easy) way to use Microsoft Outlook Address Book to populate a drop down combo box? I am creating a form that needs to pull in Business Process Owners, all of which would be in our corporate address book.
