Year 9 LAC ICT September

 

1.    database – A database is a collection of information arranged in a certain order.
 

2.    file – A file is an organised collection of related records.
 

3.    record – A record is a set of related information about an item or an individual.
 

4.    field – A field holds one piece of information.  Each field has two parts NAME and CONTENTS.
 

Year 9 LAC ICT October

 

1.    Microsoft Access – Is one of the most widely used database packages.
 

2.    data types – Access has many different data types; Text, Number, Date/Time, Currency, Yes/No and Auto Number.
 

3.    text – Letters, symbols and numbers i.e. Alphanumeric data.
 

4.    numbers – Numbers only (no letters.  Includes numbers with decimal points.
 

Year 9 LAC ICT November

 

1.    currency – For all monetary data.  Access will insert a currency symbol before the amount (such as £ or $).
 

2.    yes/no – Used wherever the field can only take 2 values, Y/N, True/False etc.
 

3.    auto number - This is a unique value guaranteed by Access for each record.
 

4.    date/time – Dates and times can be written in a specific format.
 

 Year 9 LAC ICT December

 

1.    database structure – What the table looks like without any information in, i.e the design of the table.
 

2.    data – This is the information which you put into the table.
 

3.    primary key – Every table in Access must have a primary key.  The field which you specify for the primary key must have a different value for each record.
 

4.    insert rows – An icon found on the toolbar which inserts a new row in the database table.
 

Year 9 LAC ICT January

 

1.    validation – The process of checking that the data meets various rules is called validation.
 

2.    validation text – The text Access will show to the user if they enter invalid text.
 

3.    < - Less than, e.g. <20 means less than 20
 

4.    <= - Less than or equal to e.g. <= Less than or equal to 20
 

Year 9 LAC ICT February

 

1.    > - More than, e.g. > 20 means more than 2
 

2.    >= - Greater than or equal to e.g. >=20 means more than or equal to 20
 

3.    = - This means equal to, e.g. =20 means equal to 20
 

4.    BETWEEN – This tests for a range of values.  Must be two comparison values (a low and high value separated by AND operator).
 

Year 9 LAC ICT March

1.    sort ascending – Records are sorted in ascending order, i.e. in alphabetical order.
 

2.    print preview – Allows you to see your database before printing.
 

3.    landscape – By clicking on the File menu and choosing Page Setup you can change your page to landscape which means your page will be sideways.
 

4.    hiding colums – sometimes you may not want to print all the columns in the datasheet.  You can hide the columns that you don’t want.
 

Year 9 LAC ICT April

 

1.    report – Allows you to present data in a wide variety of ways.  They can be based on queries or on tables.
 

2.    dialogue box – A window that lets you specify what you want to do.
 

3.    text box – The text box icon ‘ab1’ allows you to add text into the report.
 

4.    properties box - Allows you to add a count function into your report.
 

 Year 9 LAC ICT May

 

1.    Microsoft PowerPoint – A graphics presentation package.  You can use it to create, design and organise professional presentations quickly and easily.
 

2.    design template – This allows you to add a colourful background to your presentation.
 

3.    slide layout - PowerPoint gives the user options on how to lay their slide out.
 

4.    placeholders – These allow the user to add objects such as text, clipart or a chart to the show.