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.
Ribbon in Access 2016
Some groups have small arrows in the lower right corner, you can click on them to see more options.
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.
To always open the Ribbon you click on any tab, click on the pin icon in the lower right corner. Ribbon will always appear.
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.
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.
File menu
To access the File menu, click the File tab on the Ribbon:
Here you can save, open, and print databases.
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.
To minimize the navigation, click on the arrow as shown below, double click the arrow to show it again.
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:
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.
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 .
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.
Ctrl + S to save the object, if it is the first save, you will be prompted to name it.
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 .
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
You should read it
- Edit tables in Access 2016
- Calculation expressions in Access 2016
- Introduction to tables, queries, forms, reports in Access
- Create reports in Access 2016 and use advanced reporting options
- Options to create data queries in Access 2016
- Data types in Access 2016
- Convert old Access data to new Access (.accdb format)
- Format forms in Access 2016
May be interested
- Work with data in Access 2016in 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 complexthe 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 2016in 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 optionsin 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 2016in 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?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.