lesson 7: Opening a Table and Learning to Navigate Records

Opening an Existing Table in Datasheet ViewTables are created and maintained in the Tables tab of the Objects palette in Microsoft Access. The Contact Management database contains four tables: Calls, Contact Types, Contacts, and Switchboard Items. We will discuss the Contacts table in this lesson.A table opened in Datasheet View resembles a Microsoft Excel spreadsheet. It is used to input records into the database and will be discussed in this...

Read More

lesson 6: Using a Wizard to Create the Contact Management Database

Launching the Database WizardThe Contact Management database was created using the Microsoft Access Database Wizard. We will briefly review the steps involved in creating this database. Microsoft Access 2003 is equipped with a database wizard that can be used to create any of ten simple databases: Asset Tracking, Contact Management, Event Management, Expenses, Inventory Control, Ledger, Order Entry, Resource Scheduling, Service Call Management,...

Read More

lesson 5:Getting to know the Contact Management database

Download the Contact Management DatabaseThe Contact Management database used in this course can be downloaded from the GCFLearnFree.org® Web site and installed on your computer. GCFLearnFree.org's Access 2003 lessons all use examples from the Contact Management Database. However, if you'd rather work with another existing database, you should have little problem following our lessons. To Download the Contact Management Database:Click the...

Read More

lesson 4:Database Tables

The core component of a database is a table. Data is defined and stored in a table. Multiple tables -- each consisting of different types of data -- can be created in a database. Each row in the database is called a record. The entry for John Smith is called a record. The entry for Martha Tompkins is also a record. Each row or record is made up of columns or fields -- L.Name, F.Name, Phone, Address, City, State, Zip -- which contain a particular...

Read More

lesson 3: Identifying the basic parts of the Access window

Launching Microsoft Access from the Windows DesktopMicrosoft Access is launched from the Windows desktop in a manner similar to that used to launch Microsoft Word, Excel, or PowerPoint. You can launch Microsoft Access either from the desktop shortcut or from the Start program.To open Microsoft Access using the desktop shortcut:Double-click the Microsoft Access shortcut icon on the Windows desktop. To open Microsoft Access using the Start...

Read More