To Create a New Database
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.
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.