Create databases {Tutorial for beginners}--tutorial.jcwcn.com

A data base is a data collection that belongs to the same context stored systematically for later use. In this sense, a library can be considered as a data base composed by books and indexed for its query.

Microsoft Access 2007 uses the relational model for the database management which is based on the logic of predicates where the data is represented by mathematical n-ary relations. Each relation is represented by the composition of fields stored in tables that represent these n-ary relations.

1) Start Access from the Start menu or from a shortcut.

2) The Getting Started screen will appear.

Illustration 1: Office Access 2007 Getting Started screen. Click here to view larger image.

3) Select the Blank Database Option and click on the icon.

Illustration 2: Blank database creation. Click here to view larger image.

4) Fill the Field Name textbox whit the desired database name.

Illustration 3: Fill Database name. Click here to view larger image.

5) Press the Create button. The new database will be created and a new table creation window will be opened in datasheet view.

Illustration 4: Table Datasheet view. Click here to view larger image.

Create a database from a template

Office Access 2007 includes a series of templates (more templates can be downloaded from Microsoft Office Online). What is a template? In Office Access 2007��s context, is a data base pre designed with tables, forms and information with a professional design. The templates provide a great advantage at the time of creating a new data base.

6) Start Access from the Start menu or from a shortcut.

7) The Getting Started screen will appear.

8) Select a template and press on their icon.

Illustration 5: Select the Project Template. Click here to view larger image.

9) Fill the Field Name textbox whit the desired database name and press the Download button.

Illustration 6: Fill the database name. Click here to view larger image.

You will see the download screen.

Illustration 7: The download screen shows the file creation. Click here to view larger image.

The new database will be created and a new table creation window will be opened in datasheet view.

Illustration 8: Pre designed Project List table appear in Datasheet view. Click here to view larger image.

Create a database using a template from Office on Line

Additional Office Access 2007 templates can be downloaded from Microsoft Site.

10) Start Access from the Start menu or from a shortcut.

11) The Getting Started screen will appear.

12) Select the Template option from the links below More on Office Online title.

Illustration 9: Getting templates from Office Online. Click here to view larger image.

13) The Office Site Hill be loaded into your Internet browser.

Illustration 10: Office on Line Site. Click here to view larger image.

14) Search the desired template.

Illustration 11: Search a template and download it. Click here to view larger image.

15) Click on the template name to view the template description and start de validation and download process.

Illustration 12: Template description. Click here to view larger image.

Access will download the template automatically, create a new data base from that template, stores it in the document folder (for example, the folder my documents) and opens the data base.

Open a recently used database

When a data base is opened (or it is created and opened), Access adds the file name and the data base location to the more recently used documents. This list appears in the page Introduction to Microsoft Office Access, so the data bases can be opened easily.

16) Start Access from the Start menu or from a shortcut.

17) The Getting Started screen will appear.