Using Access to Open a Database File - Schools and ...



California Department of Education

April 6, 2010

Instructions on how to create an Access database and import the pubschls.dbf file

1) Right Click on pubschls.dbf file and save to desktop or folder of your choice:

[pic]

1. Select Save:

[pic]

Close the “Download Complete” Window after the file is finished downloading.

[pic]

3) Open Access:

[pic]

4) Open a new file in Access:

[pic]

5) Select Blank Database:

[pic]

6) Select Desktop or folder where you want your Public School Database to reside:

[pic]

7) Type “Public Schools” in the file name window and select Create:

[pic]

8) Import the pubschls.dbf by selecting File, Get External Data, Import:

[pic]

9) Select Desktop (or directory where you saved the file) in the “Look in” box at the top of the Import window and in the “Files of Type” box, select dbase IV:

[pic]

10) Select pubschls.dbf, then import:

[pic]

11) Successful Import:

[pic]

12) Select OK, and then Close the Import Window:

[pic]

13) Double click on the pubschls.dbf to open the file in Access:

[pic]

14) Sample of opened pubschls.dbf in Access:

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download