ads1

Training


Table

Tables are the backbone of your database. Each table contains information about a specific subject. For example, a supplier table might store supplier names, Birthdate, and telephone numbers.

Query

Are the means of manipulating the data to display in a form or a report. Queries can sort, calculate, group, filter, join tables, update data, delete data, etc.

Forms


These are screens for displaying data from and inputting data into your tables ,relating to Microsoft Access Graphical User Interface Form designs; from adding customised database error messages, including images in your database forms, creating Microsoft Access database start-up screens

Report

Anything you plan to print deserves a report, whether it is a list of names and addresses, a financial summary for a period, or a set of mailing labels.Reports are the results of the manipulation of the data you have entered into the database.they cannot be edited.

Macro

Macros are very useful for automating simple tasks, such as carrying out an action when the user clicks a command button.Macros can open forms; run queries, change values of a field, run other Macros, etc.

No comments:

Post a Comment