Ccscs

Objective

You will be required to visit…

 http://wps.pearsoned.co.uk/ema_ge_romney_ais_12/194/49668/12715217.cw/index.html. 

• Click on Case, Journals and Ledgers tab,

• Click on the link "S&S In-Chapter Database".

Opening Access 2010

To open Access 2010 on a Curtin Computer workstation:

• Click on the Start button (bottom left hand side of the screen)

• Click on All Programs

• Click on Microsoft Office

• Click on Access 2010

[pic]

Creating a New Database

Unlike Microsoft Word or Excel, where you can open the program, then begin using it straight away without saving, Microsoft Access needs you to create the file first. This automatically saves in a location of your choice.

To create a new blank database:

• Click on New on the menu on the left hand side of the Front Page

[pic]

• Change the file name to a meaningful name e.g. “Database_your student id” (leave the .accdb extension) and click the Folder icon to choose which folder to save your database in.

• Click the Create button underneath.

To Navigate Around the Database

As with other Microsoft Products, Access 2010 has the same structure for locating commands.

The top line has the Tabs. Every time you click on a different Tab, the Ribbon underneath it changes

[pic]

Try clicking on a few different Tabs and noting the different commands on the Ribbon.

Creating Tables

Tables are the backbone of your database, holding all the raw data. They look similar to an Excel spreadsheet.

Every row is a RECORD. They are indivisible ie they can only apply to one record

Every column is an ATTRIBUTE.

• Click on Table Tools above the Tabs

[pic]

• Click on the View command, then Design View

• It will ask you to save the Table. Choose an appropriate name

This Design View will allow you to create and define every Attribute (column) and put in restrictions that may be useful by using the data type...