Make your own free website on Tripod.com

Want to see an example?
Click here...

To Create a New Database

Start Access.
Select
Database from the General tab and click OK .
Choose the filename and location and click
Create . Your new database will be opened in the Database Container .
Some file formats can be linked into access which leaves the data in its native format. Dbase and Excel data can be accessed in this way.

Importing Data
Data exists in an infinite number of formats and repositories. Incorporating external data into a database is an essential time saving task. There is no need to re-key existing electronically stored data; you may just import it. Of course, Access can't possibly read all types of data formats that exist, but most applications can save their data as a delimited text file. The delimited part of the name indicates that each section of data is separated or delimited by some sort of special character. The comma, quote, and space are very common delimiters. The data can then be interpreted from this file and imported into Access. This same method can be used to extract data out of Access for inclusion in other database systems. You are going to import the results of a web-based survey and later we will analyze the data to summarize the results.
Select the
First Row Contains Field Names and click Next .The data should be shown in the window.
Click
Next , indicating you wish to store your data in a new table.
Click
Next to accept the field settings.
Select
No primary key and click Next .
Change the name of the table as you see fit and click
Finish . (Results will be fine for the lab).
Respond
OK to the information box that notifies you that the import completed successfully.
You now have a new table listed in the Database Container that is named by your selection in step 9. Any additional imports would proceed very similarly to this one.
Creating a Simple Query
Click on
Queries under Objects and click New from the database container toolbar.
Select
Simple Query Wizard and click OK .
Select the fields you wish to be included in the query and click the
> button.
Click
Next to move to the next screen and click Next a second time to produce a detail query.
Click
Finish to display the completed query.







Read about creating your own databases

Technology Workshop | Word Processing | Internet | Technology Toolbox | Spreadsheets Databases | Publishing

Phone: 608-845-5950
Fax: 608-845-8515
Email: teachpe@concentric.net