Access Course
– Next Training Center offers the advanced Access course and its use in the work related to databases. It is a program used to manage databases developed by Microsoft. The program comes with an accompanying Office suite, as Access provides several tools that can be used to familiarize yourself with the structure of databases
Based on the graduation of many students from the Academy in the previous batches and obtaining a job opportunity after graduating from
The course, the training course qualifies graduates directly to practice the profession upon graduation from the Academy
And obtaining a certificate that entitles them to practice the profession and open a business of their own
Training
Registration is open from the date you see this advertisement until you take a sufficient number.: Participants in the training course
Engineers / Accountants / Marketers / Executives / Heads of Departments / Secretaries / Store Secretaries / University Students in all their specializations and Institutes Alia / Anyone who wants to gain familiarity with the Access Program and its features.
__________________________________
The main themes of the training course:
Basic concepts of databases
data
the information
Database
Uses of databases
schedule
Database organization:
Table
Record
Field
Data Type
Field properties.
Primary Key
Index
relations
Define relationships
The goal of creating a relationship
Conditions for establishing the relationship
Types of relationships
Referential integrity
Database management operations
Preparing to create databases
Matters that must be met before creating the database
data analysis
Distribute them in tables according to their type
Users’ permissions
Database Administrator permissions
Dealing with the database
Open the databases application
Open a database …
Create and save a new, blank database
Database window components
Application interface
Close the databases application
Use Help Help
Access Objects:
Open Access Objects
Save Access Objects
Switch between object views
Close Access Objects
Delete Access Objects
Move between records and fields
Sorting records
Tables
• Records
Identify records
Add a record to the table
Delete a record from the table
Enter data into records and fields
Modification to the contents of the record
Delete record contents
Learn the properties of tables and modify them
Create share point lists
• the design
Create a new table in Design view
Create a table in Datasheet view
• fields
Define fields
• Field properties
Field size
Default value
Create a validation rule
Text of validation rule
Setting primary key
Indexing a field
• Format fields
In datasheet view
In Design view
Insert a field into a table in Design view. And in datasheet view.
Change the width of columns
Retrieving information in databases
Basic operations
search
Filter by selection
Filter by model
Remove the filter
Inquiries
Create a query from one table
Save and name the query
Create a query from two tables with a relationship
Run the query
Wildcard query
Add criteria to the query
Modify query criteria
Remove criteria from query
Modify a field (column) in the query
Add a new field
Remove a field (column) from a query
Move a field in the query
Hide / show field from query
Objects
Forms
Create a simple form
Save and name the form
Create a form using the Form Wizard
Create additional forms
Naming the model
Use the form to insert new records
Use the form to delete records
Use forms to add, modify, or delete record data
Modification of the form design
Display the form in the (Design View) view
Add text in the header or footer of the form
Modify text in the header or footer of the form
Change the height of the form header or footer
Use the macro
Macro concept
View macros
Macro recording
Open the Visual Basic Editor and modify it
Data transfer
Using an Access database
Using the share point for the database
: Analysis of database data
Database documentation
Performance analysis
Table analysis
Database Compact and Repair
Outputs
Create a simple report from a table or query
Save and name the report
Create a report and name it using the Report Wizard.
Save and name the report
Change the order of fields in the report layout
Change the order of the headers in the report layout
Editing reports
Grouping in report layout
Insert a mathematical function into the report
Add / modify text in report headers or footers
Export the table / query.
Display data as a pivot table. Pivot Table
Display data as a pivot chart. Pivot Chart
Determine the dependency of objects in the database
printing
_______________________
Those wishing to register must come to the company’s headquarters and confirm their reservation by paying the course fees
Fully and before we get enough (places are limited)
You can register by sending a text message to our numbers, or by sending it via Viber or WhatsApp
WhatsApp, or Telgram, and the message contains: Name, telephone number,
And the name of the course you wish to register for, on the numbers at the bottom of the announcement
You can contact us on Viber, Whatsapp, and Telegram at: 0928939481
Visit our page on Facebook
https://www.facebook.com/next.academic
Join us and Register:
https://nextacademy.ly/initial-registration/
