Child ID Access

Hello, Ive got a report which contains activities and enrolled clients. A client can enroll in several activities. I have a function to count all attendees for all activities but I need a way to count all different attendees. eg, one attendee may attend 4 activities, i just want the report to count the four as 1. Is this possible? How can this be done? Thanks, Ant…

Use the SELECT DISTINCT sql query and then count the number of records returned.

Example: SELECT DISTINCT COUNT(attendees) as total FROM tblActivities

attendees would be the column that identifies the attendee and tblActivities would be the table where you are storing the info.

Microsoft wants you to buy 2007 but I don’t want it! I can’t even find a copy on ebay. Anyone?? I am really desperate.

Hard to find. I have been looking for a long time. What is available is way to expensive. I will continue to use MS Access 97 with my 2003 suite.

EDIT: Here is best deal I can find. It is for full MS Office 2003 http://www.softex-online.com/ProductDetails.asp?ProductCode=269%2D06738+%2D+OEM

I have a existing database with fields FirstName, LastName, EmployeeID. I am trying to move the EmployeeID field to a new table that incorporates VIN numbers of vehicles they drive by using the FirstName and the LastName fields for reference. I am using the FirstName and LastName but keep comming up with duplicates of first or last names that keep me from getting a complete list. Both lists have additional information as non driving employees and Vehicles without assigned drivers.

How can you use 2 fields in each table to identify the correct oinformation in each table?

I am new with Access 2003 so please forgive my ignorance.

Do I understand this correctly? I need to know how your data is currently structured.

1st table: EmployeeID, FirstName, LastName, plus some additional employee information

2nd table: FirstName, LastName, VIN?

My question is: What exactly does the 2nd table represent? Cars?

Are you trying to match employees to vehicles? If so, I recommend this structure:

Employee Info —-> VehicleAssignments <——-Vehicles

The purpose of the table called VehicleAssignments is to assign cars to employees. You will need to include EmployeeID and VehicleID (I suggest you use an ID as opposed to a VIN to uniquely identify cars) in this table. The ID fields, not the name fields, serve as the link fields between tables.

Let me know if you need further help!

Can someone provide me the complete tutorial of MS Access (beginner and intermediate level)

You can find the detail tutorials and examples of MS Access here
http://www.bcschools.net/staff/AccessHelp.htm#PrimaryKey

Okay so I want to filter a query, which I already did. I have check boxes for this column, and right now it properly filters out the unchecked boxes no problem.

My question is if there is a way to have the query automatically load filtered. Because right now every time that I quit out of the query or Access and reload it, I have to re-toggle the Filter.

Is there a way to have it automatically load with the filter enabled?

You can create a secondary query, that links to the first query but only displays what you want. When you start the application, make it run the filtering-query.

I’m trying to import an existing 4000+ Excel spreadsheet of contacts into a existing Contact database. Can anyone assist on the process of getting this done or do I have tp manually enter each contact?
Thanks

You should be able to import the data using file – get external data- and then choosing xls file type. If you can match the column names to the access field names it will simplify the process.

My Uncle wants help accessing his sister’s will. It is currently in probate which I’ve been told is public record. Where do I go to access this info and would it cost anything?

The office of the clerk at the courthouse of the probate court. Seeing the file is free. Clerks often charge a fee to make copies. Usually a buck a page.

I’m an intermediate user in access. I’ve designed and created a database using ms access 2007. This databse was created for the staff within a small company. Everyone has the access to this database with a windows password. The majority can only view the data (from forms) and print reports, while only a few people can insert/delete/update the data within the database. My questions are:
- how do i connect my database1.accdb to the company server so that everyone can use it?
- what is the purpose of splitting the database? Should i split mine?
- where should i go from here?

Thank you.

You need to save the Access database on the server in a folder where everyone who needs to access it, can. This is done by setting permissions on the folder where the database is. You will need to allow update permissions for those people who need to update the database.

The best way to implement this is to split the database so that the client (PC) computers only have the minimum in forms, code modules etc. that they need.

Each user will need a copy of Access on their PC to use the server database. The tables (data source) on these PC’s should be "Linked" tables (goto tables, right click on the table list and select "Linked Table". With client PCs using links to the real tables on the server, data is only held in one place.

Users who don’t update the database don’t need the forms that update so you will probably need an Update client database and a read-only client database. You distribute the correct version to the people that need them.

So…..each client PC runs your database but with links (Linked Tables) to the tables held in a central access database where the data is stored. The forms, reports and queries are stored in the client Access database. Only the data is stored centrally.

Hope that helps.

I need to do an assignment involving making a database using Microsoft Access but I have very little experience with Access. I have to make a table, and then make several queries from the data in the original table. Each of the queries is only supposed to have select data from the table. When I delete the data fields in the query that I don’t need, it will also delete those same fields in the original table. How can I prevent this, and additionally make several more different queries?

If you are running the query in the proper way you don’t have to delete anything. If for instance your Table has the following Fields; FirstName, LastName, Address1, Address2,Address3, and you are asked to find people with the last name Smith, click on ‘Query’ on the side panel and then double-click on ‘Create Query in Design View’. Click on the Table which has the information (if you have more than one Table) and click ‘Add’ . Close the ‘Show Table’ dialogue box. Under the LastName field, type Smith on the Criteria line and then click on the ‘Run’ button on the toolbar. The result should bring up anybody named Smith in your Table. Save this Query with an appropriate name and nothing will have been deleted from your Table. Carry out the rest of the queries in the same manner.

What is the fastest and more in depth way to learn MS Access? I want to have the right skills that would allow me to set up some slightly complex databases.
Many thanks

try online free tutorials.