Microsoft Access 2013 Tutorial 4 Review: Assignment Vendor

In this tutorial, we will be exploring the world of Microsoft Access 2013. If you are new to database management systems, then this is a great starting point. The purpose of this tutorial is to provide a comprehensive review of the key concepts and features of Microsoft Access 2013.

Getting Started with Microsoft Access 2013

Before we dive into the specifics of the assignment vendor in Microsoft Access 2013, let's cover some basic information about getting started with the software. If you are already familiar with using Office apps through a Microsoft 365 subscription, then you won't find any surprises in Office 2021. However, if you are new to Microsoft Access or are looking for a perpetual license version of the software, then this tutorial is perfect for you.

Creating an Assignment Vendor Database

To create an assignment vendor database in Microsoft Access 2013, follow these steps:

1. Open Microsoft Access 2013 and click on the 'Blank Desktop Database' icon.

2. In the 'Create a New Blank Database' window, enter a name for your database and choose a location to save it.

3. Click on the 'Create' button to create the new database.

Once you have created the database, you can start designing the tables and fields that will be used to store the data related to the assignment vendor. In this tutorial, we will cover how to create a table for the assignment vendors, as well as how to add fields to the table to store information about each vendor.

Designing the Assignment Vendor Table

To design the assignment vendor table in Microsoft Access 2013, follow these steps:

1. Open the database you created earlier and click on the 'Create Table' icon.

2. In the 'Create Table' window, enter a name for your table (e.g., 'Assignment Vendors').

3. Add fields to the table as needed by clicking on the 'Add Field' button.

4. Configure each field by selecting the data type, entering a default value, and setting any other options.

Some common fields that you may want to include in the assignment vendor table are:

* Vendor Name

* Address

* Contact Information (phone number, email address)

* Services Offered

Adding Records to the Assignment Vendor Table

Once you have designed the assignment vendor table, you can start adding records to it. To do this, follow these steps:

1. Open the assignment vendor table in Microsoft Access 2013.

2. Click on the 'Insert' button to add a new record to the table.

3. Enter information about each vendor in the fields that you created earlier.

Reviewing the Assignment Vendor Database

Once you have added records to the assignment vendor table, you can review the data by following these steps:

1. Open the assignment vendor table in Microsoft Access 2013.

2. Click on the 'View' button to view the records in the table.

3. Use the navigation buttons (e.g., Previous Record, Next Record) to scroll through the records.

In this tutorial, we have covered how to create an assignment vendor database in Microsoft Access 2013. We have also discussed how to design and add fields to a table, as well as how to add records to the table. Finally, we reviewed the data in the table by viewing the records.

By following these steps, you should now be able to create your own assignment vendor database in Microsoft Access 2013. Remember to save your work regularly and to use the built-in help features of Microsoft Access 2013 if you need assistance with any part of the process.

Microsoft access 2013 tutorial 4 review assignment vendor