Pages

Monday, June 24, 2013

How to Enter Data in Access

Microsoft Access is a database application that is a part of the Microsoft Office applications suite. Entering data into Microsoft Access isn't difficult. Essentially, there are two ways to do that: through a datasheet view or by entering a new record on an Access form.

Instructions

Datasheet View

    1

    Double-click the table you'd like to enter data to. Table names are at the bottom of the "Create" choices.

    2

    Wait for a table with horizontal rows and vertical columns to appear. A row is a record in your table. The left triangle on the far left indicates that the record is selected.

    3

    Enter a new record by filing out fields right of the asterisk (the rows at the bottom). If you'd like to change the content of a cell, double-click it.

    4

    Press Ctrl+S (save the database), and your changes to the table will be saved.

Using a Form

    5

    Click on the Forms button that is on the left of the dialog box..

    6

    Double-click the form that corresponds with the table (it should have a similar name).

    7

    After a new window appears, locate a button to the left of the number of records (located at the bottom of the dialog box). It looks like >*

    8

    Type the data into the form. Save your table by clicking Ctrl and S simultaneously.

0 comments:

Post a Comment