databases

= = >>
 * ===Notes===
 * Databases Mindmap
 * Databases Notes
 * Databases Questions 1-3 Pg 109
 * Field types Table
 * Data Validation and Verification
 *  Importing CSV
 * Queries
 * Reports
 * How to perform calculations in a database
 * Adding calculations to a report
 * Data Manipulation Checklist
 * ===Assignments===
 * Databases Project Plan
 * Final Project
 * School Database Questionnaire
 * Sample School database table (Students table in Access, Screenshot)
 * Database Query
 * Calculation Worksheet
 * Task 1: Database Structure
 * Task 2: Creating a file
 * J9Sales Database
 * <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Week 37 Sales
 * <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Exporting to Excel
 * <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Exporting to Word
 * <span style="font-family: Arial,sans-serif;">Working with a Summary Query
 * ===Homework===
 * [Replace this with homework heading and date due i.e. Complete Worksheet 3 (3/23/2010)]

Assignments
Poster plan == name of product the cost of the product the percentage that shop puts on product - mark up the final cost of the product to be sold in the shop number of items
 * Field calculations**
 * Fields || Type || Lenght ||
 * Product || text || 15 ||
 * price || <span style="font-family: Arial,Helvetica,sans-serif; line-height: 19px;">Numeric/Currency || 12.5 ||
 * Cost || Number/currency || 6 ||
 * Mark Up || Percentage ||  ||
 * Final Cost || Number || 9999 ||

=
*the option where all of the fields stay with the same number of characters ======

=
*A field that has a unique value, regardless of how many records there are ======

=
screen design (the position of the fields on a record to where you want them, and to add colors etc to improve the visual appearance of records) ====== data input in databases

2.Give two reasons why choosing the correct field type is important

3. Give two reasons why setting the maximum length of a field can be important By deciding in advance the maximum of the field, file size can be kept as small as possible, as there is no wasted space The time taken to process data is kept to minimum


 * Field type || ﻿When the field data is: ||
 * Text || Text (usually up to 255 characters) ||
 * Memo || Large amount of text (usually up to 6444 characters) ||
 * Number (also known as numeric field) || Numbers ||
 * Data || Dates ||
 * Time || Time, for example 16:40 ||
 * Currency || $ or Euros ||
 * Autonumber || Automatically generates a number every time a new record is created ||
 * Container || Picture, video clip, sound file or OLE object from another program (Windows only) ||
 * Yes/No (also known as a Boolean field) || Yes or No ||
 * Calculation || Result of formula, for example Balance= Field “money in ” – Field “money out” ||

Query Report

Report Queries Query imported in MS exel Query imported in MS word



E


 * Key field -A field that has a unique value, regardless of how many records there are **
 * form -**

**3. Becouse than there is no wasted storage space.**

 * **Field Type** || **When the fields data is…** ||
 * **Text** || **Text (usually up to 255 characters=** ||
 * **Memo** || **Large amount of text (usually up to 64000 characters)** ||
 * **Number (also known as a numeric field)** || **Numbers, for example 12345** ||
 * **Date** || **Dates, for example 21/04/62** ||
 * **Time** || **Time ,for example 12:12** ||
 * **Currency** || **£ or $** ||
 * **Autonumber** || **Automatically generates a number every time a new record is created** ||
 * **Container** || **Picture, video clip,sound file or OLE object from another program (Windows only)** ||
 * **Yes/No (also known as the Boolean or logical field)** || **Yes or No** ||
 * **Calculation** || **Result of a formula, for example Balance =Field ´monei ir´ - Field ´money out´** ||

Data Manipulation Checklist Name…………………………..... Creating a New Database Tick _ 1 I can Create a New Blank Database 2 I can Name and Save a New Database 3 I can Create a New Database Table in Design View 4 I can type in Field Names and Descriptions 5 I can assign an appropriate Data Type to a Field e.g. Text, Number , Date , Currency, Yes/No 6 I can assign appropriate Field Properties e.g. Field Size, Format 7 I can Name and Save a New Database Table 8 I can look at the Database Structure in Design View 9 I can look at the Database Structure in Data Sheet View Database Entry Tick _ 1 I can Enter Data in Data Sheet View 2 I can Create a New Data Entry Form using Form Wizard ( All Fields, Columnar ) 3 I can Enter Data using the Data Entry Form 4 I can Import Data from external data Files e.g. .CSV, .TXT , .XLS (Use File , Get External Data , Import) 5 I can choose correct Field Delimiters (e.g. a comma for .CSV files) 6 I can Import Data from external data Files into a New Table OR Existing Table Reorganising Data Tick _ 1 I can Sort Data in Data Sheet View (simple Ascending or Descending Sort) 2 I can Sort Data on Two or more Fields ( Drag Fields next to each other then a simple Ascending or Descending Sort) 3 I can Remove the Sort from a Table (choose Records|Remove Filter/Sort ) 4 I can Filter Data by Selection (Select a Field Item and Filter ) 4 I can Filter Data by Form (Select a Field Item in the blank database and Filter ) 5 I can Create a Query using Query Wizard (Add Table, Choose Fields, Sort & Run ) 6 I can Name and Save a Query 7 I can Create a Query using Criteria to select required data 8 I can Create a Query using more than ONE Criteria (Using AND, OR ) Reporting Data Tick _ 1 I can Create a Report using Report Wizard (Add Table/Query, Choose Fields, Sort  & Landscape! ) 2 I can Name and Save a Report 3 I can Format a Report using Design View using the Toolbox (Add Heading, Name, Date, Page Numbers etc.) 4 I can Print a Report ( Print Preview first! Choose Print from File Menu) Report Calculations Tick _ 1 I can include Calculations ( Total, Sum , Average , Count ) in a Report Footer – Select Text Box Tool in Design View – Choose Properties (right click) – Choose Control Source to open Expression Builder – use Built in Functions © Clive