Excel to Access and modification

[hyedipin]

Hello, great to be part of this forum.

I have an excel sheet with 9 Fields. It is like a customer database I put together. Anytime I have a new customer I add it there, and other fields are like phone number, person, address, email and notes.. that sort of thing.

I tried to move this into access.

I am not looking for an advanced setup, it has been a long time since I took access classes. I think easiest way to do would be as following: I found out that pre-defined "Contact Management" DB in Access would be suitable for me, with a slight modification.

I went to Tables under Objects, and clicked on Contacts table. I added new Column, and gave it a new name (let's call this brand).
Now, If I want this column's information on form view, how do I add new field into the form that retrieves information from table's new "brand" field.

I went into form design, but when I got to Database View instead of Form Design, the new column is not showing up there. How do I bind this new text field to new column?

Next step would be importing my Excel sheet and matching each column to what I have on Access <-> .xls

Thanks!

 

[pbaldy]

What version of Access? Generally, in design view, if the form is bound directly to the table, the new field should be available. If the form is bound to a query, the new field would have to be added to the query first. You would need to get out of the form and back in to see the new field.

 

[hyedipin]

What version of Access? Generally, in design view, if the form is bound directly to the table, the new field should be available. If the form is bound to a query, the new field would have to be added to the query first. You would need to get out of the form and back in to see the new field.

It is Access 2000. I will check as you suggested.

Edit: OK. I got it In Design View, I can select it from drop down menu under DATA tab. Thanks for your help.

I tried to design my own form, but I cannot find a way to use Form wizard to look like a one page form with all the information on it (like the one from template). So I modified the template to grab information from the new table instead of the Template Customer Database table. It works fine. I guess I will get the hang of this.

Is there anyway to make this executable like a single file (.exe) with a single dependent like a xls sheet or database and carry with me so I don't need to have Access to update my customer database?

 

[pbaldy]

No, an Access application can not be compiled directly into an exe. You'd have to write it in VB or whatever. There is a runtime version of Access available. The 2007 version is free, but previous versions required the purchase of a Developer package to get the freely distributable runtime version.

 

[hyedipin]

I understand. I used VB6 before but we never did DB on it. I may have to go back and check that.

Thank You, I am downloading the runtime right now.

I have another question, if you don't mind. Is there anyway to use Auto Complete in form view? As I type a name of the client, I would like it to give me drop-down options or auto-complete the name of the client in text field? I understand this may be very complicated to achieve.

 

[pbaldy]

It's actually very simple if you use a combo box based on the client table. With its Auto Expand property set to Yes, it will do what you describe.

 

[hyedipin]

Wow, Thank You. I am loving this Access.