Telegram channel Programmer and business. Every day there are interesting stories about how a programmer builds a business.
A modern person probably can’t imagine his life without communicating on social networks. There people find out news, communicate, exchange files, look for new friends, and sell goods. For example, using certain filters you can find people of the desired age category or by place of residence. Many people do not want to indicate their birthday or, on the contrary, want to change it. Read the article carefully and find out how to change your date of birth in VK in different ways and what this can affect.
How to add your date of birth on VKontakte
To indicate your DR on the VKontakte page, click on your profile thumbnail in the upper right corner. From the drop-down list, click “Edit”.
Then, on the “Basic” tab, find the “Birthday” line. Instead of the words “Day”, “Month”, “Year”, click on the arrows and select the necessary data from the lists.
After specifying your birthday, scroll down the page a little and click “Save”.
Now any user can see when they were born in your profile.
How to change your date of birth
In order to change the previously specified DR, again click on the miniature avatar in the upper right corner of the page and click “Edit”.
In the “Birthday” field, change what you need: day, month or year by selecting the appropriate value from the drop-down list.
When you change the date, click on the “Save” button at the bottom of the page.
Generating complex queries to a ready-made database
- Home | Computer Science and Information and Communication Technologies | Lesson planning and lesson materials | 8th grade | Planning lessons for the school year | Generating complex queries to a ready-made database
- Acquired skills and abilities: - Formation of queries using logical operations.
- — Creation of calculated fields.
|
|
Practical task No. 11 Topic: Selection conditions and complex logical expressions
Task 1 (single-table database)
1. Open the database “Abiturient.mdb”
Preparation for practical work on database from the author. Semakina in the format for Access.mdb Base – Abiturient.mdb
Open the database “Abiturient.mdb”
Preparation for practical work on database from the author. Semakina in format for OO.org Base - Abiturient.odb
Open the database “Abiturient.odb”
2. Create a query to select last name, first name and school for all applicants who graduated from schools 44 and 59 .
3. Create a query to select all applicants who did not study in the preparatory courses and received a “D” on the exam in mathematics or computer science (display all table fields).
4. Create a query to select the last name, date of birth and all grades of applicants who received only “B”s and “A”s” in the exams .
5. Create a query to select the last name and date of birth of male applicants born in 1990 .
6. Create a query to select the last name and all grades of applicants who have scored a total of at least 13 points .
Task 2 (multi-table database)
1. Open the database “Applicant1.mdb”
2. Create a request to display the fields last name, faculty, name of specialty for applicants entering the mathematics and physics faculties and who have completed preparatory courses.
3. Create a query to display the last name, faculty and total points for applicants who have scored a total of more than 12 points in three exams .
4. Create a query to display the last name, faculty, grade for the 1st exam, grade for the 2nd exam, grade for the 3rd exam for all applicants whose grade for the 3rd exam is higher than the average score for all exams .
5. Create a request to display the last name, date of birth, name of specialty and faculty for applicants of all faculties, except physics, born in 1991 .
Source: https://xn—-7sbbfb7a7aej.xn--p1ai/informatika_08_sim/informatika_materialy_zanytii_08_23.html
How to remove others
If you once indicated a significant date on your VKontakte page a long time ago, and now you don’t want it to be displayed on your profile, then you can delete it. Click on your thumbnail avatar and select “Edit.”
On the “Basic” tab, in the “Birthday” field it will say “Show date of birth”. Click the down arrow next to this line and select “Do not show date of birth” from the list.
Save your changes.
Now, when you go to the main page of your profile, friends and guests will not be able to find out when you were born.
As you can see, we did not delete the DR in the account settings, but made sure that it was not displayed on the page, so no one would be able to recognize it.
Why put a real date?
Despite the simplicity of the methods above, it is better to indicate your real date of birth. First of all, this will be useful if suddenly your page is hacked or you delete it and then decide to return it. If it suddenly happens that you forget what date you indicated, then there may be problems with recovery. In addition, many groups on VK monitor their reputation and do not accept subscribers under a certain age. And if someone just decides to find out your real age, then it’s not that difficult. For example, it will be enough to simply go to the pages of your classmates and classmates. In a word, think before you change your date of birth in VK - do you really need it?
How to hide your age
If you want other users not to know how old you are, then you can either completely remove your birthday from the page, as described in the previous paragraph, or simply indicate the day and month without a year.
Select “Edit” from the drop-down menu again.
Next, in the “Birthday” field, select “Show only month and year” from the list.
Click on the “Save” button.
Now the content on your page will be displayed as follows. Users will know when you were born, but how old you are will not be clear.
How to remove the VKontakte registration date
Surely most users tried to find some information about their page. Various applications help them with this, but VK itself practically does not provide a person with any data. And now, a new update has arrived, thanks to which users can now see the registration date of their page. But most likely many will not like this and will want to get rid of the registration date. In this article we will answer the question of many people and try to help them hide the registration date, because for many this is personal information that they do not want to share with people. Perhaps this is completely impossible for now and can only be removed through the efforts of third-party developers.
How to add or remove age from your phone
If you are used to using the VKontakte mobile application from a phone or tablet, then go to it and in the side menu click on the thumbnail with an avatar.
Further at the top right, click on the three vertical dots.
In the list that opens, select “Edit Page”.
Find the “Birthday” field and click the arrow next to the date.
Select the appropriate day, month and year, and click “Done”.
Just below the selected date there will be another line. Click on the arrow next to it and select from the list the item that suits you. If you need to completely remove your birthday from the page, select “Do not show on your profile,” if you want people not to know your age, select “Show only the day and month.”
After selecting the date and indicating whether it will be displayed in full or not, click on the checkmark in the upper right corner to save the changes.
I think you have succeeded, and now guests will be able to find out when you were born, or, conversely, they will not be able to see how old you are.
DateAdd function in Access queries
Syntax: DateAdd("interval", number, date).
The DateAdd function in Access queries takes 3 arguments. All arguments are required. 1 argument - INTERVAL. The interval is the period of time that needs to be added (subtracted) to the required date. Argument 2 is NUMBER.
This is the number of specified intervals that will be added to the date. Argument 3 - DATE. The date to which intervals are added using the DateAdd function.
All parameters of the first argument, the interval, are presented below:
Let's give a simple example and see how the DateAdd function works in Access queries. Let's create a table that will consist of 2 fields: “start date” and “start time”. Both fields are of the Date/Time type. The “start date” field is in the “short date format” format, the “start time” field is in the “short time format” format.
Let's fill the table with arbitrary data.
Next, we’ll create a simple query where we’ll add 10 days to the “start date” field. Let's add the "start date" field to the request. Let's add a new calculated field:
This example demonstrates the basic principle of the DateAdd function in Access queries: 10 days are added to the date.
Consider the following example, which uses the DateAdd function in Access queries. Let's add 10 months to the date. To do this, just change the interval value from “d” to “m”.
Consider the following example, which uses the DateAdd function in Access queries. Let's add 10 years to the date. To do this, just change the interval value from “m” to “yyyy”.
Consider the following example, which uses the DateAdd function in Access queries. Let's add 1st quarter to the date. To do this, just change the interval value from “yyyy” to “q”.
- The DateAdd function in Access queries not only adds a specified interval to a date, but also subtracts a specified interval from a date. An example of subtracting 10 years from a date is shown below:
Want more examples of the DateAdd function in Access queries? For example, how can you use DateAdd in Access forms? Follow the LINK .
If you need a ready-made Access database, then check out the list provided HERE .
Source: https://accesshelp.ru/funkcija-dateadd-v-zaprosah-access/
