Design Address Book

[LOAMA]

I am STARTING ALL OVER again to design my own address book using Access 2007.
I do have a table of some addresses, not all have zip codes.
What do I do first? I want to make my own format for the address and sundry
information. And I want a new page to start with each letter of the alphabet.
1. Do I make the form first how I want the address info to appear?
2. Do I design the "information form" on the report?
3. With the size paper (8 x 5.5) I am using I can put 5 records of each page.
4. So what should be my first step?

 

[Duane Hookom]

Have you looked at the free templates available at
http://office.microsoft.com/en-us/templates/CT101428511033.aspx?

If you don't want to use a template at least look at one to help decide all
the information/fields you want in your table.

After creating the table(s), I would design a form for entering the
addresses. Once this has been done, you can design the report to meet your
needs.

For the report, it might be easiest to first create a query that creates a
column containing the first letter of the LastName field.

SELECT Left([LastName],1) as SortAlpha, *
FROM tblAddresses;

Use the above query as the record source of your report. Set the first
grouping to SortAlpha. Add another sort on the full LastName and then
FirstName.

 

[LOAMA]

I think I am starting to understand something. Is the "FORM" only to enter
the data of the addresses? I thought I entered the data via the "TABLE".
The design I want the record to look like on each page is done on a "REPORT".

Is that correct?
--
Thanks for your help in advance,
LOAMA

Have you looked at the free templates available at
http://office.microsoft.com/en-us/templates/CT101428511033.aspx?

If you don't want to use a template at least look at one to help decide all
the information/fields you want in your table.

After creating the table(s), I would design a form for entering the
addresses. Once this has been done, you can design the report to meet your
needs.

For the report, it might be easiest to first create a query that creates a
column containing the first letter of the LastName field.

SELECT Left([LastName],1) as SortAlpha, *
FROM tblAddresses;

Use the above query as the record source of your report. Set the first
grouping to SortAlpha. Add another sort on the full LastName and then
FirstName.
--
Duane Hookom
Microsoft Access MVP

I am STARTING ALL OVER again to design my own address book using Access 2007.
I do have a table of some addresses, not all have zip codes.
What do I do first? I want to make my own format for the address and sundry
information. And I want a new page to start with each letter of the alphabet.
1. Do I make the form first how I want the address info to appear?
2. Do I design the "information form" on the report?
3. With the size paper (8 x 5.5) I am using I can put 5 records of each page.
4. So what should be my first step?

 

[Duane Hookom]

Most of us experienced (mature) developers live by:
- Tables are for storing records
- Forms are for all user interaction (navigating, editing, adding,...)
- Reports are for publishing records to paper or screen

--
Duane Hookom
Microsoft Access MVP

I think I am starting to understand something. Is the "FORM" only to enter
the data of the addresses? I thought I entered the data via the "TABLE".
The design I want the record to look like on each page is done on a "REPORT".

Is that correct?
--
Thanks for your help in advance,
LOAMA

Have you looked at the free templates available at
http://office.microsoft.com/en-us/templates/CT101428511033.aspx?

If you don't want to use a template at least look at one to help decide all
the information/fields you want in your table.

After creating the table(s), I would design a form for entering the
addresses. Once this has been done, you can design the report to meet your
needs.

For the report, it might be easiest to first create a query that creates a
column containing the first letter of the LastName field.

SELECT Left([LastName],1) as SortAlpha, *
FROM tblAddresses;

Use the above query as the record source of your report. Set the first
grouping to SortAlpha. Add another sort on the full LastName and then
FirstName.
--
Duane Hookom
Microsoft Access MVP

I am STARTING ALL OVER again to design my own address book using Access 2007.
I do have a table of some addresses, not all have zip codes.
What do I do first? I want to make my own format for the address and sundry
information. And I want a new page to start with each letter of the alphabet.
1. Do I make the form first how I want the address info to appear?
2. Do I design the "information form" on the report?
3. With the size paper (8 x 5.5) I am using I can put 5 records of each page.
4. So what should be my first step?