jueves, 23 de abril de 2020

TIPOS DE DATOS USADOS EN MICROSOFT ACCESS

Texto: permite almacenar cualquier tipo de texto, tanto caracteres como dígitos y caracteres especiales. Tiene una longitud por defecto de 50 caracteres, siendo su longitud máxima de 255 caracteres.

Número: para datos numéricos utilizados en cálculos matemáticos. Dentro del tipo número la propiedad tamaño del campo nos permite concretar más.

Fecha/Hora: para la introducción de fechas y horas desde el año 100 al año 9999.

Moneda: para valores de dinero y datos numéricos utilizados en cálculos matemáticos en los que estén implicados datos que contengan entre uno y cuatro decimales. La precisión es de hasta 15 dígitos a la izquierda del separador decimal y hasta 4 dígitos a la derecha del mismo. 

Autonumeración: número secuencial (incrementado de uno a uno) único, o número aleatorio que Microsoft Access asigna cada vez que se agrega un nuevo registro a una tabla.

Hipervínculo: texto o combinación de texto y números almacenada como texto y utilizada como dirección de hipervínculo.

Datos adjuntos: Puede adjuntar archivos de imágenes, hoja de cálculo, gráficos y otros tipos de archivos admitidos, a los registros de la base de datos de forma similar a como adjunta archivos a los mensajes de correo electrónico. 

Calculado: Un campo calculado es un campo cuyo valor es resultado de una operación aritmética o lógica que se realiza utilizando otros campos.


jueves, 26 de marzo de 2020

Ejercicios Ingles

READING
One day a visitor came to Nasreddin's house. "I am your cousin from Konya," he said, "and I have brought you a duck to celebrate the visit." Nasreddin was delighted. He asked his wife to cook the duck, and served the visitor a fine dinner.

The next day another visitor arrived. "I am the friend of the man who brought you the duck," he said. Nasreddin invited him in and gave him a good meal. The next day another visitor arrived, and said he was the friend of the friend of the man who had brought the duck. Again Nasreddin invited him in for a meal. However, he was getting annoyed. Visitors seemed to be using his house as a restaurant.

Then another visitor came, and said he was the friend of the friend of the friend of the man who had brought the duck. Nasreddin invited him to eat dinner with him. His wife brought some soup to the table and the visitor tasted it. "What kind of soup is this?" asked the visitor. "It tastes just like warm water." "Ah!" said Nasreddin, "That is the soup of the soup of the soup of the duck."
      




How many visitors came to see Nasreddin? R/4


How many of the visitors brought a duck? R/1
Did Nasreddin know the first visitor? R/ NO
Why did Nasreddin get angry? R/ The first visitor brought a duck, but the others didn't bring anything.
How did Nasreddin solve the problem? R/  He served soup which tasted of nothing, so that no more visitors would want to come to his house.

The Rabbit and the Turtle

One day a rabbit was boasting about how fast he could run. He was laughing at the turtle for being so slow. Much to the rabbit's surprise, the turtle challenged him to a race. The rabbit thought this was a good joke and accepted the challenge. The fox was to be the umpire of the race. As the race began, the rabbit raced way ahead of the turtle, just like everyone thought. The rabbit got to the halfway point and could not see the turtle anywhere. He was hot and tired and decided to stop and take a short nap. Even if the turtle passed him, he would be able to race to the finish line ahead of him. All this time the turtle kept walking step by step by step. He never quit no matter how hot or tired he got. He just kept going. However, the rabbit slept longer than he had thought and woke up. He could not see the turtle anywhere! He went at full-speed to the finish line but found the turtle there waiting for him.

Who was boasting? R/ THE RABBIT
Who could run fast? R/ THE RABBIT
Who wanted to challenge the rabbit to a race? THE TURTLE


A crow was sitting on a branch of a tree with a piece of cheese in its beak when a fox came up and saw him. He really wanted that cheese for himself. He stood under the tree and said, “What a beautiful bird! If only his voice was as beautiful as his feathers, he would be the best bird there could be!” The crow was flattered with this and opened his beak to show the fox how beautifully he could sing. Of course, the cheese fell to the ground. The fox grabbed it and said, laughing, “You have a voice, I can see. What you do not have is wits!”
The crow had R/  a piece of cheese
As the crow sat there, who came up? R/ A FOX
The fox wanted R/   to have the cheese.

The Mice In Council

One day a group of mice decided to call a meeting to see what they could do about the cat which was always trying to catch them. They talked about lots of plans but none of them seemed like they would work. At last, a young mouse got up and said that a bell should be hung around the cat's neck so all the mice would be able to hear when he was coming closer. All the mice thought this was an excellent idea. However, an older mouse got up and spoke, "This is a really good idea but who is going to tie the bell around the cat's neck?"

What is a council? R/ a meeting
Who had the council? R/ the mice
Who gave the idea for a plan that would work? R/  the young mouse


A rooster sat perched way up in a tree, crowing loudly. A fox heard him and came running to see if he could get a chicken dinner. On the way he thought up a plan to get the rooster to come down. “Hello, brother Rooster,” he said in his nicest voice. “Have you heard of the universal peace agreement that has happened between all the animals? We will none of us ever eat each other again but live in peace. Why don’t you come down and we can talk about this great news?”
The rooster knew what kind of animal the fox was. He knew the fox was trying to trick him. So he decided to trick him back. He looked very closely at something far in the distance. “What are you looking at up there?” asked the fox. “I think I see a pack of dogs coming this way on a fox hunt.”
“Well, if that is the case, I better be off,” said the fox.
”But why would you be afraid of dogs in a time of peace like this?” asked the clever rooster.
“I am not sure they have heard about the new agreement of peace,” he said and took off.

The rooster was way up in a tree R/   crowing loudly.
The fox ran to the rooster to get a R/   chicken dinner.
The universal peace agreement means R/   no animals will eat each other.

Mrs Smith is going shopping with her son. They are looking for a present for Mr Smith's birthday. Mrs Smith wants to buy him a new camera and Tom wants to buy him a jumper.

They drive to the department store on the high street. Mrs Smith uses the escalator to go to the Electrical Department on the third floor and Tom takes the stairs up to the Men's Clothing Department on the first floor.

When she gets to the Electrical Department she finds that cameras are sold in the Photography Department on the ground floor. She takes the elevator down and asks the sales assistant there for some help. She doesn't know much about cameras and needs some advice. He recommends an automatic camera by Olympus, but it is too expensive. She asks him if he has anything a little cheaper and he tells her about a special offer on the Pentax range. It still seems expensive so she thanks the assistant and decides to shop around first.

Meanwhile, Tom is looking at the jumpers. He only has £10 to spend so he can't afford most of them. He sees his mother and they decide to go to the smaller shops round the corner.


What department does Tom go to? R/The Men's Clothing Deparment.
Where are the cameras sold?R/ The Photography Department
Did they walk to the shops? R/ no



A lion was very angry with a gnat that kept flying and buzzing around his head. The gnat would not quit bothering the lion. “Do you think that you, the great king of all the animals, can make me scared?” the gnat said to the poor lion. The lion just kept trying to hit the gnat with his big paw. All he did was scratch himself with his great claws. The gnat laughed and flew between the big paws and stung the lion on the nose. He then buzzed away laughing at how he had stung the great lion. However, he was so busy thinking of how he would boast that he did not see the spider web. He got stuck in the web of a little spider and that was the end of him.


The gnat kept flying around the lion and made the lion R/ angry
The gnat kept buzzing around the lion to R/   make him angry.
The gnat was R/   boasting about himself.


One day two travelers came upon a bear. After the first had saved himself by climbing a tree, the other, knowing he had no chance against the bear by himself, lay on the ground as if he was dead. The bear came up to him, sniffed him around the ears but thinking him dead walked off. His friend climbed down from the tree and asked, “What was the bear whispering in your ear”
“Oh, he just said I should think twice about traveling with people who run out on their friends.”

How many were traveling together when they met the bear? R/ two
What did the first man do? R/ he climbed at tree
What did the second man do? R/   He lay on the ground.

Bradley Wiggins In Line For Freedom Of Westminster

There are calls for Bradley Wiggins to be given the Freedom of the City of Westminster after his historic Tour de France win.

The 32-year-old cyclist sealed Britain's first Tour victory on Sunday and now councillors want to honour him.

He grew up in Maida Vale and used places such as Hyde Park and Paddington Recreation Ground to train in.

A Westminster City Council spokesman said giving Wiggins the award "is something we are keenly looking at".

'Great role model'

Councillor Paul Dimoldenberg, leader of Westminster Council's Labour group, said: "Bradley Wiggins is the most fantastic sportsman and it all started in Maida Vale.

"Westminster City Council should honour this most dedicated sportsman for his achievement as the first Briton to win the Tour de France, as well as his magnificent Olympic medals.

"Bradley Wiggins is a great role model for young people and the council should award this honour in Olympic year 2012."

One of the Maida Vale councillors, Alastair Moss, Conservative, said: "Bradley Wiggins has scored a historic sporting victory and inspired huge pride across the country - no more so than in his home turf of Westminster and Maida Vale.

"Recognising Bradley's outstanding achievement through the Freedom of Westminster award is something we are keenly looking at."

Wiggins now lives in Lancashire.

Previous holders of the Freedom of Westminster include Sir Winston Churchill and Baroness Thatcher.
  1. Who is being offered the freedom of the City of Westminster?
    Bradley Wiggins
    How old is the proposed recipient? R/   32 years old



    London

    London is the capital of Great Britain. It is situated in the southeast of England on the River Thames and there are lots of bridges across the Thames. The most famous of these bridges is Tower Bridge. The machinery which draws up the bridge when a ship passes under it is hidden in the two towers. Near Tower Bridge, on the north bank of the Thames there is the Tower Of London. It is a big castle, its oldest part, White Tower, dates back to the times of William the Conqueror. Back in history The Tower served as a prison - now it is one of London's main tourist attractions. Tourists are guided by "Beefeaters" in historic uniforms and the Crown Jewels are on display there.

    Another magnet for tourists is St. Paul's Cathedral. It is Sir Christopher Wren's masterpiece. Like many other churches it was built after the great fire had destroyed big parts of London in 1666. It is 110 metres high and 627 steps lead up to the Whispering Gallery in the dome. In 1981 the royal wedding between Prince Charles and Lady Diana was celebrated there.

    The London home of the Queen is Buckingham Palace where you can see the "Changing of the Guards". The coronation of the Kings and Queens takes place in Westminster Abbey. Near this enormous church there are the Houses of Parliament, the seat of the British government. They consist of a group of buildings, among them St. Stephen's Tower, the famous clock tower housing Big Ben, one of the world's biggest bells.

    Not far from the Houses of Parliament there is Trafalgar Square with Lord Nelson's Column, erected in the memory of Admiral Nelson, who won against the Spanish in the Battle of Trafalgar.

    London is also famous for its parks. There is Hyde Park, there is St. James's Park, which is the oldest and there is Regent's Park, which houses the London Zoo. In former times all the parks were royal gardens.

    Apart from sightseeing tourists also love shopping in London. You will find the big stores in Oxford Street and the smaller shops in the little side streets.

    At night the West End offers all kinds of entertainment like music, theatre or cinema.

    Where is London situated? R/   In the southeast of England.
    What is the river through London called? R/   the Thames
    How many towers has Tower Bridge got? R/ two

 


Ejercicios ingles

LISTENING  COMPLETE THE SPACES


Anna (1) with her parents in Marrickville. Every morning she (2) English at the TAFE college in Petersham. In the evening she usually (3) her mother with the cooking and the , (4) but on Wednesday evening she (5) to an Italian cooking class.
On Saturday night she goes to the (6) with her boyfriend. On Sunday she goes (7) train to Parramatta to see her aunt and uncle.

1.lives
2.studies
3.helps
4.housework
5.goes
6.movies
7.by

http://www.adelescorner.org/listening/my_family/my_family.mp3
My family (1) in Melbourne. There (2) six people in my family. My mother and father live in a (3) house. The house has four (4) and a big backyard. There are (5) in the front yard.
My older brother, Alan, is (6) with two children. My younger brother, Bill, and my sister, Sue, live (7) home. My father (8) in an office in Belmore. He is a (9). My mother works at home and (10) after the house.
I am very lucky to have a wonderful family.

1.lives
2.are
3.large
4.bedrooms
5.flowers
6.married
7.at
8.works
9.manager
10.looks
http://www.adelescorner.org/listening/my_weekend/my_weekend.mp3
Every Saturday I (1) late. At eleven o'clock I go (2) at the supermarket and the fruit and vegetable market. Then I go (3) at the local swimming pool. After that, I (4) lunch and then (5) my house. In the evening I usually go out to a (6) with friends.
On Sundays I also get up (7). After breakfast I go swimming for some (8) exercise. In the afternoon I (9) my parents. In the evening I (10) dinner and watch TV. I (11) read a book in bed.

1.get up
2.shopping
3.swimming
4.have
5.clean
6.restaurant
7.late
8.more
9.visit
10.cook
11.sometimes
http://www.adelescorner.org/listening/a_busy_day/busy_day.mp3
Today will be a very (1) day for me. At nine o'clock I (2) a doctor's appointment. Then I need to go to the (3) to get some money. At ten o'clock I have a dentist's appointment for a (4).
At twelve noon I'm meeting a friend for (5) at a Thai restaurant. After that, I want to (6) a new dress for my niece's birthday party. Then I'm (7) my son from school and taking him to football (8). At seven o'clock I go to my evening class. I (9) home at half past nine. It will certainly be a very busy day.

1.busy
2.have
3.bank
4.checkup
5.lunch
6.buy
7.picking up
8.training
9.get
http://www.adelescorner.org/listening/my_day/my_day.mp3
Every day I (1) at half past six. First I (2) to the kitchen and (3) a cup of tea and toast for breakfast. Then I (4) to the bathroom and (5) my teeth. After that, I (6) dressed and (7) my hair.
At half past seven I (8) to work. I (9) the bus to Cabramatta. It (10) a long way from home. I (11) at work at ten to eight. At twelve o'clock I (12) lunch and at four o'clock I (13) home.
At seven o'clock I (14) dinner with my family and then we (15) TV. At a quarter past eleven I (16) to bed.
1.get up
2.go
3.have
4.go
5.clean
6.get
7.brush
8.go
9.take
10.is
11.arrive
12.have
13.go
14.have
15watch
16.go
http://www.adelescorner.org/listening/hue_les_story/huele.mp3
Hue Le (1) a student. She is 22 (2) old. Hue (3) English every day and her (4) is Bill Johnson. He is a (5) teacher.
Hue's classroom is (6). It is on the second floor. She (7) at the front of the room. She likes learning English.

1.is
2.years
3.studies
4.teacher
5.good
6.small
7.sits
http://www.adelescorner.org/listening/ying_jies_story/yingjie.mp3
My (1) is Ying Jie and I come (2) China. I have (3) in Australia for three months. I live (4) Sydney and my address (5) 10 Railway Parade, Cabramatta. I'm 25 years (6) and married with two beautiful (7). In China I was a (8) and in Australia I'm a typist, too.




1.name
2.from
3.been
4.in
5.is
6.old
7.children
8.typist
http://www.adelescorner.org/listening/min/min.mp3
Min (1) from Vietnam and he (2) in an apartment in Dulwich Hill. He's (3) with a baby daughter. He works in a (4) and his wife looks (5) the baby. On the weekend he (6) on a picnic with his family. If they don't (7) on a picnic, they (8) his sister in Wollongong.
1.comes
2.lives
3.married
4.factory
5.after
6.goes
7.go
8.visit
http://www.adelescorner.org/listening/personal_id/pid.mp3
1. What's your ? (1)

My (2) is Jenny.
2. Where do you (3) from?

I (4) from China.
3. Where do you ? (5)

I (6) in Parramatta.
4. What's your ? (7)

My (8) is 54 Pine Street, Annandale.
5. What's your ? (9)

My (10) is 9723 4444.
6. How old (11) you?

I'm 28 years old.
7. What's your ? (12)

I'm Indonesian.
8. Are you ? (13)

No, I'm not. I'm single.
9. Have you (14) any children?

Yes, I . (15)
10. What's your ? (16)

I'm a doctor.

1.name
2.name
3.come
4.come
5.live
6.live
7.address
8.address
9.telephone number
10.telephone number
11.are
12.nationality
13.married
14.got
15.have
16.occupation
http://www.adelescorner.org/listening/anna/anna.mp3
Anna (1) with her parents in Marrickville. Every morning she (2) English at the TAFE college in Petersham. In the evening she usually (3) her mother with the cooking and the , (4) but on Wednesday evening she (5) to an Italian cooking class.
On Saturday night she goes to the (6) with her boyfriend. On Sunday she goes (7) train to Parramatta to see her aunt and uncle.

1.lives
2.studies
3.helps
4.housework
5.goes
6.movies
7.by