PLS Quiz Final - Week 4: Microsoft Access

What are the *four* rules for relating tables?

1.) The two tables must have the SAME data type. 2.) One of the fields that you are relating MUST be a Primary Key. 3.) Ensure that all tables are closed NOT minimized. 4.) ALWAYS check the box for Enforced Referential Integrity. It helps with consistency with two tables being linked together.

What does the Format do in the 'Design' View?

A job very similar to the Input Mask, but just a different method of doing it.

Which of the following statements is false? a.) When creating a relationship, a primary key must be related to another primary key. b.) You can create a new field in design view. c.) You can filter tables in datasheet view. d.) None of the above.

A! You do not have to relate a primary key with another primary key, just one of them has to be a primary key!

You should create a relationship after you create a query. True or False?

False!

Forms are database objects that are meant to be printed. *True* or *False*?

False.

Text within the Report Footer will be seen at the bottom of every page of a multi-page report. *True* or *False"?

False.

How do you add a field in a table? How do you match it with the appropriate data type?

Go to 'Design' View and enter the Field name. Then, next to it click the drop down arrow and match it to the correct data type.

How do you filter tables?

Go to 'Designsheet' view, go to the top of the column, then hit the drop down arrow to filter.

How do you create a Query?

Go to the 'Create' tab, the Query section, then select 'Query Wizard'

How do you create a relationship?

Go to the 'Database tools' tab and select 'Relationships'.

What is a Primary Key? How do you set your Primary Key?

It is your 'most unique field name' out of all of the field names (State Capitol). If you don't set your Primary Key, ACCESS WILL SET IT For You. You MUST set your Primary Key in Design View, right click on the field in the correct row, and select 'Primary Key'.

How do you use an Input Mask? *Hint: The input mask only works with Text or Date Fields*

Switch to 'Design' View, go down to the 'General' tab of the Field Properties section. Once you locate Input Mask, click into it and click on the three small dots at the end of the row. This will take you to the Input Mask Wizard. Make sure that the suggested format you choose is the one that best aligns with the data type. Continue and Finish the Wizard.

How do you access the datasheet view? The design view?

The datasheet view is FIRST, the design view is SECOND.