3.1 Working with Databases

Before you can build a single table or run a single query, you need to be comfortable with the basic mechanics of the database application itself. This section maps directly to ICDL Using Databases syllabus references 2.1.1 through 2.1.5, and it is the foundation everything else in the module builds on. Even though these skills feel simple, exam questions on this topic often test precise distinctions — such as the difference between closing the application and closing a database file — so it pays to be exact.

Opening and Closing the Database Application (2.1.1)

The database application (commonly Microsoft Access in ICDL-accredited training centres) is the software program itself, separate from any individual database file you create inside it. You can:

• Open the application from the Start menu, taskbar, desktop shortcut, or dock, just like any other program
• Close the application using the File menu's Exit/Close command, the window's close control, or a keyboard shortcut such as Alt+F4 on Windows

A useful way to remember this distinction: the application is the workshop, and a database is one project sitting on the workbench. You can walk out of the workshop (close the application) while a project is still open, and doing so will prompt you to save any unsaved changes to that project first.

Opening and Closing a Database (2.1.2)

Once the application is running, you open an existing database file using the File menu's Open command (or a Recent Files/Open Recent list), then browse to the file's saved location. Closing a database — without closing the whole application — leaves the application window open with no file loaded, ready for you to open a different database or create a new one.

This matters for the exam because a question may describe a scenario ("the user wants to work on a different database without shutting down the program") and expect you to identify closing the database, not closing the application, as the correct action.

Creating and Saving a New Database (2.1.3)

To create a new database, use the File menu's New (or Blank Database) command. Unlike a word processor document, a database application typically asks you to name and save the file to a drive location immediately, before you add any tables or data — you cannot create database content "in memory" and decide later where to store it.

Key points to remember:

1. Choose a clear, descriptive file name that reflects the database's purpose
2. Select an appropriate save location (a local drive, a network drive, or removable/cloud storage)
3. Confirm the correct file format/extension is used, since the application typically appends its native database file extension automatically
4. Once saved, the database window opens and you can begin creating tables and other objects

Displaying, Hiding, and Restoring Toolbars and the Ribbon (2.1.4)

Most modern database applications organise commands into a ribbon — a strip of tabs and icon groups across the top of the window — while older or simplified interfaces may use separate toolbars. You should be able to:

• Show or hide a specific toolbar through a View menu or right-click context menu
• Minimise the ribbon to free up screen space, collapsing it to just the tab names
• Restore the ribbon to its full, expanded view when you need quick access to commands again

Hiding a toolbar or minimising the ribbon never deletes any data — it only changes what is visible on screen. This is a common exam distractor: candidates sometimes assume interface changes affect database content, but they do not.

Using Built-In Help (2.1.5)

Every ICDL-accredited database application provides a built-in Help feature, usually accessed by:

• Pressing the F1 key
• Selecting Help from the menu bar or a Help tab on the ribbon
• Typing a keyword into a "Tell me what you want to do" or search-style Help box

Help content typically includes step-by-step instructions, definitions of terms, and troubleshooting guidance. On the exam, and in real practice, using Help is the recommended first step when you encounter an unfamiliar command rather than guessing or making changes you cannot undo.

Help systems are also searchable, so instead of browsing through a long list of topics you can type a short phrase — such as "create a primary key" or "apply a filter" — and jump straight to the relevant explanation. This makes Help a practical companion while you are learning the rest of this syllabus: if a later section mentions a command you cannot locate on screen, searching Help by keyword is usually faster than hunting through every ribbon tab.

Why These Five Skills Matter Together

It helps to see these five skills as a single opening routine rather than five unrelated facts to memorise. In a real working session you would typically: open the application, open (or create and save) a database, adjust the ribbon or toolbars to suit your screen, and consult Help if something is unclear — all before you touch a single table or record. The exam tends to test this routine by presenting short workplace scenarios and asking which single action resolves them, so practise narrating the routine in your own words until each step feels automatic.

Bringing It Together

These five skills — open/close the application, open/close a database, create and save a new database, manage toolbars and the ribbon, and use Help — form the entry point to every other task in the ICDL Using Databases syllabus. They are tested individually but also assumed as background knowledge throughout later sections on tables, queries, forms, and reports, so make sure each one is second nature before moving on.