Can someone help me with Microsoft Access.

[06fg2fijibluesi]

If you know how to use Microsoft Access, can you please help me and tell me if this is true or false. Im not sure of it, but it is part of my work for my summer course. I will be giving rep for the user that helps me answer these, which is the only best thing I can do and say thank you.

1. In Access, all the tables, report, forms, and queries are stored in one file.

True or False

2. The primary key always consists of a single field

True or False

3. To add new records or change existing records, use either Datasheet view or Form view.

True or False

4. To change the field size for a text field, use the Field Size property box in the lower pane of the Table window.

True or False

5. To print a query without first opening it, right-click the query in the Database window and click Print on the shortcut menu.

True or False

6. The solution to the redundancy problem is to place the redundant data in a separate table, one in which the data no longer will be redundant.

True or False

7. As you enter questions and terms in the Type a question for help box, Access adds them to its list.

True or False

[Trav-Is_Si]

Hey There,

Are you in Uni? I took a course that covered some similar material, but it was an intro to Management Info. Systems course... Forgot everything becuz it was about a year ago... =( Srry, i'm sure you can do use the Access help section or Google?? Good Luck

[Skylinegtr06]

bump for the pretty lady

[Firestrife]

Im gonna take a swing at it im pretty good with comps but office im not 100% in. So someone confirm this or add to.

1. In Access, all the tables, report, forms, and queries are stored in one file.

True or False

2. The primary key always consists of a single field

True or False

3. To add new records or change existing records, use either Datasheet view or Form view.

True or False

4. To change the field size for a text field, use the Field Size property box in the lower pane of the Table window.

True or False

5. To print a query without first opening it, right-click the query in the Database window and click Print on the shortcut menu.

True or False (unsure)

6. The solution to the redundancy problem is to place the redundant data in a separate table, one in which the data no longer will be redundant.

True or False (unsure)

7. As you enter questions and terms in the Type a question for help box, Access adds them to its list.

True or False

[MrCode]

Originally Posted by Firestrife

6. The solution to the redundancy problem is to place the redundant data in a separate table, one in which the data no longer will be redundant.

True or False (unsure)

Yes this will reduce redundancy but not completely remove it. The reason is that when you migrate the tables PK as FK in another table, the key data is still redundant. However, imagine a table

Version 1
---------------
Person

PersonId, Name, ClassRoom, ClassRoom Capacity, ClassRoomLocation

Version 2
---------- split of tables ---------

Person

PersonId, Name, ClassRoomId

ClassRoom

ClassRoomId, Capacity, Location

Note that we have reduced redundancy but the FK will still repeat it self!

[BATANG CITY JAIL]

just put true on all the answers, atelast you have a chance on getting half of it correctly..

this is the reason why my teacher cant fail me..