Video tutorial on managing databases and objects in Access software
Each database access consists of several objects that allow you to communicate with the data. Databases can include forms for entering data, searching for it, reports for analysis, and tables for storing information.
Every time you work with your database, you are working with a lot of information. Fortunately, Access software makes it easy to manage this information. In this lesson you will learn how to open and close databases and close and save information.
- During this tutorial we will use a sample database.
- If you want, you must download our sample Access database .
- To open the example you need to install Access2013 on your computer.
To open an existing database:
You must open your database before entering data or changing your data.
1. Select the file tab to go to the Backstage view.
2. Click the Open option .
3. Select Computer , then click Browse .
4- A dialog box will open. Select the database and then click Open .
5. One or more warning messages may appear when you open your database. If the database has custom functions, a yellow bar with a security alert will appear below the bar. If you trust your database source, click Enable Content to display the information correctly.
6. After activating all the contents in the database, a message may ask you if you want to create a valid document from the database? Click Yes if you want this request to be automatically activated every time you open all the content .
You may also be asked to log in to the database. Select your name in the login list. If your name does not appear, click Add user to add your information .
To close a database:
1. Select the File tab to go to the Backstage view.
2. Select the Close option.
3- If you have an unsaved subject, a dialog box will be displayed for each of them asking you if you want to save that subject? Select Yes to save the subject and select No to close the subject without saving, or Cancel to cancel opening your database.
Working with topics:
It is very useful if you think that your database is a large folder where information is stored. The data is in database subjects. Access software uses each of these themes as separate documents, meaning you have to open them separately and save them to work with.
You may find that this lesson has no instructions for saving a database. This is because you cannot save the entire database at one time. Instead you have to save the topics in the database separately.
To open a topic:
1- In the Navigation section , double-click on the desired subject.
2. The subject appears as a Tab in the document tab bar.
3- By default, the last opened topic appears in the main window as the current topic. To view another open topic, click its bar in the document tab bar.
Save a topic:
Any changes you make to any subject must be saved before closing the database. Remember that quick and accidental storage can often ruin your work. However, when you try to close your database, you are asked to save any unsaved tasks.
To save a new topic:
1- Click on the Save tab in the document tab bar to save the topic you want.
2. Click the Save button in the quick toolbar or press Ctrl + S on your keyboard.
3- The first time you review a topic, you will be asked to name it, enter the name of the topic you want and then click Ok .
4- The subject is saved. To save any changes to the theme again ordered the Save button.
To close a topic:
1. Select the topic you want to close, then click the X on the right side of the document bar.
2- If there is an unsaved change in the subject, you will be asked to save it. Select Yes to save the subject, No to close the subject without saving changes, and Cancel to leave the subject. You can also close a topic by right-clicking on its tab in the Document toolbar and selecting Close. Use Close to close all open threads.
To rename a topic:
1- If the topic you want to rename is open, close it.
2. In the Navigation section, right-click on the desired topic and select the Rename option.
3- Type the new name of the subject and then press the Enter key.
In the same way, you can manage databases and objects in your access software quickly and easily . If you have any questions, please post them in the comments section.