Microsoft Access

 

Ø        Microsoft Access  

Microsoft Access is a powerful database management application that enables you to store, manage, and manipulate large amounts of data. Here is a brief overview of how to use Access:

Ø Start by opening Microsoft Access and creating a new database or using an existing template.

Ø Create tables: To store data in Access, you need to create tables. You can do this by using the "Table Design" view, where you can define the fields, data types, and relationships between tables.

Ø Enter data: To enter data into your tables, you can use the "Datasheet" view. In this view, you can add, edit, and delete records just like you would in a spreadsheet.

Ø Create forms: Forms are an effective way to input and view data in Access. You can use the "Form Design" view to create custom forms that fit your specific needs.

Ø Create queries: Queries are used to extract specific information from your tables based on certain criteria. You can use the "Query Design" view to create and run queries.

Ø Create reports: Reports are used to present data in a structured and visually appealing format. You can use the "Report Design" view to create custom reports based on your data.

Ø Link to other data sources: Access enables you to link to data from other sources, such as Excel spreadsheets and text files. This makes it easy to integrate data from multiple sources into your Access database.

Ø Save and share your database: When you are ready, you can save your Access database and then share it with others. To share your database, you can save it as a shared Access database, or you can export the data to a different format, such as a PDF or Excel spreadsheet.

By using these basic steps, you can create a simple but effective Access database. Keep in mind that Access offers many more advanced features, such as creating macros and using SQL, that can help you create even more complex databases.

 

Shortcuts for MS Access

Ctrl + N = New Database

Ctrl + O = Open Database

Ctrl + S = Save Database

Ctrl + Shift + S = Save As Database

Ctrl + Alt + N = New Table

Ctrl + Alt + Q = New Query

Ctrl + Alt + F = New Form

Ctrl + Alt + R = New Report

Ctrl + Alt + P = New Page

Ctrl + F11 = Show/Hide Navigation Pane

Ctrl + Shift + N = New Object

Ctrl + Shift + T = Design Table

Ctrl + Shift + Q = Design Query

Ctrl + Shift + F = Design Form

Ctrl + Shift + R = Design Report

Ctrl + Shift + W = Design Page

Ctrl + Tab = Move Forward Through Tabs

Ctrl + Shift + Tab = Move Backward Through Tabs

Ctrl + Alt + T = Open Table in Datasheet View

Ctrl + Alt + Q = Open Query in Datasheet View

Ctrl + Alt + F = Open Form in Form View

Ctrl + Alt + R = Open Report in Print Preview

Ctrl + Alt + P = Open Page in Layout View

Ctrl + Alt + X = Open Macro Designer

Ctrl + Alt + M = New Macro

Ctrl + Alt + D = Design Macro

Ctrl + Alt + A = Run Macro

Ctrl + Alt + B = Debug Macro

Ctrl + Alt + U = Stop Macro

Ctrl + Alt + I = Step Into Macro

Ctrl + Alt + O = Step Over Macro

Ctrl + Alt + G = Step Out of Macro

Ctrl + Alt + R = Reset Macro

Ctrl + Alt + L = Log Macro Errors

Ctrl + Alt + C = Copy Object

Ctrl + Alt + V = Paste Object

Ctrl + Alt + X = Cut Object

Ctrl + Alt + D = Delete Object

Ctrl + Alt + Z = Undo Last Action

Ctrl + Alt + Y = Redo Last Undone Action

Ctrl + Alt + K = Spell Check

Ctrl + Alt + H = Help

Ctrl + Alt + P = Print

Ctrl + Alt + S = Save

Ctrl + Alt + F = Find

Ctrl + Alt + R = Replace

Ctrl + Alt + T = Go To

Ctrl + Alt + W = Close Database

Ctrl + Alt + Q = Quit MS Access

Ctrl + Alt + F4 = Exit MS Access