Microsoft Office Tutorials and References
In Depth Information
Tutorial B: Microsoft Access Tutorial
MICROSOFT ACCESS TUTORIAL
Microsoft Access is a relational database package that runs on the Microsoft Windows operating system. This
tutorial was prepared using Access 2010.
Before using this tutorial, you should know the fundamentals of Microsoft Access and know how to use
Windows. This tutorial explains advanced Access skills you will need to complete database case studies. The
tutorial concludes with a discussion of common Access problems and how to solve them.
As a precaution, always observe proper file-saving and closing procedures. To exit Access, click the File
tab and select Close Database, then click the File tab and select Exit. You can also simply select the Exit
option to return to Windows. Always end your work with these steps. If you remove your USB key or other
portable storage device when database forms and tables are shown on the screen, you will lose your work.
To begin this tutorial, you will create a new database called Employee.
AT THE KEYBOARD
Open a new database. Click the File tab, select New from the menu, and then click Blank database from the
Available Templates list. Name the database Employee. Click the file folder next to the filename to browse for
the folder where you want to save the file. Otherwise, your file will be saved automatically in the Documents
folder. Click the Create button.
Your opening screen should resemble the screen shown in Figure B-1.
Entering data in Datasheet view
When you create a table, Access opens it in Datasheet view by default. Because you will use Design view
to build your tables, close the new table by clicking the X in the upper-right corner of the table window that
corresponds to Close Table I. You are now on the Home tab in the Database window of Access, as shown in
Figure B-2. From this screen, you can create or change objects.
The Database window Home tab in Access
Your database will contain data about employees, their wage rates, and the hours they worked.
In the Database window, build three new tables using the following instructions.