Many of the domestic users know what a stir happened at one time due to the modified interface of MS Office 2007, and what its developers did not water! The "Guru" complained that the new office suite had become "uncomfortable and strange," and therefore confidently predicted that he would soon die and completely forget the users.
In vain! Since nothing of the kind happened, on the contrary, it soon became clear that using the new version of the Office has become much easier and more convenient.
And therefore (as expected) all the changes, the prerequisites for which were created back in the "Office 2007", not only successfully migrated to its new hypostasis, but also received their logical development. That is why the 2010 version has become extremely popular among professional users.
Changes in the new version of Access
Very significant changes were made and the famous application for creating databases. With the new Sparklines component, you can create and edit huge amounts of information. And thanks to the Slicer tool, it became possible to easily and quickly navigate even in huge databases. And all thanks to well-thought-out and tuned filtration systems.
In addition, developers have added better integration with Excel, directly from which you can import large amounts of information. However, novice users are much more likely to wonder how to create a database in Access.
What it is
In order to correctly create the database, you must first understand their essence. A database is a strictly organized structure designed to store and organize information. It can contain extremely diverse objects, but their logical unit is a table.
Their main difference from similar structures in the spreadsheet editor is that they are interconnected. When changing any element, you automatically initiate the replacement of all structures associated with it. Simply put, you no longer have to worry about manually editing huge spreadsheets.
What operations can be performed using MS Access?
You should not assume that this application is a kind of "logical continuation" of Excel. The possibilities of this program are much wider. In particular, any creation of the MS Access database requires careful consideration of the information structure of a specific document, verification of the integrity of the source data, and the use of this information to model queries, forms, and reports.
Creation example
Since you can create a database in Access using the “Wizard”, which simplifies the work for novice users, the process itself is not particularly difficult. But we would not recommend to go this way, since for productive work you should understand all the processes that occur.
Launch the app first. The dialog for creating a new document appears on the monitor. In it you should select "New database". In the “File name” field, a meaningful one is entered. Avoid duplicate and meaningless names: as a result of any mistake or your own carelessness, you can easily lose important information.
After that, the “Create” button is clicked. Immediately after that, a dialog box for creating a new information table will appear on the monitor, on the basis of which you will create your project.
Which mode to choose?
The table can be mounted in several modes, but we would advise the “Designer”, since it is easier to control the whole process and better imagine the entire internal structure of the document.
To go to it, use the "View-Constructor" transition. After that, you can enter the required name of a specific table. Since several of them may be required at once, we recommend again to use some meaningful names.
Now, in fact, the process itself. How to create a database in Access? First of all, you need to select and fill in the field names, determine the data types, and also set the correct key field. Only then can you start filling out the table with data.
To do this, use the "View-mode table" command. Note! If in your case “Item Code” is “Counter” in your case, then you do not need to fill in a specific field. When you are done with entering information, you can close it. If a specific database needs a second table, it is mounted with the "Create-Table Designer" command.
Base Examples
All of the above would be an empty phrase without providing you with information from the “field experience” in which Access databases were useful. Examples in this area can be discussed almost endlessly, but we will focus on an option that can seriously facilitate the passage of the educational process.
Briefly describe the creation of a curriculum document . What will you need to include in it? This should include the following fields: specialty code, group number, subject and teachers. Please note: the "Subject" and "Teacher" fields must be associated with additional tables from which the program will draw relevant information.
How it's done?
First, perform all the actions according to the above instructions. Go to the "Designer", begin to fill in the fields. In the line with the specialty code, the data type should be marked as “Counter, key field”.
In “Group” and similar lines , designate the field type as “Text”. But in the fields "Subject" and "Teacher" you should select "Substitution Wizard." Do not worry: immediately after choosing this value, the program will show you a dialog box. Following his instructions, you can create a relationship with other tables. As you understand, they should be created in advance.
As soon as you click on the “Finish” button, you will see a warning that you need to save the table in order to create a link. Confirm this action.
Creating relationships between tables
We have already said that working with an Access database requires links between several spreadsheets at once. So how to create them?
To do this, open the document you need, and then follow the path "Working with Databases - Data Schema". To define and set the nature of the relationship, you must double-click the left mouse button in the dialog box "Change links". After that, click on the “OK” button. As a result, you set the default One to Many option.
So we considered the question of how to create a database in Access. We hope you find the information useful.