Dont know how to create database

M

Michael

Can anybody help me with my Database this time ?
I want to creat a Main window where i have two command buttons. When i click
on the first one theres gonna appear another window where i can entry the
data. Lets say i will put in there name, phone no, post code and unique
number. The unique number is my priority. Afterwords i punch in the second
command button on the main menu and than i will have a new window with
textbox where all i need to put in there is the unique number and
automatically after Enter i will b trasfer to the Excel file with all details
about number i have just put in. Ive got lots of already prepared excel
sheets nut i dont know anything about Queries and Micros. Its so annoying...
i am so stupid its pathetic. Can anybody is able to help me with my project ?

______________________
[ entry data ||| Show raport ]

--------------------------------
/
\
/
\
[entry data --->textbox] [unique
number---> textbox]
/ its
gonna find the unique no
/ open the
table and excel sheet
Table with 4 columns
*name *phone no *post code *unique no
 
R

rpw

Hi Michael,

Sorry about the blank post - there was a problem with timing-out while I was
typing my reply. I can't remember everything I'd typed before so I'll
abbreviate it now.

Use the book Access 2003 Inside/Out - very useful in getting db design down,
how to use queries, forms, reports, macros.

General questions get general answers, specific questions get specific
answers.

Mention what version of Access you're using as different version have
different features and feature locations.
 
J

John W. Vinson

Can anybody help me with my Database this time ?
I want to creat a Main window where i have two command buttons. When i click
on the first one theres gonna appear another window where i can entry the
data. Lets say i will put in there name, phone no, post code and unique
number. The unique number is my priority. Afterwords i punch in the second
command button on the main menu and than i will have a new window with
textbox where all i need to put in there is the unique number and
automatically after Enter i will b trasfer to the Excel file with all details
about number i have just put in. Ive got lots of already prepared excel
sheets nut i dont know anything about Queries and Micros. Its so annoying...
i am so stupid its pathetic. Can anybody is able to help me with my project ?
Click to expand...

It all starts with the Tables. You're jumping right into forms and command
buttons - that's like installing the kitchen cabinets and closets in a new
house before you've figured out where to pour the foundations!

STOP. Step back. Learn a little about what databases are and how they work;
identify the Entities - real-life people, things or events - of importance;
create tables to store information about those entities; THEN design forms to
work with those tables.

Here are some tutorials which may get you started.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Top