posted by .

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)
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!):

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. AE,, this right?>(revised)

    In any given multicultural classroom, what are the concerns in terms of social justice for all students?
  2. English

    Hello, everybody. We are going to talk about TV programs. What kinds of TV programs do you like?
  3. English

    1. I like animated programs. 2. I like animation programs. (Which one is correct?
  4. English

    1. Do you like sci-fi programs? Do you like sci-fies?
  5. Statisitcs

    A large university campus has 60,000 students. The president of the students' association wants to conduct a survey of the students to determine their views on an increase in the student activity fee. She would like to acquire information …
  6. English

    I would like you, Writeacher, to check my letter since you know everything about the project and can help me with the word choice. I noticed I wrote two unfinished sentences in the first part of the letter. I'm posting them to you …
  7. English

    I varied my original email including other information. I wonder if you could help me express the new things, in 4 and 7. Thanks a lot! 1) Thank you very much for your prompt reply. 2) Our students would really like to be involved …
  8. English

    I urgently need you to check this message I need to include in an email. Thank you, Writeacher. 1) Our students have started receiving post from their new Irish partners. It would be nice if you could send me a list of the students …
  9. English

    Writeacher, can you suggest possible topics for email conversations among teenagers?
  10. Communications

    I need help brainstorming ideas for the following below: our assignment is that : "You have been asked by the college union to research a way that will make the lives of its students easier. You should consider ONE facet of a students’ …

More Similar Questions