Introduction to Microsoft Access and Databases 1/8

Viewing "Creating and Working with Databases > Databases: what they are and how they work" in MS Access 200 help
Opening a sample database
Sorting data in tables
Modifying a table
Entering data
Creating a new database
Importing data

* Viewing "Creating and Working with Databases > Databases: what they are and how they work" in MS Access 200 help

1.    Click Microsoft Access Help in the Help Menu, or press F1

2.    Expand Creating and Working with Databases and click on Databases: What they are and how they work.

3.    As detailed in the main window, click on the graphic to display the topic.

* Opening a sample database

1.    Click on the File menu, then on Open.

2.    Navigate to /Program Files/Microsoft Office/Office/Samples.

3.    Click on Northwind.mdb, and click on ok.

* Sorting data in tables

1.    In the opened Northwind database, click on the View menu, then on Database Objects, and finally on Tables.

2.    Double click on the Customers table caption.

3.    To select the Contact Name column, click on its column header.

4.    Right click on the selected column, and to sort it in ascending alphabetical order, click on Sort Ascending in the pop up menu.

* Modifying a table

1.    In the opened Northwind database, click on the View menu, then on Database Objects, and finally on Tables. This is the equivalent of clicking on Tables in the Object bar of the Northwind : Database window.

2.    Click on the Design icon.

3.    Click on the “City” row in the Customers:Table window.

4.    In the Field Properties section, change the Field Size from 15 to 20.

* Entering data

1.    Open the Products Table

2.    Scroll down to the last record, and click on the empty “Product Name” field.

3.    Enter values in the visible fields, except the “Product ID” field, which generates a value automatically.

* Creating a new database

1.    Close any open databases.

2.    Click the new button on the Database Toolbar.

3.    Double click the database icon in the window that opens.

4.    Select the drive and folder in which the database is to be saved, and then enter a filename for the database.

5.    Click on create.

* Importing data

1.    In the Database window, click the New button.

2.    Double click import table.

3.    Locate and select the database file that contains the data you want to import, and click import.

4.    Click on the tables you want to select.
To deselect a table, click again.

5.    Click Ok.