Making tables and appending queries

We can use a make table query to permanently save the results of the query as a new table.…And we can use the append query to take records from one table and append…them to another table.…Let's how we can use these to action queries together to create a master email…list for a marketing campaign.…First let's go up to the Create tab and create a new query in Design View.…I am going to add our Customers table to the query and we'll go ahead and close…the Show Table window.…Now we want to add our FirstName and LastName and our customers' email addresses.…Now since all of our customers haven't signed up to receive newsletters from us,…I want to make sure that I include the Newsletter field as well, and we are…going to apply a criteria on that, so you can filter out just the customers who…have agreed to receive our newsletters.…

I can go ahead and view the results and I can see that we have a total of 555…customers who've signed up for our newsletter.…Let's go ahead and switch back into our Design View and now we're going to…