I created a new table by importing the data. The text in some of the fields
are either in upper case or lower case. How do I convert the existing text to
proper case?

I have 3 tables. Students , Semester 1 and Semester 2
I need a query to list all students meeting a set criteria from table 1
(Studens) and data from either or both of the other 2 tables. The query only
gives me those students who are in all 3 tables. If a student is not in one

when printing document one or two lines will print different than rest,
looking like italics, i have been unable to solve this problem through
troubleshooting  cv

I have a database that works well, but I heard there are ways to have data
pull from previous record sources and auto fill based on the data in other
fields to ease the amount of data entry required.
Example: Order Entry Form (Data from form stored in the Order Entry Table)

i'm creating a table that records car sales.  my database has 4 tables: 1)
car manufacturers 2) chevy models 3) gmc models and 4) pontiac models.  in my
car sales table, there's a manufacturer field and a model field (both are
combo boxes).  i want the values of the model field ...

I have an alumni database and am trying to pull a report on grad year.  I
created a report for the contacts listed by grad year.  How do I tell the
report to just pull one specific grad year when I want that info?  For
instance, right now the control source says graduating class ...

I have a simple database that contains a simple form for updating records in
a simple table.
I am looking for a better way within the form to select the record for
editing.  At the moment I have a combo box which allows me to select the

[MINPEN]=.005
[MAXPEN]=0.020
[p1]=.075
[t1]=.060

Is there a domain function similar to SUM that can be used to concatenate
text of a field?
Such that one can query the table
ID Name

I always thought that whenever a combobox was used in a form the rowsource
should come from a lookup table. E.g. tblUOM 1. Each, 2. KG, 3. Case.   My
logic behind this was 1. It is centralised and can be easily updated and 2.
Storing an ID field (long number datatype) would use ...

Using Access 2007, I have a form with a subform.  The subform is seen in
datasheet view and I have used the built in total mechanism to show the
total count (computers) and sum total (purchase price).  This works nicely.
But since the totals are in the subforms in tab pages, they ...

I Run WIn2k with Access 2K
I am a complete novice with this program so I have a few questions.
Senario
I create a table with employee names (called "Names")

I am trying to create a simple access application, but all my clients do not
have Access installed in their machines.  Should I write the program in
access and put it in sharepoint(similar to form filling), so that all users
can report their issues simaltuniously without loosing ...

I'm an Access newbie.  I created a form and some tables and entered 400
records.  I went back in and added several rows to a table and now when I try
to go into my form to add more records I get the error "type mismatch in
expression".  I have no idea what to do.  I'm not a coder ...

i am taking a sample exam, and i need help please...
i have to use codes for 2 fields to replace shorthand text with its proper
term.. for example, i need to type in 'sf' and i every time i type this in, i
need access to automatically replace that with sales faculty