Microsoft Access 2007 Beginning Topics.doc

Microsoft Access 2007: Beginning Topics Course Outline Guide 1. Microsoft Access 2007 – Overview 1 2. Creating and Saving databases 2 3. The new Office 2007 interface 3 4. Views 4 5. Create a field 4 6. General field properties 5 7. Lookup wizard 7 8. Format, default value, and more input mask 8 9. Validation rule 10 10. Lookup wizard challenge 11 11. Yes/No data type 12 12. Fields with numeric value 12 13. Create records 13 14. Sorting records 14 15. Create a backup 14 16. Open floor for QA 15 17. Next week - Access II – Intermediate Topics 15 Microsoft Access 2007 – Overview What is it? Access 2007 is the latest and greatest database development application from Microsoft. It is one of the many software programs that make up MS Office 2007 which is available only for the Windows PC operating system. It is used for creating basic letters to more complex documents like newsletters, manuals, forms, and now blogs Previous versions: Windows PC: Office 2003 – is compatible with 2007 if the updated compatibility package is downloaded and installed /en-us/products/HA101686761033.aspx Apple Mac: there is no previous version of Access for the Mac It is recommended that during the installation of Office 2007 you also uninstall your older version(s) of Office. Although you can have multiple versions installed at the same time you will encounter problems. The most noteworthy issue is trying to open two versions of one program. For instance, if you open both Word 2003 and Word 2007, then restart your computer you will find that Word will not open right away. In fact, your computer will need to reinstall upon trying to open Word 2003 or Word 2007 taking a considerable amount of time Creating and Saving databases What is this? A database can be as basic as a contact list or as complex as an entire organization’s infrastructure and operations When opening Access 2007 it automatically prompts you to choose how you want to start Creating New Blank Database A way to start from sc