update table from query

http://www.techonthenet.com/access/queries/update2.php

see disable at end of article

http://office.microsoft.com/en-us/access-help/create-a-make-table-query-HA010108505.aspx#BM1

see disable at end of article

http://office.microsoft.com/en-us/access-help/create-a-make-table-query-HA010108505.aspx#BM1

compare value user and password

http://www.programmersheaven.com/mb/ASPNET/286028/286028/comparing-value-in-textbox-with-a-field-in-a-database/

password

http://stackoverflow.com/questions/5268235/access-2007-get-vb-user-login-and-record-for-last-modified-form

macro action reference

http://www.brainbell.com/tutorials/ms-office/Access_2003/Macro_Action_Reference.htm

Creating_And_Running_A_Macro.htm

http://www.brainbell.com/tutorials/ms-office/Access_2003/Creating_And_Running_A_Macro.htm

using macros and buttons

http://www.youtube.com/watch?v=xYL8OXtlZwM

average etc in reports

 int( [number_of*]) data in table




in report
Average stars  

= left ("*****",int (average number of *))    ------- this gives * or ** or ** etc...



http://www.youtube.com/watch?v=16R4YgNt_Rk

count

http://www.techonthenet.com/access/functions/numeric/count.php

count numer of records in query

http://www.ehow.com/way_5928861_do-records-query-microsoft-access_.html

make table query

http://www.databasedev.co.uk/make-table-query.html

http://www.ehow.com/how_2020502_create-query-access.html

contents field in msgbox

http://forums.aspfree.com/microsoft-access-help-18/using-contents-of-field-in-msgbox-402297.html

date stamp marco

http://office.microsoft.com/en-us/access-help/recording-the-date-and-time-when-a-record-is-modified-in-access-HA001034535.aspx

validation rules

http://allenbrowne.com/ValidationRule.html

variable in message box

http://www.pcreview.co.uk/forums/msgbox-display-variable-msgbox-t3634165.html




iff age2<18 then msgbox."sorry but you are to young to be  a member2 else "welcome to the cinema club","username="&query!user......

message macro

message macro

functions

http://www.techonthenet.com/access/functions/

incrementing-the-numeric-portion-of-a-string

http://office.microsoft.com/en-us/access-help/incrementing-the-numeric-portion-of-a-string-in-access-HA001055083.aspx

incrementing counter

video

reset autonumber

Method 1
You can reset an AutoNumber field value so it corresponds with one of the fields in the table. To do this in Microsoft Office Access 2003 and in earlier versions, follow these steps:

1. Delete the AutoNumber field from the main table.
   
   Make note of the AutoNumber field name.
2. Click Queries on the left pane. Double-click Create query in Design view on right pane.
3. In the Show Table dialog box, select the main table. Click Add and then click Close.
4. Double-click the required fields in the table view of the main table to select the fields.
5. Select the required Sort order.
6. On the Query menu, click Make-Table Query. Type the new table name in the Table Name text box and then click OK.
7. On the Query menu, click Run.
8. A dialog box appears with the text that follows: You are about to append # row(s) into a new table. Click Yes to insert the rows.
9. On the File menu, click Close. Click No to close the Make-Table Query window.
10. Click Tables on the left pane. Right-click the new table and then click Design View.
11. In the Design view for the table, add an AutoNumber field with the same field name that you deleted in step 1. Add this AutoNumber field to the new table and then save the table.
12. Close the Design view window.
13. Rename the main table name. Rename the new table name to the main table name.

autonumber

http://www.developerbarn.com/access-database-samples/925-how-set-autonumber-easy-method.html
http://support.microsoft.com/kb/209696

duplicates

http://www.ehow.com/how_2020526_wizard-duplicates-access.html

DOB

http://office.microsoft.com/en-us/access-help/calculating-age-from-a-birth-date-in-access-HA001055071.aspx

age from birthday

http://office.microsoft.com/en-us/access-help/calculating-age-from-a-birth-date-in-access-HA001055071.aspx

date to age

link

presence check

A presence check means that the computer looks to see if data is present in a
field. Presence checks are used in cases where it is not allowed to leave a field
blank. In Access, to create a presence check for a field, we set the ‘Required’
option in the table design view to ‘Yes’.

Validation rules

 rules

http://office.microsoft.com/en-us/access-help/create-a-validation-rule-to-validate-data-in-a-field-HA010096312.aspx

next part of Unit 7

See you Thursday and Friday 10 o'clock in canteen
Jake

next stage of Unit 7

see you Thursday and 10 o,clock Friday in canteen if thats ok with you.
jake

link data- see both

http://www.youtube.com/watch?v=zzrd4tjPiYY

joining strings with concatenation

http://www.youtube.com/watch?v=EpRSczP6aOA

access input

http://www.bigresource.com/VB-Access-table-in-database-Login-System--muWBmFsWIm.html#YxZFJxehYe
link

multiple access video tutorials

http://www.youtube.com/playlist?p=PL1F92EC4198094437

more password

http://www.youtube.com/watch?v=UO4HeWnuT3A&playnext=1&list=PL1F92EC4198094437

password

http://www.youtube.com/watch?v=pT2boGE-bAg

login

http://www.databasedev.co.uk/login.html

Finished

Hello!


I finished. When do want to meet??

scan of proposal

https://docs.google.com/leaf?id=0BwLfsq9Sg7EbNWU5ODUyOWEtYWI3Yy00YjA4LWFlN2YtMTk1YzA2MzgwMDBj&hl=en_GB&authkey=CMjJ7dcL


https://docs.google.com/leaf?id=0BwLfsq9Sg7EbNzE5NGEwMzItMGQ3Zi00ZWNmLTkzYzctMWIxNjRkOTEzN2E2&hl=en_GB&authkey=CMOUuOIJ

Emails!

Did you get my emails this time??

Megan no emails

email is toftscot@hotmail.com and yes i have marked the unit8 some small changes to clarify marks but no emails form you have been looking for them but no arrival


 jake

Marking

Hello!

Are you getting my emails?? Have marked some of my coursework yet??
How is it going?

data for exam 27th april

7.1 The spreadsheet data model and practice data for the examination will be released on Thursday 7^{th April 2011. This will be available from the Edexcel Website (www.edexcel.com/quals/gce/app-gce/app-ict/Pages/default.aspx ). You will need to ensure that you have your Edexcel Online password to access these files.}

7.2 The secure examination data files and the examination version of the spreadsheet model will be released on Wednesday 27th April 2011. This will be available from the Edexcel Website (www.edexcel.com/quals/gce/app-gce/app-ict/Pages/default.aspx ). You will need to ensure that you have your Edexcel Online password to access these files.

make note

Instructions for Labelling

2.26 Candidates MUST enter their details ON ALL TASKS BEFORE PRINTING as specified in the examination paper. Handwritten details are not acceptable.

6

Please note: It is not acceptable to pre-print each page with the candidate details and then overprint the appropriate task.

Printing

2.27 Printers should be in the same room as the candidates. If this is not the case another responsible person must be assigned to deliver printouts to the candidate. Candidates may

2.28 It is the responsibility of the centre to ensure correct ownership of each printout.

2.29 There is no requirement to print in colour. No extra credit is given to work printed in colour. However, adequate differentiation is needed on monochrome printouts (e.g. sectors of a pie chart are distinguishable).

2.30 If printouts are on continuous stationery, the pages must be separated and sprocket holes removed.

2.31 In the event of a printer breakdown, the centre may use its discretion on extending the time limit. Wherever possible, alternative printing facilities should be available during the examination.

2.32 It is the invigilator’s responsibility to ensure that these regulations are adhered to.

not collect printouts from another room, nor must the invigilator become involved in the collection of printouts from another room.

After the Examinations

2.33 Centres must ensure that all the candidates work is saved and secure from unauthorised access. Centres should safeguard this work in case it needs to be reprinted. After the examination the candidates work should be copied to a storage medium and kept secure by the examinations officer.

2.34 Final printouts should be collated, parcelled up and stored securely until the final examination session has been held and then sent to the designated examiner.

2.35 All other examination material, including draft copies of candidates’ work, additional printouts and question papers, must be collected by the invigilator at the end of each session and stored in a secure place. These should not be sent to the examiner.

2.36 There should be no common user areas accessible to candidates during the examination.

2.37 Candidates’ examination user areas should be removed at the end of the examination window or after each session if feasible. Centres must ensure that the user areas of those candidates who have already sat the examination cannot be accessed by candidates who are sitting the examination in a later session. Different passwords must be setup for each session.

7
2.38 In the case of multi-session examinations (6957 & 6959) the centres must ensure that the candidate does not have access to their examination user area outside the official session times.

look at this thread

http://www.thestudentroom.co.uk/showthread.php?t=1600787

scan 1-5

link5

link4

Link3

Link2

Link 1

Unit 7 Scenario

Unit 7 scenario

timetable for Unit 7

EXAMINATION SCHEDULE PRO FORMA

GCE APPLIED ICT

Unit 7 Using Database Software

EXAMINATION SCHEDULE

MONDAY 23^rd MAY 2011 – FRIDAY 17^th June 2011

Centre No	22106
Centre Name
Centre Address
Post Code
Date	Year Group	Start time	End time	Room	Total number of candidates
24th may	13	10.00 am	11.00am	Ch4	1
31st may	13	9.00am	11.00am	Ch4	1
2nd June	13	9.00am	11.00am	CH4	1
7th June	13	9.00am	11.00am	CH4	1
9Th June	13	9.00 am	11.00am	CH4	1
10th June	13	10.00 am	11.00 am	CH4	1

---

Hello!

Can you send me your email address so I can send you the updates? Sorry I haven't sent it before but I didn't know where to send it.

http://library.creativecow.net/articles/ross_tony/MC_rollover.php

http://library.creativecow.net/articles/ross_tony/MC_rollover.php

pull down

http://www.fg-a.com/pulldownmenu.shtml

marking grid unit 8

Assessment criteria – Unit 8:– strand a)
Mark Band 1 Mark Band 2 Mark Band 3 Mark awarded
An outline project proposal that:
• provides some information, but not
sufficient on its own for senior
management to make an informed
decision
• shows limited awareness of audience
and purpose
Plus, a project definition document that
defines the scope of the project
An well-researched, detailed project
proposal that:
• provides sufficient information for
senior management to make an
informed decision
• considers the impact of the proposal
on others
• is clearly communicated,
demonstrating sound awareness of
audience and purpose.
Plus, a project definition document that
fully defines the scope of the project
A well-researched, comprehensive project
proposal that:
• provides all the information need for
senior management to make an
informed decision
• carefully considers the impact of the
proposal on others
• is well-argued and clearly
communicated, demonstrating sound
awareness of audience and purpose
Plus, a project definition document that
fully defines the scope of the project and
identifies clear and measurable
objectives.
(0 — 3) (4 — 5) (6) 5

project2pdf

project 2 pdf

sales by sum

Calculating Totals in Access Queries An often-overlooked feature of the ordinary select query is its ability to calculate totals. Whilst the crosstab query is useful for analysing complex data, it needs several fields to work with. Supposing the data you wish to analyse is contained in just two fields? The answer is to create a select query and make use of the totals option. Totals can do more than just add up too! Here's how it works… We have a table containing a mass of sales data. The records are arranged in no particular order, and there are several fields containing information about each individual sale… If we wanted, we could do a sophisticated analysis of this data with a crosstab query, but to begin with all we want to know is "What are the total sales for each person?" All the data we need is contained in just two fields, Salesperson and Sales, and a crosstab query needs at least three fields to work with. No problem! We're going to use Totals. Adding Totals to a Query The first step is to create a query selecting the fields we are interested in. Running the query at this stage simply presents with a list of data. In this case Salespeople and numbers representing individual Sales.  But we need to analyse this data… In the design view of the query we activate the totals option. To do this either click the Totals button on the toolbar, or choose View > Totals from the menu, or right-click anywhere in the QBE grid and choose Totals from the shortcut menu.   Activating the Totals option creates another row in the QBE grid, the Total: row. The default setting for the Total option for each field is Group By, but to make sense out of this data we must change one of these and select a type of calculation. In this example we want to calculate the sum of Sales for each Salesperson Clicking in the Total cell of the Sales column, then clicking the down-arrow that appears, reveals a list of choices. Sum is the one we need here, but you can see that several useful calculations can be chosen, mathematical and statistical. Click the appropriate option to select it and run the query. The result of the query shows a total sales figure for each salesperson. The Salesperson field is automatically sorted into alphabetical order so there's no need to choose a sort option in query design. If you wish you can override the A-Z sort order and choose Descending if you want the results sorted the opposite way. ^ top Refining the Query You can still add criteria to the query definition if you wish. Here, criteria have been added to the Salesperson field to select records for specific salespeople… Grouping by Several Fields You can group my as many fields as you wish, providing the chosen fields contain suitable data. Here, the data has been grouped additionally by region. Again the data is sorted automatically… ^ top Using Additional Criteria It may be that you want to specify certain criteria referring to another field, but you don't want to group by that field or calculate its data. To do this, select the Where option in the Totals row. This lets you add criteria to the criteria row of that field to further refine your query. When you do this Access unchecks the Show box for that field. If you want to see the new field in the result of your query, you must add to the QBE grid a second time (with Grouped By selected in its Totals row). Construct the query like this… The Region field has been added to the QBE grid twice, first using the Where option to specify criteria, and again using Group By to let the result be shown. Here's the result. The data has been grouped by Salesperson and Sales subtotalled (summed) for the North region only. Note: Because what you see when you run your query using Totals is a summary of your data, it doesn't behave like a normal dynaset. Changes made to the data here are not reflected in the original data.
	^ top

sort by date --- use data type

the date in access is a data type


Date   Data type   Date/time   in design view

dates in access

Working with Dates

Dates behave the same way as numbers, so you can use some of the same techniques when constructing your date query or filter. Remember, for dates to be treated properly by Access it is important that your field type has been correctly defined as a Date/Time field. It doesn't matter how you enter the date, as long as you use a recognised format. The date will be displayed in the resulting dynaset in whatever format you chose when you created the table.
When you enter a date in the criteria cell you can use any standard date format, but each date must be enclosed by hash marks (#).
For example:

• <#1/1/98# finds dates earlier than 1 January 1998 
• =#27-Sep-50# finds dates equal to 27 September 1950 
• Between #5/7/98# And #10/7/98# finds dates no earlier than 5 July 1998 and no later than 10 July 1998

Here are some more examples…
=#Date#
To match a particular date type the date enclosed by hash marks (#). This example will display all the records with entries for 27 September 1998 in the Invoice Date field.


=Date()
To match today's date type the expression shown. Date() means "today". This example will display all the records with entries for the current date in the Invoice Date field.


Year([Fieldname])=Year(Now())
To match the current year type the expression shown, entering the name of the current field in square brackets where indicated. This example will display all the records with entries for the current year in the Invoice Date field.

Year([Fieldname])=Year
To match a particular year type the expression shown, entering the name of the current field in square brackets where indicated and the required year in place of Year. This example will display all the records with a date in 1998 in the Invoice Date field.

<Date()-30
To match a particular calculated date range you will need to use a combination of expressions. This expression employs a calculation that subtracts 30 from the current date and also includes the less than operator. This example will display all the records with a date more than 30 days old in the Invoice Date field.

spec unit 7

Unit 7: Using Database Software
A2 compulsory unit
Externally assessed
Introduction
In Unit 2, you used database software to organise and interrogate
structured information and produce reports. You saw how large
organisations rely on databases to manage their information and provide
them with fast and flexible access to it. You looked at examples of
transactional websites which use databases to store product, customer and
sales information and learned at first hand how database queries can be
used to analyse information and identify trends.
In this unit you will develop your knowledge of, and skills in using,
databases further. You will learn the principles of data modelling and
sound database design, and will use relational database software to build
working database systems capable of storing large quantities of data and of
handling both routine and one-off requests for information.
In all likelihood, people other than yourself will want to use some — if not
all — of the databases you create. With this in mind, you will design and
implement user interfaces that make it easier for people to enter data and
extract information, whilst ensuring the overall security and integrity of
the database.
You will make full use of the facilities of the software to produce reports
that are well presented, easy-to-read and fit for purpose. Your work for
this unit will culminate in the design, development and testing of a
database for a specific purpose.
This is an externally assessed unit. Details of the assessment are given on
page 119.
This is a user-focused unit. The knowledge and skills developed in this unit
are particularly relevant to those who use advanced ICT skills on a daily
basis at work or at school/college for personal, social and work-related
purposes.
Recommended prior learning
This unit builds on the database knowledge and skills you acquired in
Unit 2: The Digital Economy.
UA015271 – Specification – Edexcel AS/A GCE in Applied ICT (Single and Double Awards) – Issue 1 – February 2005
113
What you need to learn
7.1
Database
applications
In Unit 2, you looked at the role that databases play in the day-to-day
operation of transactional websites. You will find it useful to begin your
work for this unit by exploring other database applications in areas such as
commerce, education and manufacturing.
You should pay particular attention to design issues such as:
• the database structure
• the user interface
• measures used to protect the quality of the data
• types and forms of output
• the methods used to extract information.
You will be able to put much of what you learn to good use when you start
to design and implement relational databases of your own.
7.2
Functional
specification
As you will have realised by now, databases are too complex and usually
too important to the business for their creation to be left to chance. They
need to be systematically designed, built and tested.
As with all software development, the first step in the process is to
produce a functional specification identifying the requirements of the
database — what exactly it needs to do — including:
• the task(s) the database must perform
• the information it must supply, in what format, to whom
• the data to be input into the database, how and from where
• the processing that is required
• the level of security needed.
Having a clearly defined functional specification will help to keep you on
track once you start building the database. By checking what you have
achieved against the functional specification from time-to-time you can
measure progress and make sure you do not lose sight of your goal.
7.3
Database
development
Once you are clear about the functional requirements, you can begin work
on the design of the database.
The first thing to do is to analyse the data requirements of the system and
produce a data model.
The next step is to translate the data model into a physical database
structure using your chosen database software.
You must be able to convert data models into physical database structures
and test that they work correctly, before beginning work on other aspects
of the system, including:
• • queries
• reports
•
114
data entry and validation functions
menus.
UA015271 – Specification – Edexcel AS/A GCE in Applied ICT (Single and Double Awards) – Issue 1 – February 2005
7.4
Data modelling
You are already familiar with the concept of a model. In Unit 3, you used
spreadsheet models to represent real-life processes and situations. In this
unit you will learn a technique known as entity-relationship modelling to
represent the data in a given scenario.
Entity-relationship models (ER models) have three components:
• entities
• attributes
• relationships.
You will learn what each of these terms means and will practise
constructing ER models showing the entities, their attributes and the
relationships between them for a given scenario.
You will learn how to determine the degree of a relationship and to take
steps to resolve many-to-many relationships.
Normalisation is a process for removing unnecessary duplicated data and
maximising the efficiency of a database. You will learn how to normalise
an initial data model to third normal form.
7.5
Creating a
relational
database
structure
You will learn how to use database software to build physical
representations of data models, in which entities are represented as tables
and attributes as fields.
You must be able to choose suitable data types and formats for fields,
including:
• text, eg limited length, unlimited length, memo
• number, eg integer, auto record number, floating point
• Boolean, eg true and false, Y and N
• date, eg dd/mm/yy, dd month
• time, eg 24-hr clock, hh/mm/ss
• currency, eg pound (£), dollar ($).
You should also know how to store sounds, pictures and other forms of
non-textual data.
You must understand how these data types are actually stored and how the
database software converts them to the format required.
It is important that you are aware of the limitations of particular number
formats and choose the most appropriate.
You will learn how to index a field or group of fields in order to speed up
data retrieval and when it is appropriate to do so.
You will use the primary/foreign key mechanism to create relationships
between tables and learn how to make relationships compulsory by
enforcing referential integrity.
UA015271 – Specification – Edexcel AS/A GCE in Applied ICT (Single and Double Awards) – Issue 1 – February 2005
115
7.6
Validation
techniques
The ‘garbage in, garbage out’ rule is particularly relevant to databases.
You must make every effort to stop incorrect data from getting into a
database.
You will learn a number of techniques for validating data, including
building in checks, such as:
• • file lookup check
• list check
• format (picture) check
•
The user
interface
range check
•
7.7
presence check
length of data check.
You will learn how to design and implement user-friendly interfaces to
help people enter data into your databases and extract information from
them.
You must be able to produce screen input forms with facilities, such as:
• input masks
• drop-down lists
• option buttons
• command buttons.
You must incorporate help for users by means of:
• instructions
• help screens
• easy to understand error messages.
You will learn how to minimise the potential for invalid data input by
incorporating validation checks into forms.
You also need to think about how information from your databases will be
selected and displayed. You should know how to create menus and
searches to make it easier for people to use a database and to control how
much or how little users are allowed to see and do.
You will use the presentation and formatting features of the software to
produce reports on screen and on paper that turn database output into
meaningful information, using titles, layout, etc. Where appropriate, you
will incorporate calculations such as totals and running sums into reports.
7.8
Testing
You will learn to test any databases you create to make sure that they
work correctly. You should carry out checks to ensure that:
• • all menus work properly
• validation checks prevent unacceptable data from being entered
• the database can cope with normal, extreme and abnormal data
• output from the database is complete, accurate and in the required
   format
•
116
the solution meets all the requirements of the functional specification
other people can use it without help.
UA015271 – Specification – Edexcel AS/A GCE in Applied ICT (Single and Double Awards) – Issue 1 – February 2005
It is important to involve others in the testing/evaluation process and to
act upon the feedback they provide. You will learn how to use database
prototypes at various stages during development to gather feedback on
particular aspects of the design, such as ease of use and appropriateness of
output.
7.9
ICT skills
In order to produce relational databases you must be able to use database
software to carry out tasks, including:
• constructing tables to represent entities
• defining the fields in each table to represent attributes
• defining appropriate data types and formats
• defining primary keys
• creating relationships between tables
• defining searches and sorts (single and multiple fields and tables)
• using relational logic in searches
• importing data from and exporting data to other databases and
   applications
• using macros to automate common tasks
• using wizards effectively
• creating screen data-entry forms that
− − have appropriate entry-form field lengths
− provide clear labelling of entry-form fields
− provide instruction fields where necessary
− include validation checks on field entries as appropriate
− enable the selection and entry of data from built-in lists
   (constructed from other tables)
− include calculation (formula) fields
− make use of automated number fields (counter fields)
−
•
enable the entry of data into single and multiple tables
use date and time fields
creating database reports that
− have suitable headers and footers
− have an appropriate format and layout
− have sorted data grouping
− include calculations and total fields
− include specified queries.
UA015271 – Specification – Edexcel AS/A GCE in Applied ICT (Single and Double Awards) – Issue 1 – February 2005
117
Standard ways
of working
• Whilst working on this unit, you will be expected to use ICT efficiently,
   legally and safely. You must adhere to standard ways of working,
  including:
•
7.10
file management
− − using sensible filenames
− setting up directory/folder structures to organise files
− making backups
− choosing appropriate file formats
− limiting access to confidential or sensitive files
− using effective virus protection
−
•
saving work regularly
using ‘readme’ files where appropriate to provide technical
   information, eg system requirements
personal effectiveness
− − customising settings
− creating and using shortcuts
− using available sources of help
−
•
selecting appropriate ICT tools and techniques
using a plan to help you organise your work and meet deadlines
quality assurance
− − proofreading
− seeking views of others
−
•
using spell check, grammar check and print preview
authenticating work
legislation and codes of practice
− − respecting copyright
− avoiding plagiarism
−
•
acknowledging sources
protecting confidentiality
safe working
− − ensuring that lighting is appropriate
− taking regular breaks
−
118
ensuring that hardware, cables, seating etc are positioned
correctly
handling and storing media correctly
UA015271 – Specification – Edexcel AS/A GCE in Applied ICT (Single and Double Awards) – Issue 1 – February 2005
•
eportfolio
− creating an appropriate structure for an eportfolio
− collecting together all the required information, converting files to
   an appropriate format if necessary
− authenticating your work
− providing a table of contents, using hyperlinks to locate
   information easily
− testing for size, compatibility and ease of use, making sure that
   the eportfolio conforms to the technical specification.
Assessment — Unit 7: Using Database Software
This unit is externally assessed.
Working under supervision, you will be required to design, implement and
test a relational database system to meet a given set of functional
requirements. Some of the data to be stored in the database will be
supplied to you as a comma separated values (csv) file.
You will have 10 hours in which to complete this work.
During the production of your database system, you should actively seek
and respond to feedback from others. However, the final database solution
must be entirely your own work.
Only fully functional relational database software capable of supporting
one-to-many relationships should be used for this unit. An up-to-date list
of acceptable software will be maintained on the Edexcel website.
At the end of the designated examination period, you will transfer your
work to a location specified by your teacher. Your work must be submitted
in one of the formats specified on the front of the examination paper.
Delivering this unit
General information
Assessment requirements
This is an externally assessed unit. Instructions for the conduct of the
examination will be published on the Edexcel website in advance of each
examination series.
Vocational context
This unit has a user focus. It is important that learners acquire some
experience of live, large-scale database systems: the sheer volume of data
they handle, the different views of the data they provide and the way in
which data is imported from and exported to other software applications.
Standard ways of working
Learners must work safely and adhere to relevant legislation and codes of
practice when carrying out the externally-set practical computer-based
activities required for this unit. Marks will be awarded for evidence of
adherence to relevant standard ways of working.
UA015271 – Specification – Edexcel AS/A GCE in Applied ICT (Single and Double Awards) – Issue 1 – February 2005
119
Teaching and learning strategies
Learners should be reminded of the work they did at AS level in Unit 2:
The Digital Economy and may find it useful to revisit the database
concepts introduced there before beginning to create database structures
of their own.
Learners should be encouraged to follow a structured systems development
process, involving investigation and analysis of the problem, design and
implementation of the solution. They should be instructed in data
modelling using entity relationship diagrams and normalisation and they
should be given opportunities to practise the techniques they have learnt.
Learners need to develop skills in the chosen database management
software and be familiar with the development tools supplied with this
software. They should be able to create related tables, interactive forms,
complex searches of their database (including linked tables, parameter
searches, calculated fields, multi-field searches, range searches and
totals), sophisticated reports and macros. There is no expectation that
learners will need to supply programmed solutions.
Learners need to understand the importance of testing a system and
choosing appropriate test data to ensure their system works.
Learners need to have practised developing parts of a system and simple
systems prior to the exam.
Links
This unit builds on the database work undertaken in Unit 2: The Digital
Economy. The concept of a model introduced in Unit 3: The Knowledge
Worker is a useful foundation for the work on data modelling that learners
undertake in this unit.
Other units
Learners taking the Double Award may wish to study Unit 12: Customising
Applications in conjunction with this unit.
Learners taking Unit 14: Web Management will benefit from having already
completed this unit, since they need to understand how and why database
integration has become a key feature of most websites.
Assessors may want to use this unit as a vehicle for introducing some of the
project management techniques covered in Unit 8: Managing ICT Projects.
National Occupational
Standards (NOS) for IT
Users, e-skills UK,
November 2003
The IT knowledge and skills covered in this unit map to NOS for Using IT,
Areas of Competence:
Make selective use of IT
• Operate a computer
• IT trouble-shooting for users
• IT security for users
•
120
• Database software.
UA015271 – Specification – Edexcel AS/A GCE in Applied ICT (Single and Double Awards) – Issue 1 – February 2005
The standards specify what users of IT working at Levels 1–3 are expected
to know and understand and be able to do. They include examples of tasks
that users operating at a specific level might be expected to perform. The
ICT skills listed in What you need to learn section 7.8, and some of the
standard ways of working listed in What you need to learn section 7.9,
cover aspects of several NOS Areas of Competence (AOCs), but focus in
particular on use of database software. Teachers should refer to the
standards for further information about what is expected of learners using
databases at Level 3.
Resources
Equipment
Learners will need access to:
•
desktop/laptop computers ideally with the following minimum
specification (based on the Becta workstation specification 2/10/03):
− 256MB memory
− 1.7Ghz Intel processor or equivalent
− 40GB hard drive
− video card with 32MB memory
− CD/DVD
− some form of rewritable media
− UK keyboard and pointing device
− colour, high resolution monitor, capable of supporting 1024x768
• printing facilities
• sufficient individual storage space
• internet access (broadband)
• Windows XP operating system or equivalent
• software:
−
Books
relational database software, eg Microsoft Access, Lotus Approach
Heathcote P M — Successful ICT Projects in Access (Payne-Gallway
Publishers Limited, 2002) ISBN 0953249069
Warrender R L — Databases (Crucial, 2003) ISBN 1903337089

UNIT 7 - information

Is there any advice on how we should prepare students for the 10-hour supervised working time?
Please refer to the ICE document on the GCE Applied ICT page.

 
How do we notify Edexcel of our schedule within the window for candidates sitting the exam?

Centres must produce a schedule showing the date and time of each examination session to be held within the window. An examination schedule pro forma for this can be found in the ICE document. This schedule must be submitted in writing to the Compliance and Business Assurance Group at Edexcel, 190 High Holborn, London WC1V 7BH at least three working weeks before the window begins.


The Unit 7 SAMs have three csv files that are then split into five tables in the database in the worked example. The only way that I can think to do this is to import the bookings table into Excel, then split the data up into the four tables (booking, car, session, driver). This is very time-consuming. Is there a more efficient method? I cannot get the table analyser in Access to perform this task.
 
1. Import them as temporary tables into Access
2. Use append queries to load the relevant data into the tables.

 
In the 'Instructions for the Conduct of Examinations' (ICE) for Unit 7 - Using database software, it states that candidates are allowed manufacturer's computer manuals. Can these be any Access-specific manuals?

Yes - the idea is that if they do not know how to do something, they can look it up.


We have been working through the database on last year’s exam (as provided online). The design is fine, and we have built the tables and imported the data. Where we are stuck is how to get the database to find the 'rejected records.' Our input masks/ validation rules work when we are manually entering data, but will not eliminate records when we are appending from the main tables into the new tables.

Input masks only work on the input of data and are therefore not classed as a form of validation. To do a format check in Access, the ‘Like’ function has to be used in the validation rule - for example, Like [A-Z][A-Z]### will require two characters followed by three numbers.
That input masks do not work on import is a Microsoft decision. When the SAMs were originally written, input masks did appear to work on import. Because they no longer do, the way we test validation has changed slightly, and the exams will require test data to be input.
Validation rules should work on import, and if they do not then there is something wrong with the version of Access being used.

 
In the ICE document, it says that there should be a 10:1 student-to-printer ratio. Is this recommended or mandatory?
The 10:1 ratio is a recommendation as to how many candidates would be appropriate for each printer. Having fewer candidates is not a problem. However, having more could slow down the exam and cause queues at the printer.

 
The length of session for the 6957 exam is ten hours. The ICE document says a minimum of one hour is required per session. Can these be 50-minute sessions, or must it be one hour? Our lessons are 50 minutes long.

A minimum of one hour is recommended to give candidates sufficient time to complete the task. Just keep a record of how long you spend overall, and be sure that each candidate has no less than 10 hours in total time for the exam.

flash

flash video

removing links

 link


http://office.microsoft.com/en-us/project-help/remove-a-task-link-HP045304020.aspx

Protecting access db

protecting your access DB

Unit 7 Deadline

Unit 7 - Using Database Software

6957

23 May 2011 (Start of four-week window)

proposal agreement

link to proposal agreement

Summing in reports 

and link2

link adding totals to access

Hello!

Old School Deadlines etc..

http://www.ncbisonline.org/course/view.php?id=244

link

link to requirements

edexcel

requirements

Access video

Microsoft Access 2007 Tutorial - How to use File Attachment Controls

How to display Calculated Values in Microsoft Access Forms or Reports

Microsoft Access 2007 Anchoring Fields so they stretch to the changing size of a form or report

Microsoft Access 2007 Tutorial - Data Collection By Email

Microsoft Access 2007 Tutorial - Outlook Task to Scheduled Reoccurring Access Imports or Exports

Microsoft Access 2007 Tutorial - How to show Date Picker

Microsoft Access 2007 Tutorial - Alternating Row Color in Reports and Datasheet Views

Microsoft Access 2007 Video Tutorial -Queries Part One - Simple query formulas combining field values, arithmetic on field values, creating alias field names, and use of NZ function

Microsoft Access 2007 Video Tutorial - Queries Part Two - Query Table Joins

Microsoft Access 2007 Video Tutorial - Queries Part Three - Query Criteria Methods and use of Like Operator and Wildcard

Microsoft Access 2007 Video Tutorial - Queries Part Four - Action Queries - Make Table Query, Update Query, Append Query, Delete Query

Microsoft Access 2007 Video Tutorial - Queries Part Five - Using Aggregate Functions in Group By Queries

microsoft project

http://www.downloadnow.net/search_files.html?url=aHR0cDovL3JhcGlkc2hhcmUuY29tL2ZpbGVzLzE4ODAzNDY4NC9Qb3J0YWJsZV9NTzdfRW50ZXJwcmlzZS5wYXJ0MDEucmFy&name=UG9ydGFibGVfTU83X0VudGVycHJpc2U%3D

flash video link

http://www.youtube.com/watch?v=3e2uUZSyezA&feature=relmfu

Flash tutorials

start

edexcel applied ICT