Test the New Form Fields

Before You Begin: Change the View

Go to Form Design Tools ->Views->View.

Select a View: Form View.

 

Still Before You Begin: Find a Movie

Click on the Movie Field.

Go to Home->Find->Find.

Find What: Amityville II: The Possession.

Match: Any part of Find.

Click Find Next to go to that movie.

 

9. Try it: Test the New Form Fields

Check: Archived.

Change the Status: No Sale, Do Not reimage.

You can add some sample text to the Memo Field.

Please Close the Movies Form.

 

The data should be updated in tblMovies. You could find all of the movies that were released before 1990 and mark them as Archived.

 

Or...you can use an Action Query to update them all at once. Let's go for the Action Query.

Form Design Tools ->Views->View->Form View

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: Add Existing Fields to a Form