Microsoft Office Tutorials and References
In Depth Information
Tutorial B: Microsoft Access Tutorial
AT THE KEYBOARD
On the Home tab of the Database window, double-click the Employee table. Your data entry screen should
resemble the one shown in Figure B-7.
The data entry screen for the Employee table
The Employee table has many fields, some of which may be off the screen to the right. Scroll to see obscured
fields. (Scrolling happens automatically as data is entered.) Figure B-7 shows all of the fields on the screen.
Enter your data one field value at a time. Note that the first row is empty when you begin. Each time
you finish entering a value, press Enter to move the cursor to the next cell. After you enter data in the last
cell in a row, the cursor moves to the first cell of the next row and Access automatically saves the record.
Thus, you do not need to click the File tab and then select Save Object As after entering data into a table.
When entering data in your table, you should enter dates in the following format: 6/15/10. Access
automatically expands the entry to the proper format in output.
Also note that Yes/No variables are clicked (checked) for Yes; otherwise, the box is left blank for No. You
can change the box from Yes to No by clicking it.
Enter the data shown in Figure B-8 into the Employee table. If you make errors in data entry, click the
cell, backspace over the error, and type the correction.
Data for the Employee table
Note that the sixth record is your data record. Assume that you live in Elkton, Maryland, were hired
s date (enter the date), and are a U.S. citizen. Make up a fictitious Employee ID number. For
purposes of this tutorial, the sixth record has been created using the name of one of this text
s authors and
the employee ID 09911.
After adding records to the Employee table, open the Wage Data table and enter the data shown in Figure B-9.
Data for the Wage Data table
In this table, you are again asked to create a new entry. For this record, enter your own employee ID.
Also assume that you earn $8 an hour and are not salaried. Note that when an employee
s Salaried box is not
checked (in other words, Salaried
No), the implication is that the employee is paid by the hour. Because
salaried employees are not paid by the hour, their hourly rate is 0.00.
When you finish creating the Wage Data table, open the Hours Worked table and enter the data shown in