Access Tools  «Prev  Next»

Lesson 3 Working with the Startup dialog
ObjectiveUse the Startup Dialog Options to customize the Layout of your Database and the Functionality available to users.

Use Startup Dialog Options

Customizing the layout and functionality of your Microsoft Access database through startup dialog options can greatly improve user experience. Here’s how you can do it:
  1. Open Startup Options in Access
    • Open your Access database.
    • Go to File > Options (or in older versions, click Tools > Startup).
    • This opens the Access Options dialog box where you can customize startup behavior.
  2. Key Startup Options
    1. Display Form
      • Set a specific form to open automatically when the database starts.
      • In the Current Database tab, look for the Display Form dropdown and choose the form you want.
      • Example: A main menu or dashboard form with navigation buttons for users.
    2. Application Title and Icon
      • Enter a custom Application Title in the Application Options section.
      • Add a custom Application Icon (a .ico file) that displays in the title bar and taskbar when the database is open.
    3. Hide the Navigation Pane
      • Uncheck Display Navigation Pane to prevent users from accessing the database objects directly.
      • You can create custom navigation forms instead.
    4. Use Compact and Repair
      • Enable Compact on Close to ensure the database is automatically optimized when users close it.
    5. Enable/Disable Built-In Toolbars
      • To simplify the interface for end-users, you can disable Access’s built-in menus and toolbars:
        • Uncheck Allow Full Menus to remove advanced tools.
        • Uncheck Allow Default Shortcut Menus to disable right-click options on forms and reports.
    6. Use Custom Ribbon
      • Use the Ribbon and Toolbar Options to assign custom ribbon XML to create a tailored user interface.
  3. VBA and Macros for Advanced Customization
    • Use VBA code or macros to control startup behavior.
    • Example: Use an AutoExec macro to run specific commands when the database opens.
  4. Set Up Security and Permissions
    • Ensure sensitive areas are restricted:
      • Use Access’s User-Level Security (for older versions) or implement login forms.
      • Disable bypass keys (Shift key) by setting the AllowBypassKey property to False in VBA
  5. Test Your Setup: After configuring the options:
    1. Restart the database to confirm the settings.
    2. Test as a user to ensure the functionality and layout meet your requirements.

By leveraging these options, you can create a more professional and user-friendly experience tailored to your needs!

Microsoft Access 365

Use the Startup Dialog Options to customize the Layout of your Access Database and the Functionality

You can use the Startup dialog to make your database easier for others to use. This powerful feature allows you to customize the look of your database when users open it. By customizing how the database appears when it opens, you can prominently locate the tools and functionality users will need. Novice users will thank you when they do not have to hunt for the tools they need. The Startup dialog can be opened by choosing Startup from the Tools menu. The following diagram will illustrate what you can do through the Startup Dialog.
Startup Dialog
  1. This will be displayed in the Access title bar whenever the database is opened
  2. This is the file name and path of an icon file that will be used to represent your database application when it is minimized.
  3. The menu bar specified here is the one displayed when a user first opens your database. You can customize the tools on this menu bar.
  4. This option specifies whether to display and let users use Access menus.
  5. Specifies whether to display right-click menus.
  6. Allows you to set the form, or data access page, to display when the database opens.
  7. If unchecked, this will hide the Database window. Be sure to specify a form in the Display Form/Page option if you uncheck this form.
  8. Allows you to choose whether to display the Access status bar at the bottom of the Access window.
  9. The name of right-click menu bar to use.
  10. Allows you to choose whether to display built-in system toolbars.
  11. Allows you to choose whether to allow users to modify toolbars and menus./li>

As you can see, there are a lot of options that Access gives you regarding your database application. How you use them can make a big difference in how professional your database is going to be to use.
To test your understanding of the Startup dialog and its purpose, check out the following simulation.

Changing the Application Title by using the Startup dialog

  1. While in the consulting407.mdb, click the Tools menu.
  2. Click Startup… located on the Tools menu.
  3. The Startup dialog has now been opened. Type the words My Consulting Database into the Application Title field, Then click Submit.
  4. The database now has a new title, as seen at the top of the Access window.

Analyze the following uploaded image and 1) print off the text and 2) describe any relevant features. Access Tables
A relational database schema in Microsoft Access with the following tables and fields:
  1. Clients
    • ClientNo
    • Company
    • FirstName
    • LastName
    • Address
    • City
  2. Consultants
    • ConsultantID
    • LastName
    • FirstName
    • SSN
    • ConsultingTypeID
  3. ConsultantsBankInfo
    • ConsultantID
    • BankName
    • AcctNo
    • AutoDeposit
  4. ConsultingTypes
    • ConsultingTypeID
    • Description
  5. Hours
    • HourID
    • ProjectID
    • DateWorked
    • HoursWorked
  6. Projects
    • ProjectID
    • ClientNo
    • ConsultantID
    • ProjectDescription
    • StartDate
    • DueDate
  7. Switchboard Items
    • SwitchboardID
    • ItemNumber
    • ItemText
    • Command
    • Argument
Relevant Features:
  • Relationships:
    • There is a visible one-to-one relationship between the Consultants and ConsultantsBankInfo tables, indicated by a "1 to 1" notation. This suggests that each consultant has a unique bank information record.
  • Primary Keys:
    • Each table has a designated primary key, highlighted with a key icon:
      • Clients: ClientNo
      • Consultants: ConsultantID
      • ConsultantsBankInfo: ConsultantID
      • ConsultingTypes: ConsultingTypeID
      • Hours: HourID
      • Projects: ProjectID
      • Switchboard Items: SwitchboardID
  • Foreign Keys:
    • Certain fields (like ConsultingTypeID in Consultants and ConsultingTypes) suggest potential foreign key relationships, even though they are not connected in this specific layout.
  • Purpose of Tables:
    • Clients: Holds client information, such as name, company, and address.
    • Consultants: Contains consultant details, including consulting type and SSN.
    • ConsultantsBankInfo: Stores consultants' banking information, likely for payroll purposes.
    • ConsultingTypes: Provides a description for different types of consulting services.
    • Hours: Tracks hours worked on projects, along with the date.
    • Projects: Details project-related information, linking consultants to clients and including project description and deadlines.
    • Switchboard Items: Likely used for menu or navigation configuration in the database, as it contains fields for commands and arguments.

This schema seems suited for a consultancy or project management setting, where consultants work on various projects for clients and are compensated based on recorded hours. The **Switchboard Items** table is indicative of a user-friendly Access application setup, often used to navigate or automate tasks within the database.

Because you are already in Layout view for the form, you can easily make one last change. Because this database contains customer names for a stationery store, you're going to change the form title to Customer List.
You can click the Format tab and then click Title in the Controls group. This will highlight the current title, as shown in the picture. All you need to do then is type the new title of the form. In this case, you type "Customer List." Remember to save after making this change.
There's more that you can do to customize a form. The Quick Reference Guide includes more information about customizing forms.
In the next lesson we will identify seven add-in utilities that increase the functionality of Access.

SEMrush Software 3 SEMrush Banner 3