Optimising a Database
This subpage forms part of the Microsoft Access course.
Now that we have our database, let us optimise it by fine-tuning its settings.
To optimise our database, you will have to return to ‘Design View’ [top left under ‘View’].
Single-left-click in the ‘Title’ field, and set the ‘Field Size’ at the bottom to 210, since the movie with the longest title is the “Night of the Day of the Dawn of the Son of the Bride of the Return of the Revenge of the Terror of the Attack of the Evil, Mutant, Alien, Flesh Eating, Hellbound, Zombified Living Dead Part 2: In Shocking 2-D”. That is a whopping 208 characters!
Single-left-click in the ‘Director’ field, and set the ‘Field Size’ at the bottom to 30. That should be more than enough for any director’s name.
Single-left-click in the ‘Genre’ field, and set the ‘Field Size’ at the bottom to 50. That should be more than enough for any genre.
Single-left-click in the ‘Running Time’ field, and set the ‘Field Size’ at the bottom to ‘integer’. That should be more than enough for any movie.
Single-left-click in the ‘Year of Release’ field, and set the ‘Field Size’ at the bottom to ‘integer’. That should be more than enough for the next 7984 years.
You don’t need to optimise the ‘Website’ and ‘Seen’ fields.
Please Review Us
If you appreciate our content and tutorials, please review SOHO Systems on Google Search and Facebook.
📅 June 4, 2026
🔃
🖨️
