In this assignment, you are going to be gathering information about the future students of NSU at one of our open houses. Since there will be plenty of student candidates with interests on different programs, I would like you to create a database using Microsoft Access. In this database, I need to see a table named tbl_Attenders, and in this table I would like to see fields below;

AttendeeID {PK}(autonumber)
FirstName
LastName
Program
State (he/she is from)
In addition to the table above, I would like you to create a form to enter the data for the fields above, and a report that will give me the list of all attendees in the database. In addition to that, I would also like to see a query in your database that gives me the list of candidates from one specific state (which state you would like to choose is not important as long as you have entry in your database for that state).
You are free to enter some data to your database, but please make sure your form and your report work fine because I will also be entering more data when grading your assignments.

If you have any questions about the assignment

MAIL MERGE Assignment

In this assignment, I would like you to do a mail merge with the table of tbl_Attenders of the database you already created with the first Access assignment.
This is just a reminder to you all in regards to how to do mail merge;

1- Create a mail merge. To do so, open MS Word.
2- Click on the tools, and go to Letters and Mailing.
3- Then, Select “Mail merge”
4- You will notice that on the right hand side of the screen, there will be a wizard to help you create the list.
5- Under the topic “select a document type” (step 1 of 6), select Labels.
6- After clicking to the next step (step 2 of 6), click on “Label options” to select the label type (3261L label). Then, click OK, then, click “next: to select recipients” to get to the step 3 of 6.
7- On this screen, go ahead and browse to the table called tblAttenders in the database you have created
8- After browsing to that table you have created, and clicking ok, you will see the fields of the table you selected. On that screen click ok to accept the list.
9- Then, under the subtitle “step 3 of 6” click next: arrange your labels.
10- Under “arrange your labels” title, click on “more items”.
11- Small list of fields will pop up. Go ahead and select the fields I would like from you to print out on the name tags (Name, lastname, program, state), and insert them one by one. Then, click close button.
12- You will see that you word document has some values on the first label, like <><><><>.
13- By playing around with the enter button make the first label look like this;
<> <>
<>, <>
in order for the labels to make sense when you start printing them, then click on “update all labels”. This step will apply the format of the first label to all other next records.

14- At the step 4 of 6, go ahead and save your document to your computer in order to upload it to the assignment manager (This is the file I would like you to upload to the assignment manager).
15- If you go ahead and finish the steps of creating labels up to 6. step, this is what you will see the labels with names (but this is not what I want you to upload to the assignment manager!):

Sure! Here is a step-by-step guide to help you create the database, form, report, and query using Microsoft Access.

1. Open Microsoft Access and create a new blank database.
2. Click on the "Table Design" option to create a new table.
3. Add the following fields to the table and set the data types as specified:
- AttendeeID: Autonumber (Primary Key)
- FirstName: Text
- LastName: Text
- Program: Text
- State: Text (to store the state from where the attendee is)
4. Save the table as "tbl_Attenders".
5. Close the table design view.
6. Click on the "Form Design" option to create a new form.
7. Drag and drop the fields from the "tbl_Attenders" table onto the form design to create input fields for each field.
8. Save the form as "frm_Attenders".
9. Close the form design view.
10. Click on the "Report Design" option to create a new report.
11. Select the "tbl_Attenders" table as the record source for the report.
12. Drag and drop the fields from the "tbl_Attenders" table onto the report design to display the attendee information.
13. Save the report as "rpt_Attenders".
14. Close the report design view.
15. Go to the "Database Tools" tab and click on "Query Design" to create a new query.
16. Add the "tbl_Attenders" table to the query.
17. In the query design view, select the "State" field and the other fields you want to display on the result.
18. Click on the "Design" tab and then on the "Run" button to see the list of candidates from the specified state.
19. Close the query design view.

Now you have created the database, form, report, and query as specified. You can enter data into the form by opening "frm_Attenders" and filling in the required fields. The data will be stored in the "tbl_Attenders" table. To view the list of all attendees, open the "rpt_Attenders" report. The query you created can be accessed by rerunning the query or modifying it to filter the list of attendees from a specific state.

For the mail merge assignment, you need to follow the steps provided in your assignment instructions using Microsoft Word. The steps involve selecting the mail merge option, choosing the label type, selecting the table as the data source, arranging the labels and inserting the desired fields, and finally saving the document.