Database Lesson 10 | Working Tables, Forms to Enter Data, Queries, and Use of Switchboards
In this video lesson learn how to enter data in table design, use of forms, query calculations, and reports. Use of switchboards etc
A switchboard is a form that allows you to navigate around your Access database. The switchboard is made of buttons that you click. You can program these buttons to open forms, reports, queries, etc. Microsoft provides a switchboard wizard that allows you to define the look and feel of your switchboard.
The Switchboard Manager isn't available on the Ribbon so you first need to add the command to the Quick Access Toolbar. The first few steps here show you how to add this command to the Quick Access Toolbar.
Click the down arrow on the Quick Access Toolbar and then click More Commands. Access opens the Access Options dialog box with the Quick Access Toolbar section selected.
In the Choose commands from combo box, select All Commands.
Select Switchboard Manager and then click Add. Click OK to save your changes and to close the Access Options dialog box.
On the Quick Access Toolbar, click Switchboard Manager to open the tool.
Microsoft Access asks if you'd like to create a switchboard, click Yes. This creates a Main Switchboard. You can either add all your switchboard commands to the Main Switchboard or create secondary switchboards.
To create secondary switchboards, click New.
The Create New dialog box appears.
Type the name of the new switchboard and click OK.
Microsoft Access adds the switchboard to the list in the Switchboard Pages box.
You can add secondary switchboard names at this point.
Repeat steps 5 through 6 for each secondary switchboard you want to create, and then click Close.
More Video Lessons On Database Access By Kakuru Benard
Lesson 1: • Database Lesson 1
Lesson 2: • Database Lesson 2
Lesson 3: • Database Lesson 3
Lesson 4: • Database Lesson 4
Lesson 5: • Compressive Database Lesson 5
Lesson 6: • Database Lesson 6: How to Create Relations...
Lesson 7: • Database Lesson 7: How to Import Excel Da...
Lesson 8: • Everything You Need to Know about Microsof...
Lesson 9: • Database Lesson 9 | Using Query Wizards, F...
Wakisha 2023: • Video
UNEB 2023 Paper 2: • Video
UNEB 2023 Paper 3: • Video
UNEB 2023 Paper 1: • Video