Adding Buttons to a form

This is a very difficult process to decipher as it the task itself was done through 2003 Access. Through playing around with buttons we were eventually able to complete the task.

The buttons enable the database to be easier to navigate. They enable ease of use and make certain tasks easier.

Clicking on the created button "photo" in access takes us to the form containing their ID photo.

I further created a button on this form so I can return to the button page.

Adding Sound to a form

The process of adding a sound to a database follows the same process as adding an image.

-Create a field and rename it
-Set data type to OLE object
-Right click and click on insert object
-Click on create from file
-Use browse to find your sound file and click ok
-After this process the file should show up in your database
-Create a form using form wizard
-The sound file should be in place in the form

Social Issues Related to databases

In our group we have Krozina, Diyomira and myself.

We are researching Identity fraud.

I am doing questions 2 and 5.

Bits and Bytes

What is a digit?
A digit is a single place that can hold numerical values between 0 and 9. Digits are normally combined together in groups to create larger numbers.

2. “normal” counting numbers used in everyday life a based on what sequence of numbers? The binary number system

3. Where does the word bit originate from?

The word 'bit' was derived from the term binary digit (0 and 1).

4. Binary numbers don’t use base 10. What base do they use? What digits are available in base 2?

Binary numbers use base two. The digits it uses are 0 and 1.

1. Examine the tables below

Base 10

Place Value	10 000	1 000	100	10	1
Place Value	104	103	102	101	100
Digit	9	0	3	0	2
Digit Value	90 000	0	300	0	2

90 302 (base 10) = (9 x 10000) + (3 x 100) + (2 x 1)

If 6,357 can be written as;

(6 * 1000) + (3 * 100) + (5 * 10) + (7 * 1) = 6000 + 300 + 50 + 7

Ø How would you write 4,321

(4*1000)+(3*100)+(2*10)+(1*1)

2. Examine the table below

Base 2

Place Value	16	8	4	2	1
Place Value	24	23	22	21	20
Digit	1	0	1	0	0
Digit Value	16	0	4	0	0

10100 (base 2) = (1 x 16) + (1 x 4) = 20 (base 10)

Ø Write the following numbers in binary (base 2)

21

24

30

3. What is a byte?

A group of binary digits or bits (usually eight) operated on as a unit.

3. How many bytes in a kilo, mega, giga and tera bytes.

Kilo: 1024 bytes

Mega: 1 048 576 bytes

Giga: 1 073 741 824 bytes

Tera: 1 099 511 627 776 bytes

3. Complete the following conversions;

1000 Mb = 0.9765625Gb

500 Gb = 512000Mb

5000 Kb = 4.88281Mb

Creating Forms

This task requires us to create a form.
A form is used to display data so it is easy to read and more understandable then just reading off a data table.

This is a screenshot of my created form. It makes the general infomation about the product easier to read.

Data Types

There are nine possible data types in Access, They are:
-Text
-Number
-Currency
-Attachments
-Hyperlink
-Yes/No
-OLE Object
-Date/Time
-Memo

All these types have different roles and usages in the creation of the databases.

I have created a database for data types listing the Data type, typical usage, size and an example.

Queries

Contact name and number of companies in the USA?

This was done through creating a query and selecting Product name, Product Number and Country. I wrote USA in the criteria and it showed me the four companies in the USA.
Product names that cost more then $20.00

I did this through creating a query and selecting Product name and Unit Price. I wrote >20 and the query selected all the products that were priced above $20.00
Products with more then 30 items in stock-

I did this through creating a query and selecting Product name and Units in stock. I wrote >30 in the criteria and the query selecting all the products with more then 30 units in stock.

Querying A Database

What sort of information has the query selected?
Any product that has a price that is $10.00

What sort of information has this second query selected?

Any product that has a price that is $20.00 or more. ( I did this by saying >19)

Describe the type of information these queries are selecting.

1. This query has selected any of the products with a recorder level of 10.

 2.  This query has selected any of the products with any recorder level. This is done through not putting a particular amount into the criteria section of the query.

Creating a Basic Database

Notes:

• 
  
  Part 1
  
  
  -Tables Organize your data.
  
  
  -All databases in Access contain at least one table.
  
  
  -Tables store data, so they're essential building blocks of any database. 
   
  Fig. 1  The row containing information about United Package is a record.
  Fig. 2  The column containing phone numbers is a field.
  
  
  -A database should have a separate table for every major subject.
  
  
  -Each table contains rows called records and columns called fields.
  
  
  -A record is a collection of facts about a particular person, event, CD, or other item of interest. 
  
  
  -A field is a single kind of fact that may apply to each person, event, or other record.
  
  
  -If an existing field name isn't descriptive enough, you can rename the field.
  
  
  -A field's data type limits and describes the kind of information you can enter in a field, such as Number or Currency.
  
  
  -You use a unique identifier, called a primary key, for each record in your table.
   
• -Field properties are a set of characteristics that provide additional control over the data.  
  
  
  -The fields in your database have settings that determine the type of data they can store, how the data is displayed, and what you can do with the data. 
  
  
  -One important setting for fields is the data type, including number, text, currency (money), and date/time.
  
  -Each record in each table should be unique—in other words, you wouldn't have two identical records about Nancy Davolio in the same database. But what if you have two employees named Nancy Davolio?
  
  -To distinguish one record from another, tables can contain a primary key field.
  
  -The primary key is an identifier—such as a part number, a product code, or an employee ID—that's unique to each record.
  
  -The primary key should be a piece of information that won't change frequently.
  
  -Employee ID appears in both tables—as a primary key and as a foreign key.
  
  -A primary key separates similar information and makes each record unique.
  
  -You relate one table to another using a primary key. This is how tables share data, and how you can avoid repeating information in both the tables.
  
   TEST RESULTS
  
  
  Part 2
  
  -Queries can answer  questions by assembling stored data from your database, or by performing calculations with the data to provide further information.
  
  -To answer questions, queries retrieve, filter, sort, and assemble data on command. Another important power of queries is to combine the data from several tables into a single view.
  
  -A query can also remove data.
  
  -Forms enable people to enter or view data in your database easily.
  
  -Forms control and simplify data input.
  
  -Forms make data from a table or a query easier to understand by presenting it in visually appealing designs.
  
  -A report converts data into a formatted document.
  
  -Using reports, you can group your data, perform calculations on it, and add headings and other formatting to make it more meaningful and easier to read. 
• TEST RESULTS