Creating an ACCESS Database 1

[MEM69]

After creating a folder that I want my information to go into, I nned to create an ACCESS database. How do I do this?

After selectoing the info that I want in my database, I want to create a new table to hold my info. OK her. It's when I want to include 6 fields. How do I do this or ensure it, (ie: a table was created, and I want to go back into it and add field BUT don't remember how! HELP!

How do I create a forma that shows all of the fields in an organized fashion complete with labels designed to enter data into the table. How do I do this?

When printing the form how can I print the form with the contents of the records displayed?

I know how to create a query, but how do I do this so that it will show all of the fields in my table for all of my records whose logical
(Y/N) field is the True (or the Yes) value.

To print the results of such a query do I have to do anything special other than access the print function?

 

[JerryDennison]

You haven't gotten any answers because no one can believe you would have a problem with something this basic. To create and save a database you simply click File... New... give the db a name and select a folder to store it in. To open an existing db click File... Open... select the folder it was stored in and double click the file. To edit an existing table, select the table(you'll find it in the tables tab of the database window) then click Design. You can add or change fields from there. To create a form, let the form wizard do it for you. Click the Forms tab. Click New. Select Form Wizard. Select the table you want the form bound to. Click Ok. Select the fields you want on your form. Select Next. Select the type of form. Click Next. Select the style. Click Next. Give the form a name. Click Finish.
To create a query. Select the Query tab of the database window. Click New. Select Design. Click Next. Select the table(or tables) you want the query based on. Click Close. Add the fields you want in your query to the QBE grid. Set any sorting properties you want. That's pretty much it.

 

[BlackKnight]

Hi,

Please let me see if I have this straight:

You work for a company in management. You are in the middle of a snowstorm. You have a deadline to create a database system. You don't know Access at all or barely do yet this company hired you to create a database for them? How long is the project's duration? The snowstorm couldn't have lasted for over 2 weeks preventing you from getting a book on Access?? I need to know the company name and location for my files on potential cash cows!! <g>

Have a good one!
BK