Get familiar with Acccess 2016 interface and basic operations

If you have used Access 2013 or 2010 you will be familiar with the Access 2016 interface: Ribbon Ribbon and Quick Access Toolbar (providing commands to perform common tasks in Access) as well as File menu.

Ribbon

Access uses a tabbed Ribbon system instead of traditional menus. Ribbon contains many tabs, each group has several groups of commands. For example, the Clipboard group on the Home tab contains commands like Cut, Copy, and Paste.

Get familiar with Acccess 2016 interface and basic operations Picture 1
Ribbon in Access 2016

Some groups have small arrows in the lower right corner, you can click on them to see more options.

Get familiar with Acccess 2016 interface and basic operations Picture 2

To hide the Ribbon, simply click the arrow in the right corner. To show it again, click on any tab, when it is no longer used, it disappears again.

Get familiar with Acccess 2016 interface and basic operations Picture 3

To always open the Ribbon you click on any tab, click on the pin icon in the lower right corner. Ribbon will always appear.

Get familiar with Acccess 2016 interface and basic operations Picture 4

Tell me feature

If you have difficulty finding the command you want, just enter the search command into Tell me, the options list will appear, click on what you want.

Get familiar with Acccess 2016 interface and basic operations Picture 5

Quick Access Tool

The Quick Access Tool bar is located above the Ribbon, giving you access to common commands no matter which tab you are on. By default, it has Save, Undo, and Redo commands. If you want, you can customize it by adding additional commands.

Get familiar with Acccess 2016 interface and basic operations Picture 6

File menu

To access the File menu, click the File tab on the Ribbon:

Get familiar with Acccess 2016 interface and basic operations Picture 7

Here you can save, open, and print databases.

Get familiar with Acccess 2016 interface and basic operations Picture 8

Navigation frame

The navigation lists a list of objects in your database, grouped into groups for easier viewing and management. You can open, rename, delete objects from this frame.

Get familiar with Acccess 2016 interface and basic operations Picture 9

To minimize the navigation, click on the arrow as shown below, double click the arrow to show it again.

Get familiar with Acccess 2016 interface and basic operations Picture 10

By default the objects in the navigation pane are sorted by Type, you can choose a more appropriate sort if desired, by clicking on the arrow as shown:

Get familiar with Acccess 2016 interface and basic operations Picture 11

Database with navigation form

Some databases have a navigation form, which opens automatically when the database opens. These forms are designed to replace navigation frameworks with a more user-friendly interface. They contain tabs that allow viewing, working with common forms, queries, and reports. Thanks to regular users available in one place to access them quickly and easily.

To open the object from the navigation form click on the corresponding tab. The object will display in the navigation form. When the object is open, you can work with it as usual.

In short, the navigation form only includes those that are frequently used, not all of them. This makes navigating between tables, tables, queries, and reports easier, reducing the risk of database corruption by accidentally editing, deleting necessary data.

Get familiar with Acccess 2016 interface and basic operations Picture 12

Open an existing database

Before entering the data, edit the object, you need to open the database by clicking File > Open > Browser , browsing to the database folder, selecting and clicking Open .

Get familiar with Acccess 2016 interface and basic operations Picture 13

One or more warning messages may appear when you open the database. If the database contains custom functions, the yellow warning bar may appear below the Ribbon. If you trust the source of the database, click Enable Content to display it correctly.

After enabling all content in the database, you can see the message asking if you want to confirm this database is Trusted Document. Click Yes if you want all content to be automatically activated each time you open the database.

To close the current database, click File > Close .

Working with objects

To open an object, in the navigation pane, find the object and double click, the object will appear as a tab in the right pane.

Get familiar with Acccess 2016 interface and basic operations Picture 14

Ctrl + S to save the object, if it is the first save, you will be prompted to name it.

Get familiar with Acccess 2016 interface and basic operations Picture 15

Click on the X on the tab of the object in the right pane to close it or right-click on the tab select Close .

To rename an object, in the navigation pane, right-click on the object to rename> Rename .

Get familiar with Acccess 2016 interface and basic operations Picture 16

So you have basically grasped the elements of Access 2016 interface as well as the basic operations when working with this tool. In the next lesson, we will learn how to work with data in Access 2016, a great lesson.

Previous article: Introduction to tables, queries, forms, reports in Access

4.3 ★ | 4 Vote

May be interested

  • Work with data in Access 2016Photo of Work with data in Access 2016
    in the previous lesson, you became familiar with the access 2016 interface as well as the opening and closing of the basic database. this article will continue to go deeper into access 2016 around the content of working with data in access 2016.
  • Create data queries in Access 2016 from simple to complexPhoto of Create data queries in Access 2016 from simple to complex
    the query allows to retrieve information from one or more tables based on the search conditions you defined. in this lesson, you will learn how to create queries on a simple table and query on multiple tables in access 2016.
  • Options to create data queries in Access 2016Photo of Options to create data queries in Access 2016
    in this article, we will learn how to modify and sort queries in query design view, as well as how to use totals functions to create queries that can compute data. you will also learn more about other query options in access 2016.
  • Create reports in Access 2016 and use advanced reporting optionsPhoto of Create reports in Access 2016 and use advanced reporting options
    in this article, we'll learn how to create, edit, and print reports in access 2016 and how to use advanced reporting options.
  • Edit tables in Access 2016Photo of Edit tables in Access 2016
    in this lesson, you will learn how to create and rearrange fields in tables, how to ensure data is formatted correctly and consistently by setting validation rules, character limits, and data types in the school
  • How do computers read documents to you?Photo of How do computers read documents to you?
    since the early days of the computer age, users have always liked computers talking to them. today, this function has been integrated right into windows and can be easily used to read the document by the computer.