Getting started with Microsoft Access

Is there a way to remove all spaces and special characters from a field in an Access database or Excel spreadsheet so the field?  For example, Change the expression Lewis, County of  to  LewisCountyof.  Please let me know if this ...

hello how are you, Can you tell me how to build a database in Access to track Product inventry, Employees Payroll information.Customer History, sales recourds useing a acccess templeate. WHICH ONE CAN I USE Because every one that I try It does not work for me because does not record all the ...

I was talking to Ken Sheridan on 1/9/07 about my packing slip.  I have made my packing slip but the information doen't automatically fill in from the shipping log.  How do I do this? Thanks Jane ...

I would like to add two extra text columns to the issues table (from the Office templates collection) and be able to complete these fileds using the issues form. I can create the new columns, no prob, but cannot make them work in the ...

I am exporting the results of a query as undelimited text file. I have used the query to format some of the fields to "fill" the field with leading zeros (Using Format(Int(Query1.INPNADAT),"000000") AS INPNADAT The fields appear perfectly when I am viewing the records in the Export Text ...

I have CD's from a conference.  I can listen to them but how do I see the outline and graphics. ...

I am trying to create a formula for validation Value of a field called sngPatientAccount. It is a number(single) field. The number can be a length of 4-10 but those of length 9 or 10 must begin with a 3. Here is what I am ...

O assunto é o mesmo do texto acima: Porque aparece #nome? em minhas contas do Livro Razão. Claro que é pedir demais que um cidadão limitado estadunidense entendesse o que escrevo em portugues. ...

I am building a database that will have: tblCustomers (PK CustID) tblPets (PK PetID 2ndKey  CustID -- many pets may be owned by each customer) tblVisits (PK VisitID  2nd Key CustID -- each customer may have many visits, and each visit may involve many pets) ...

Is there anywhere to get nicer web site templates for publisher 2003 -- thanks for helping from Elizabeth R ...

I am a fairly new access user. In the last 3 months I have built 1 database and have started on a second one.  The first one is working adequately, but still not doing exactly what I want and I am having ...