3_Queries_didactic_l1_v1

  • docx
  • 09.05.2020
Публикация на сайте для учителей

Публикация педагогических разработок

Бесплатное участие. Свидетельство автора сразу.
Мгновенные 10 документов в портфолио.

Иконка файла материала 3_Queries_didactic_l1_v1.docx

Create a new basic form based on the Pet table, which resembles the example below:

Access 2010 exercise - Creating forms (image 1)

The form tool does all the hard work!

Close the form, saving it with the name Basic Pet Details.

The aim of this exercise is to create a table to hold the countries in which films can be made.  In an Access database, create a new table:

Table of countries

Create this table using the notes below.

  

The table should have two fields:

  1. an integer field called CountryId to hold the country number; and
  2. a text field called CountryName to hold the country name.

You should make the integer field the primary key.

Now append all of the records from the Excel workbook Countries.xlsx in the folder shown above into your table:

Countries table with records

What your final table should look like - apologies for the Western slant to the data!

 

Close this table down.