1 / 17

Microsoft Access Course

Learn about table design, query design, forms design, and report design in Microsoft Access. Understand key button sets, primary keys, field sizing, and validation rules. Explore form anatomy, object properties, and form controls.

adelaidet
Download Presentation

Microsoft Access Course

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Access Course 2. Basic techniques

  2. Topic Summary more on . . . • Table Design • Query Design • Forms Design • Report Design

  3. Key button sets Primary key Table Design Key symbol indicates Primary key Field Size provides additional sizing info Caption value is used to label the column when shown on a form Validation is condition that new data must obey.Text is error message Indexed parameter specifies indexing on column: Yes, (duplicates OK) No, Yes (no duplicates)

  4. Query Example Result

  5. Group by Query Example Shows definition of alias value Sigma button gives Extra ‘Total’ Line

  6. Form Design 1 • Form Design is the most complex aspect of database development • A form can be based on a table or query and is said to be bound to the table/query. • Text boxes on the form show column data in the underlying table/query. Changes to the data in the boxes causes the underlying data to be changed. • A form may also be unbound i.e. it does not show any table/query data. Used for special applications such as menus. • The form may also use a number of other ‘controls’ – labels, buttons, list boxes, combo boxes, sub-forms etc

  7. Anatomy of a form 1 Form can have 3 sections as shown. The Header and Footer are optional. The Header usually contains simple identification labels The Details section holds the data boxes and labelling etc When built using a Wizard the labels contain the column names. The Footer section usually contains various buttons for exiting, saving etc

  8. Anatomy of a form 2 This box is the ‘form select box’. Clicking it causes the form to be selected. The textbox and the label are ‘tied’ together – both can be moved as one unit. Shows the label selected Shows the textbox selected

  9. Object Properties • The form, form sections and form controls are all viewed as ‘objects’ with properties • The properties affect the appearance and behaviour of the object • The properties also include ‘event handlers’ – i.e. specification of action to be taken when certain events occur: eg. a button is pressed, a textbox value is changed. • The ‘property box’ shows the properties for the selected object. It can be opened from the right mouse button

  10. Object Properties 1 Showing part of the property list for the AssetId textbox Tabs select available groups of properties Position properties Size properties Font properties

  11. Object Properties 2 Associated with each event such as Before Update will be a procedure defined as a macro or VBA module. Showing event properties for the AssetId textbox.

  12. Adding controls to a form – the Toolbox Most commonly used controls Wizard toggle. When this is depressed, a wizard will start when certain controlsare placed on form Drawing cursor Textbox Label Radio button Check box Combo box List box Command button Image To use toolbox, click on tool. Cursor adopts tool icon. Pointing on form at target position, drag to give required size.

  13. Summary of Form Controls Textbox – container that hold a variable data value or shows the content of a table/query value. Label – container that holds a constant value. Button – metaphor for a pressable button, used to activate a command - ie. macro or VBA code. List Box– static list of selectable options. Can be preset values or obtained from table/query. Combo Box – drop down list combining List box and textbox. Check Box – specifies a settable option. Radio button – specifies one of a set of exclusive options. Image – holds a graphical image.

  14. Report Generator • The Accessreport wizard can automatically produce complex reports based on multiple tables and showing levels of summarisation. • Necessary joins are resolved automatically and incorporated into the report design. • It is sensible to use the wizard to generate the initial report but the layout will generally need further fine tuning.

  15. Basic Report Example

  16. Summary Report Example This is an example of a summarised report using the Asset and Branch tables. It effectively groups by Branch code/name and totals the value of assets within the branch. It was created initially using the wizard then modified. The design for this report is shown on the next slide.

  17. Report Example Show the design for the Asset/Branch report. Note pairing of headers and footers. Compare with the structure of the output.

More Related