Element Data Base: Using Microsoft Access:        Name: __________________ Period: ____ Date: ______

Conversions               Convert It            Chemistry Trading Card Mini Project

Go To: START: Microsoft: MSOFFICE APPS: ACCESS              

This will bring up the database program we will be using in class. Data bases handles information electronically. It is much like an electronic file cabinet holding files and records. A database enables you to handle large amounts of information and to manipulate the data in many different ways.

            This part of the element research project will include a construction of an element database. Each student will play a role in the construction of this element database. Include units: Temperature C F K.
Under “New” select “Blank Database” a file new database begins with a “db1” in the save field.
Click on “Create”

Object bar – vertical bar in the left pane. Click on “Create table by using wizard” then “sample field”.
Click right arrow then “rename field” to Element #   “This symbol is for Element number”
Continue naming fields for all Ten “10” fields. Then next… click set a primary key for me.

Next enter data into a table then click Finish. 
Name your table: Put your Name & “Element DB” ( For Database/ Joe CoolDB ) then next.
Click on enter data directly then finish.   File Save. (Dates in year form: 1647 )

View design view. Determine/ set field data type and set field properties. Single= up to 7 decimal places.

Special Keys:

End (Last rightmost field of record)        Home (First field of record)
CTRL+End (Last field of last record)      CTRL+Home (First field of the first record)* Search

Find:   Find What? (Find Next)                 ABC: 

Add records are done at end of data sheet: Click on new record button.   I >* 

Delete record click on delete record button: I > X

Copy CTRL+ ‘ (apostrophe)   to insert  CTRL+; (Semicolon)

Filter:  Place the insertion point anywhere in the field (Column) to be ……….

Filter by selection: Click on selection. To undo click on Remove Filter button.

Sorting Records:  Click on Sort Ascending AZ  l     or Sort Descending  ZA  l

To put Records back in order, Click on Records then Remove Filter Sort.
Multiple field sorting:

Advanced filter/Sort window: Records, Filter, Advanced Filter/Sort.

Click on Edit, Clear Grid.

Then in the field list, select and drag the field to the first empty field cell in the design grid.
Select the next field and drag it to the next empty field cell.

In the sort cell for each field, display the drop-down list and select Ascending.

Query: [Always save first]   1. Source: of the data.  2. Question (Query design)   3. Answer
                                                  (the temporary result called the query Datasheet view)

New Object: Click on Query then Choose field cells from drop-down list.

              Select/ SHOW then RUN (!) the Query.     
              Sorting in Query    
            If criteria (20 , 355, P) 
Comparison operators: (< > = <=  >= <>)
(< Less Than > Greater Than = Equal to  <= less than or equal to   
 >=  Greater than or equal to        not equal to  <>)

AND, OR, Null       Math * + - / ^

Element Data Base: Using Microsoft Access:        Name: __________________ Period: ____ Date: ______
Students define the following::

1. Database:____________________________________________________________________________

_____________________________________________________________________________________

2. Data Value (TYPE):

_____________________________________________________________________________________
 

3. Record:
_____________________________________________________________________________________

4. Field:
_____________________________________________________________________________________

5. Design View:

_____________________________________________________________________________________ 

6. Sort:

_____________________________________________________________________________________

7. Access:

_____________________________________________________________________________________
8. Filter:

_____________________________________________________________________________________
9. Advanced Filter / Sort:

_____________________________________________________________________________________
10. Query:

_____________________________________________________________________________________
Auto Form or Auto Report *
_____________________________________________________________________________________