Computer and Business Skills training

Sign Up
888.815.0604
Home / Access / Working With Records

Working With Records in Microsoft Access



For instructor delivered training in Chicago and Los Angeles call us on 888.815.0604.



In this Article, we will learn how to add, edit, search, browse, delete, and print records in a database.



Adding and Editing Records



To add records to a table, you have the option of entering them manually, using a form, or using the import tools on the External Data tab. As the database we are using does not have a form for it yet and we do not have external data we can import into it, we will add records manually.


To add records to a table in Access manually, ensure that the table in question (Expenses) is open and that Datasheet View is applied:



Add Records in Access



Click inside the Employee ID field and type “1” (replacing the “0”). Press the Tab key to advance to the Expense Date field. Click the small calendar icon that appears beside this field:



Make Changes to Datafield



From the small calendar that appears, click Monday of next week:



Select From calendar



Press Tab again to advance to the next field. Type “34.39” and press Tab. In the Description field type “Printing paper:”



Use Tab Function to Advance



Repeat the previous steps to add the following information:



Repeat and Add Information



You may edit information using the same method: simply place your cursor inside the field you wish to edit and type.


Save your database.



Searching and Browsing Records



When viewing a table, you can browse records easily using the controls in the small toolbar at the bottom of Datasheet View:



Use Controls to View



Click the Next button to select the next record. Click the Previous buttonto select the previous record. The First button will select the first record in the table and the Last button will select the last record in the table.


Using this toolbar, you can also search the records in the current table. Click inside the Search field and type “Flight.” As you type, Access will search the table in real time. Any records that match the keywords you entered will be selected. In this example, the second record will be selected:



Search Current Table for Records



Deleting Records



To delete a record using Datasheet View, right-click the record header for the record in question and click Delete Record. Try using this method to delete the third record in the Expenses table:



Delete Record Via Database View



A dialog will be displayed that asks you to confirm your choice to delete the selected record. Click Yes to continue:



Confirmation Box for Deletion



The record will then be deleted from the table. Save your database.



Printing Records



To print specific records, first select the records you wish to print. For this exercise, select only the second record by clicking on the record row header:



Make Record Selection To Print



With the record selected, click File → Print → Print:



Select Record, File & Print



When the Print dialog appears, ensure that the Selected Record(s) radio button is selected:



Ensure Correct Radio Button Pressed



Using this dialog, you can choose what printer you would like to print with, as well as how many copies of the item you would like printed. Click OK to print the selected record.


Close Microsoft Access.


Access student reviews

We teach thousands of students in MS Applications. Read a sample of testimonials at our MS Access training testimonial page.


Access courses

Why train with us?Need Group training quotation?Fresh Peet's Coffee brewed every day Book two levels of access training and save $100FREE Class Repeat with each courseBook 3 Level of access Training and save $150