In
Access:
Your assignment is to create a table to hold information about your friends and relatives. You should assign each person an identification number. Then you should decide what information you want to include on the table. Along with any other information you decide to keep, you must include the following data:
Create the structure of the table and then populate the table with data, but first look at the queries below to make sure you populate the table with data that will test the queries. By test the queries, I want you to enter data so that when you do the queries it will select some people and not select others and will truly test the validity of the query.
Queries:
Remember in designing the table, you should consider the following:
Using the form wizard and the report wizard, create a form and a report that go with your table.