Blog

Microsoft Access Fantastic Features

Access Fantastic Features – Startup Options: Navigation Form and AutoExec Macro

A split database will very often use a Navigation Form on the front-end as the entry point for users.  A good idea is to display the Navigation Form by default each time a user opens the database. This makes it easy for users to switch between the various forms and reports in the database without affecting the data tables stored and protected on the back-end. This blog will explain a simple process of creating a Navigation Form by adding buttons to display forms and reports and then configuring options to display the Navigation Form at startup instead of the navigation pane.  In addition, a brief discussion will describe a more advanced process of Navigation Form design that opens database objects (including queries) and shows a message (if preferred) at startup.

Creating a Simple Navigation FormMicrosoft Access Fantastic Features 1

To do this:
  1. Click the Create tab.
  2. In the Forms group, click Navigation and choose a layout option.Microsoft Access Fantastic Features 2
  1. Drag forms and reports from the Navigation Pane and drop on the “Add New” tab.
Microsoft Access Fantastic Features 3

Setting Startup Options

To do this:
  1. Click File, then Options.
  2. Select Current Database.
  3. From the “Display Form” dropdown list, choose the correct form.
  4. Under “Navigation”, uncheckDisplay Navigation Pane”.
  5. To prevent users from getting into Layout view or Design view, you may also want to uncheckAllow Full Menus” and “Allow Default Shortcut Menus” and “Use Special Access Keys”.
  6. Click OK to close Options. Click OK to close Message.
  7. Reopen the database to see changes.
Microsoft Access Fantastic Features 4

An Alternative Method (Advanced)

A more advanced process of Navigation Form design includes adding labels and buttons manually, assigning macros to those buttons that open database objects (including queries), and creating an AutoExec macro for startup display options including a message if preferred.  This method gives you more control and flexibility.Microsoft Access Fantastic Features 5 To do this:
  1. Create a blank form in Design view.
  2. On the Design Tab in the Controls group, add labels and name each label appropriately.Microsoft Access Fantastic Features 6
  3. Add a button, use the Command Button Wizard to assign an applicable macro (i.e. to open the object) to the button, and name the button Repeat as often as necessary.Microsoft Access Fantastic Features 7
  4. Save the form.

Using the AutoExec Macro

To do this:
  1. Create a macro in Design view.
  2. Enter the actions and set the arguments.
  3. Save the macro as “AutoExec”. Important: It must be named AutoExec to work.Microsoft Access Fantastic Features 8
  4. Close and reopen the database to verify that the macro runs properly. The Navigation Form and the Welcome message should open.  ClickEnable Content” to close Security Options.Microsoft Access Fantastic Features 9
  5. You may want to uncheckDisplay Navigation Pane” in Options as described above. To prevent users from getting into Layout view or Design view, you may also want to uncheckAllow Full Menus” and “Allow Default Shortcut Menus” and “Use Special Access Keys”.
—————————-

This is the first blog article in a three-part Access series.  Be sure to watch for future blog articles in this Access series. The next topic will feature Terrific Tips and Tricks and then Outstanding Options.   NOTE: There will not be a Lunch and Learn for this series of blogs. For more information about these and similar features, take an Access Class from Centriq. For course descriptions and dates, see our website here. In addition, if you would like more information about Access or other training classes available, contact a Centriq Training Advisor online or at 913.322.7062 for assistance.

Start Date
End Date
Day/Eve
Break Weeks
Track
Jan 23, 2023
Jul 27, 2023
Eve
4/3/23-4/7/23
5/22/23-5/26/23
7/3/23-7/7/23
CSSP-V
Jan 30, 2023
May 5, 2023
Day
3/6/23-3/10/23
4/10/23-4/14/23
CSSP-V
Feb 6, 2023
May 19, 2023
Day
3/27/23-3/31/23
FSCP-V
Mar 20, 2023
Jun 23, 2023
Day
4/24/23-4/28/23
5/22/23-5/26/23
CSSP-V
Apr 10, 2023
Jul 28, 2023
Day
5/29/23-6/2/23
7/3/23-7/7/23
FSCP-V
Apr 24, 2023
Oct 19, 2023
Eve
7/3/23-7/7/23
8/21/23-8/25/23
CSSP-V
May 15, 2023
Dec 14, 2023
Eve
7/3/23-7/7/23
9/4/23-9/8/23
11/20/23-11/24/23
FSCP-V
Jun 5, 2023
Sep 8, 2023
Day
7/3/23-7/7/23
8/7/23-8/11/23
CSSP-V
Jun 19, 2023
Oct 6, 2023
Day
7/3/23-7/7/23
9/4/23-9/8/23
FSCP-V
Jul 24, 2023
Jan 25, 2024
Eve
10/2/23-10/6/23
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-V
Aug 14, 2023
Nov 17, 2023
Day
9/5/23-9/8/23
10/16/23-10/2/23
CSSP-V
Aug 28, 2023
Dec 15, 2023
Day
9/4/23-9/8/23
11/20/23-11/24/23
FSCP-V
Oct 30, 2023
Feb 2, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-V
Oct 30, 2023
May 2, 2024
Eve
11/20/23-11/23/23
3/4/23-3/7/23
CSSP-V
Nov 6, 2023
Mar 1, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
1/29/24-2/2/24
FSCP-V
If you don't see the Cohort Start date you are looking for don't forget to check out our campus calendars.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
Start Date
End Date
Day/Eve
Break Weeks
Track
Feb 29, 2024
Mar 24, 2024
Day
3/25/24-3/29/24
4/22/24-4/26/24
CSSP-I
May 13, 2024
Aug 16, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
Aug 19, 2024
Nov 22, 2024
Day
9/2/24-9/6/24
10/21/24-10/25/24
CSSP-I
Dec 2, 2024
Mar 14, 2025
Day
12/23/24-12/27/24
12/30/24-1/3/25
2/10/25-2/14/25
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
Start Date
End Date
Day/Eve
Break Weeks
Track
Jan 15, 2024
Apr 19, 2024
Day
2/19/24-2/23/24
3/18/24-3/22/24
CSSP-I
Feb 26, 2024
May 24, 2024
Day
4/1/24-4/5/24
CSSP-I
Apr 08, 2024
Jul 12, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
May 20, 2024
Aug 23, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
Jun 24, 2024
Sep 27, 2024
Day
7/1/24-7/5/24
9/2/24-9/6/24
CSSP-I
Jul 29, 2024
Feb 6, 2025
Eve
9/2/24-9/5/24
11/25/24-11/28/24
12/23/24-12/27/24
12/30/24-1/3/25
CSSP-I
Aug 5, 2024
Nov 8, 2024
Day
9/2/24-9/6/24
10/7/24-10/11/24
CSSP-I
Sep 9, 2024
Dec 13, 2024
Day
10/14/24-10/18/24
11/25/24-11/29/24
CSSP-I
Oct 21, 2024
Jan 31, 2025
Day
11/25/24-11/29/24
12/23/24-12/27/24
12/30/24-1/3/25
CSSP-I
Dec 2, 2024
Mar 14, 2025
Day
12/23/24-12/27/24
12/30/24-1/3/25
2/10/25-2/14/25
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.