What is Microsoft Access?
Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.
Characteristics of Microsoft Access
* Tables They store data in a row and column format similar to spreadsheets.
* Quarries They enables you to view data from a table.
* Relationships Relationships are the bonds you build between the tables. They join tables that have associated elements.
* Forms They enables you to enter,View and modify in a table.
* Reports They enables you to generate reports based on tables and query results.
* Data Access Page They are web pages to view data from the internet where the data is stored in an Access database.
* Macros They are a series of commands and functions that can be executed whenever a task is need to perform.
* Modules They are a set visual basic procedures and declarations stored as one units.
Features of MS Access
1. Share database on the web
2. New macro Builder
3. New database Templates
4. Improve Datasheet view
5. The Improved Ribbon
6. Backstage View
7. Navigation pane
8. More Powerful object creation tool
Microsoft Access – Opening databases Shortcuts
(i) Ctrl + N = Open a new database.
(ii) Ctrl + O = Open an existing database.
Microsoft Access – Printing and saving Shortcuts
(i) CTRL+P = Print the current or selected object.
(ii) P or CTRL+P = Open the Print dialog box from Print Preview.
(iii) S = Open the Page Setup dialog box from Print Preview.
(iv) C or ESC = Cancel Print Preview or Layout Preview.
(v) CTRL+S or SHIFT+F12 = Save a database object.
(vi) F12 = Open the Save As dialog box.
Microsoft Access – Using a combo box or list box shortcuts
(i) F4 or ALT+DOWN ARROW = Open a combo box.
(ii) F9 = Refresh the contents of a Lookup field list box or combo box.
(iii) DOWN ARROW = Move down one line.
(iv) PAGE DOWN = Move down one page.
(v) UP ARROW = Move up one line.
(vi) PAGE UP = Move up one page.
(vii) TAB = Exit the combo box or list box.
Microsoft Access – Finding and replacing shortcuts
(i) CTRL+F = Open the Find tab in the Find and Replace dialog box
(ii) CTRL+H = Open the Replace tab in the Find and Replace dialog box
(iii) SHIFT+F4 = Find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed.