Successful ICT Projects In Access (3rd Edition): (GCE ICT)

The practical resource of choice for creating projects using Micrososft Access

Table of Contents:
Chapter 1 - Designing a Database Introduction Entity - relationship diagrams Attributes and key fields Normalisation A sample database Identifying the entities, attributes and relationships Table design Elements of an Access database Naming conventions Designing the Input and Output Chapter 2 - Creating Tables and Relationships Loading Access Creating a new database The Database window Creating a new table Defining the primary key Entering other fields (attributes) Saving the table structure Editing a table structure Inserting a field Deleting a field Moving a field Changing or removing a key field Entering data in Datasheet view Creating the NEWSPAPER table Creating the DELIVERY table Using the Lookup wizard Defining relationships Entering data in Datasheet view Customising a table view Chapter 3 - Creating Data Entry Forms Introduction Creating a columnar AutoForm Changing the appearance of the form Adding a form heading and arranging fields Arranging and sizing fields Changing a form's background Changing the sort order of records Creating a form with a subform Adjusting the size of the form and subform Using the form to enter and edit data Deleting a field from the subform Finding a record Deleting a record Chapter 4 - Queries Understanding queries Types of query Setting special criteria AND and OR queries Allowing the end - user to enter criteria Saving a query with a different name Using the Simple Query Wizard Creating calculated fields with a query Moving columns Changing a column caption Creating a form from a query Chapter 5 - Advanced Queries Introduction Creating a totals query Creating an update query Using queries to process customer payments Summary query Creating and running a Make - Table query Updating one table from another Making a copy of a table structure Creating and running an Append query Creating and running a Delete query Chapter 6 - Reports and Charts Introduction Creating a columnar AutoReport Creating a tabular AutoReport Editing the report format Adding a new field to the report Formatting the report Basing a report on a query Customising the report Sorting and grouping the report Inserting a page break between rounds Chapter 7 - Macros and Command Buttons Macros Creating a macro group Running a macro which is part of a group Command buttons Defining a button's event property Setting the properties of the form Using conditions in a macro Dialogue boxes Creating an unbound form Creating the macros to open and use the dialogue box Attaching the macros to command buttons Using a field from a dialogue box as query criteria Inserting a field from a dialogue box in a report List of macro actions in Access Chapter 8 - Advanced Form Design Introduction Selecting objects Moving objects Aligning and spacing objects evenly Resizing an area of the form Changing a heading or label style Rearranging and resizing fields Inserting an option group Changing the tab order Using the Properties sheet to customise controls Changing a form's record source Combo boxes and list boxes Using a combo box to find a record Inserting a picture on a form Adding a box to the form Keeping the Find Newspaper box synchronised Creating a form from a query Design considerations Using a combo box to look up a record from another table Chapter 9 - Rounding off an Application Introduction The menu structure for the Newsagents database Creating a switchboard Creating the submenus Viewing the main switchboard Creating the main menu (switchboard) Testing the switchboard Editing a switchboard item Customising a switchboard form Setting Startup options Security Chapter 10 - Linking with Word and Excel Mail merging using data held in Access Importing data from Excel Importing records into Access Appending imported records to an existing table Analysing data in Excel Exporting data Chapter 11 - An Introducti