Database Development
- A database is a collection of data
- A data dictionary is a description of every field in a database
- The components that make up a database are queries, reports, forms and tables
- The inputs of a database system are file, record, field and character
- There are 5 data types including: Text, Number, Yes/No, Currency and Date
- Databases save automatically
- Examples of a primary source of data includes interviews, surveys and census
- Examples of a secondary source of data includes books, statistics and newspapers
- Information should be accurate, verifiable, timely, organised, accessible, useful and cost effective
- The components that are stored when you save your data are records, designs, tables, dictionaries, reports and forms
- Validation is checking of errors
- Verification is checking the accuracy
- = symbol is used to start a mathematical calculation
- Macros perform repetitive tasks
- Editing is the process of changing data, like inserting, deleting and moving data
- Sorting is arranging data, for example ascending, descending and alphabetical
- Searching is the process of locating data and information. You can search in the find or search commands
- Report are not interactive, they include a Header, Body/Text and Footer
- In layout view you can pick themes, change fonts, colours and size
- Forms are a way of presenting data from individual records and they can be edited and new data can be entered
- Data can be exchanged between databases and spread sheets
- Data can be exchanged, imported and exported
- 3 stages of importing a graphic into a database include: Select, open and locate
- Data can be exported to spread sheets, word processed documents and webpages
This is a great entry, there is heaps of information and it has a good resource.
ReplyDelete